SQL Server - Percent based Full Text Search
Posted
by Sukhminder Singh
on Stack Overflow
See other posts from Stack Overflow
or by Sukhminder Singh
Published on 2010-05-12T07:36:50Z
Indexed on
2010/05/12
8:54 UTC
Read the original article
Hit count: 227
sql-server
|full-text-search
Hi
I want to conduct search on a particular column of a table in such a way that returning result set should satify following 2 conditions:
Returning result set should have records whose 90% of the characters matches with the given search text.
Returning result set should have records whose 70% of the consecutive characters matches with the given search text.
It implies that when 10 character word Sukhminder is searched, then:
it should return records like Sukhmindes, ukhminder, Sukhmindzr, because it fulfils both of the above mentioned conditions.
But it should not return records like Sukhmixder because it does not fulfil the second condition. Likewise, It should not return record Sukhminzzz because it does not fulfil the first condition.
I am trying to use Full Text Search feature of SQL Server. But, could not formulate the required query yet. Kindly reply ASAP.
© Stack Overflow or respective owner
