• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

Fuzzy Search SQl server 2005

We have a job search page on our website that takes a keyword and/or a location

is there a way using some sort of fuzzy search so for eg

if someone searched for "engineer" in "Manchester" and someone else searched "engieer" in "Machester" they'd get the same results???
0
leap29
Asked:
leap29
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
typing errors are not covered by neither full-text index nor other searches built-in in databases.

what you have to do is create a catalog of "typos", so that when a "wrong" word is written, the correct one can be suggested (like in google&co)
0
 
leap29Author Commented:
thanks for the reply, how do referance this catalog of typos from my aspx page??
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
that "catalog" would be a normal table, with (at least) 2 columns, 1 column for the "wrong" word, and 1 for the correct word.
and in your aspx page, you would have to first query for all the "wrong" words the user might have typed in, and return the "correct" version instead, and do the search instead, or suggest to use those for searching.

what exactly you want to do is "your" choice.
I can only tell you that full-text search finds "exact" matches.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now