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 |
|
Onamuji
Aged Yak Warrior
504 Posts |
 Posted - 2002-02-08 : 10:41:09
|
Ok so say I have those functions from Guru's Guide to TSQL book and I want to find a word in a descriptive field that sort of matches... example... say I have a list of interestscomputers, sql, asp, .net, etc.. say this list is pretty big, 2500+ interests... and then there are words that can be spelled differently but are the same thing... (we'll just assume they sound the same) symplified, simplified, these interests are user specified and since not everyone has perfect spelling techniques I would like to offer to the user a word that matches if they are found ... also I want to search and link the different interests .... Say a user (u1) specified an interest complexities and another user (u2) spells it complexitys ... just because they can't spell... I want to link these two saying something like you may find this user interesting , vs another user (u3) who spells it the same as u2. That message would say, you most likely will find this user interesting... Hope I made myself clear, maybe there is a better way to do this than using SOUNDEX and/or DIFFERENCE ... suggestions, comments, etc. welcomed. :-) ... Onamuji |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-08 : 10:45:16
|
| You might be able to modify Merkin's technique:http://www.sqlteam.com/item.asp?ItemID=5857You'd have to parse out the search column, and then Soundex() each word, but it should be pretty easy to do. Then you can put the Difference() expressions in the WHERE clause. The nice thing is that it'll rank the search results too...which is pretty cool! Ranked Soundex() matches! |
 |
|
|
|
|
|
|
|
Searching With SOUNDEX and DIFFERENCE