November 6, 2002 at 11:23 am
Looking for an example using the Soundex function or similar string comparison functionality in TSQL. I am trying to look for similarities in text strings.
For example : A search on "Main St" would return -
Main St
Mayne St
Mane St
Formain St
Etc, etc, etc....
To my knowledge SOUNDEX and DIFFERENCE are not the best solutions for this type of search but I don't what else to use.
Does anyone have any better alternatives for this? Any help would be greatly appreciated.
Thanks.
November 6, 2002 at 12:25 pm
SOUNDEX() is relatively simplistic. You may look at Ken Henderson's improved comparison in his book The Guru's Guide to Transact SQL. Also, Full Text Indexing does have some ability to do forms of words and that sort but probably not to the extent you are looking for.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply