Fuzzy Search SQl server 2005

Posted on 2009-02-19
Last Modified: 2012-05-06
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???
Question by:leap29
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    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)

    Author Comment

    thanks for the reply, how do referance this catalog of typos from my aspx page??
    LVL 142

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now