Re: how to make fuzzy search on ntext field

Ray wrote on Mon, 4 Sep 2006 07:51:01 -0700:

Since difference and soundex functions can't be used with ntext.
How can i make fuzzy search to a fully indexed text database field that
has ntext as data type ?

any special tricks ? or do i have to change it to nvarchar to make it work
?

Depends on how "fuzzy" you want it to be. You can use the FREETEXT search
method using FTS (Full Text Search), this handles word stemming which is
more fuzzy than the more exact CONTAINS method. However, this does not
handle difference or soundex, these are not specific to FTS and so this is
the wrong newsgroup for programming using these (however, you may well find
that some of the FTS users here also use difference and soundex in their
solutions).

Dan


.

Loading