Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-02-06 : 05:51:09
|
| Hi guys and gals (in case Tara reads this...)We've installed this on our server:http://microsoft.apress.com/feature/72/sql-server-soundexing(all the udf attempts were way too slow; this uda is nice and quick)But we have not been able to reproduce the supposed improved functionality. No matter what misspelled name we send it, soundex and soundex_nara return the same amount of clients (in a db of over half a million). The return codes are sometimes different for the two functions but it doesnt ever result in an actual difference in query results. Has anyone actually experienced a difference in returned results?EDIT:Have a look at this:http://en.wikipedia.org/wiki/Levenshtein_distance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Really better soundex?