April 2, 2002 at 12:50 am
Hello
I have a customer table with many duplicate records. Many times the companyname is misspelled, but the built-in soundex algorithem does not help me much.. Are there any other algorithems?
Regards,
Marco
April 2, 2002 at 5:09 am
We experimented some with tweaking Soundex, never really got what we wanted. Our situation was primarily with first names, we ended up building an alias list where Bob mapped to Robert, Bill to William, etc.
Andy
April 2, 2002 at 5:13 am
Nothing in SQL itself that will do this any better. You might check for a third party app but most use roughly the same algorithem but may have data dictionarys to provide extended search like Andy was trying.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 2, 2002 at 11:38 am
Ken Henderson in his book Guru's Guide to Transact-SQL actually takes a look at Soundex and makes a few modifications. You may want to have a look there.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply