Search and find closest match

Results 1 to 3 of 3

Thread: Search and find closest match

  1. #1
    Arjan Crielaard Guest

    Default Search and find closest match

    I want to be able to let people eneter free text, then search a database for thet free text and dispaly the closest match, taking into consideration spelling errors and spaces and such

  2. #2
    Join Date
    Dec 1969

    Default Don't do it...honest...

    &nbsp;<BR>If you need to do something like this, go look at the Full Text search capabilities of SQL Server.<BR><BR>If you were to try to code this by hand, using *any* of the databases out there, you&#039;d be talking about a *VERY* slow and very tedious process, unless you are willing to build your own "full text index" of the DB, perhaps based on SoundEx codes to handle your spelling errors requirement.<BR><BR>If you don&#039;t know how big a job this is, then you aren&#039;t ready to tackle it. Honest. That is *not* arrogance or nastiness speaking. It is strictly the voice of "been there, done that." That&#039;s all.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Search and find closest match

    there is one very interesting article about this:<BR><BR><BR>which can also be found here:<BR><BR><BR>I am using this guys&#039; script which he had modified to fit non English languages as well

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts