jason2li
Member
I am trying to write a search script for my company's website. I know how to search using the basics, like:
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!
VB.NET:
SELECT * FROM myTable WHERE myColumn LIKE '%what%ever%';
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!