Link to home
Start Free TrialLog in
Avatar of willa666
willa666Flag for United States of America

asked on


I was wondering how i can pull a data set from a word list table in my database where the words are like/associated with the word i define.

I kno wthat it is not a simple SQL query but i kno wthat their must be a coupl eof ways of doing it.

Avatar of DireOrbAnt

Are you using Microsoft SQL Server? You could use Full-Text search, you could use SOUNDEX() or DIFFERENCE(). Look them all up in BOL.
Now, that might give you "like" and some "associated" words, but if you need to search for synonyms, you'll need to build or import a list of those.
Then you can still use FT search and map back to the main keyword.
Avatar of ksbhat

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial