Implement a "Suggest correct spelling" or "Did you mean" feature

jason2li

Member
Joined
Nov 18, 2005
Messages
22
Location
St. Louis, MO
Programming Experience
5-10
I am trying to write a search script for my company's website. I know how to search using the basics, like:
VB.NET:
SELECT * FROM myTable WHERE myColumn LIKE '%what%ever%';
and such, but I would like to implement some sort of "did-you-mean" feature, similar to Google.

So, if a user misspells something, it will return to them the best possible match.

I have written a VB.NET script that can do this for me, but it's not as fast as I'd like. Is there something within SQL that can handle this? Or do I need to build up a "misspelling" table in the database and continuously add to that?

Thanks in advance!
 
Back
Top