Home Forums SQL Server 2008 T-SQL (SS2K8) Function for similar phrases RE: Function for similar phrases

  • April 5, 2013 at 7:16 am

    #1603888

    deepzzzz (4/5/2013)

    Thanks Sean for your post..

    For this example it works fine..

    Just consider these examples...

    'US Eastern District Court'

    'Southern District Court of US'

    For this also it is giving the same value. Actually both are different ..

    Court District Eastern US C630

    Court District of Southern US C630

    So how can I avoid this?

    SOUNDEX is actually pretty limited. I don't remember the exact algorithm it uses but I do remember that it was extremely limited. It was something like the first character of the string followed by some sort of very short checksum that didn't even include the whole phrase.

    If this is for a law office, you'd be much better off by buying a couple of products called (IIRC from one of my old jobs) "Attenex" and "Equiveo". They're built just for this type of thing and make simple full text searches look nearly as limited as SOUNDEX.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)