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=89.70.6
