Using SOUNDEX, How to match whole text.

Question

Using SOUNDEX, How to match whole text.

@nks

Mr or Mrs. 500

Points: 500
More actions
December 4, 2008 at 1:55 am

#103638

Hi,
I have a table which contains book names regarding computer courses.
eg. 1.Begins with Computer
2.Introduction of Computers
3.Course Book Vol 1
4.Course Book Vol 2 etc.
When user searches for 'Computer Courses Books', i want to throw all the above mentioned records.
But my SOUNDEX querry matches only 1st word i.e. 'Computer' and return few of them.
Is there any way to match whole string using SOUNDEX ?
Thanks & Regards.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

Hi Ankur

Please have a quick read of the link at the bottom of my post. We need a larger data set as test data, posted as a script to create the table and insert the data. We also need to know what the result should be when you search the dataset using specific strings.

Cheers

ChrisM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Andrew Gothard-467944 Hall of Fame Points: 3928 More actions · Answer 2

SOUNDEX is an algorithm which aims to return groups of results which "sound like" each other according to a calculation based on the first three calculated constonants in the word (explanation here http://www.kalendersysteme.de/english/genealogy/soundex.html).

It doesn't look exactly what you're looking for.

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 3

I agree with Andrew. Maybe full-text search would be a better fit for your situation?