soundex difference and percentage correct

[Richard Dillman-2]

Beginning my foray into Soundex and wondering how one might show the percentage of accuracy.

If I search for smith and return 4 names (Smith, smythe, smithe, smithers) only the first is 100% accurate. Id like to return 2 columns Names and a percentage of accuracy.  I'm using Sql Server 2005.

The example query I've found is below.

SELECT lname
FROM contacts
WHERE (DIFFERENCE(lname, 'smith' ) = 4)



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3142
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.6