SQL Search Statement like Google?

Question

Is there some kind of SQL expression that I could use to search for 1 column in my table that looks like what I'm looking for.

It’s as if I’m looking for something to do with “Auto,” but I pronounce it as “Kar,” he must return the items of the “car”.

Or

If I search for “my company,” and I call it “MyCompany,” she must still reconfigure “my company.”

Select * from TableName where Column Like '%company%'will return "my company", but I need more, because the user will not always know how to write. So I need something more advanced, like a small Google app or something like that.

Answer 1

, , , .

:

http://msdn.microsoft.com/en-us/library/ms187384.aspx

http://msdn.microsoft.com/en-us/library/ms142571.aspx

Answer 2

. SQL Server soundex, . SO-. ()

Answer 3

: http://googlesystem.blogspot.com/2007/04/simplified-version-of-googles-spell.html

, SQL, .

Answer 4

, , - - . : "", " " , , .

, jquery javascript. jQuery: http://plugins.jquery.com/plugin-tags/typeahead

Answer 5

. , ( ?). - .NET , (CREATE ASSEMBLY) sql .