Using SOUNDEX to match individual words within Text fields
Posted on 2007-04-10
I have a table which contains a Text fields containing course information.
I am constructing a 'fuzzy search' stored procedure which will match words within this field based on what was entered into a web front end.
The part I am finding difficulty with is matching on mis-spelled words
I thought I could use SOUNDEX for this but it only appears to be finding matches where the first word of the Text field is the word I am looking for.
So, for example, my search value is 'compter course' (note it is mis-spelled)
There are records in my DB which have text field value of 'Computers for beginners' and 'An introduction to computers'
My SOUNDEX query partly does the job but only the first record is matched :(
Is there a way to use SOUNDEX across all words in the text field or is ther another approach I can look at?
I am using SQL 2005