SQL Server FullTextSearch FREETEXT does not return expected results

637 Views Asked by At

I have the following sql server query

SELECT * 
FROM [dbo].Client
WHERE FullName LIKE '%Lind%'

Which returns the following row:

enter image description here

When I run the following Full Text Search query that row is not returned

SELECT * 
FROM [dbo].Client
WHERE FREETEXT(FullName, 'Lind')

Why does this happen? FREETEXT is supposed to match and return this row.

1

There are 1 best solutions below

5
On
SELECT * 
FROM [dbo].Client
WHERE CONTAINS(FullName,'"Lind*"') ; --prefix of word: prefix+asterisk in double quotes