I need to search a data base column in a table for a "fuzzy match" (we are using SQL Server 2005). We have a table of organizations and the user searches entering the organization name in a form field.
Someone keys in an organization name of :
I don't think Full Text Search handle "typos". So Microsoft would not be found.
Note: If you key this into most search engines, they come back with:
Showing results for microsoft
They have the "fuzzy logic" search that I'd like to use on a table.
The server side code is in ColdFusion
Thanks in advance,