I have created a full text catalog for a column under database name -> "Storage" -> Full Text Catalogs. It is accent sensitive and "default catalog" is set to false. The language for the column "SearchData" is set to swedish.
I am using a stored procedure that calls the contains function like this:
CREATE PROCEDURE [dbo].[SearchPages]
@Term varchar(200)
AS
BEGIN
SELECT pc.SearchData from PageContent pc
where contains(pc.SearchData, @Term)
END
When I search för "smörgås" (swedish för "sandwich"), I hit on "smörgåsbord", but not on "smörgåsar" (swedish for "sandwishes").
Apparently, it only hits on words that are compositions containing the search term, but not on plural forms.
Our customers want to search putting a singular form in the search box.
Is that possible to obtain?
It would also be nice if you could search for "goose" and find "geese".
Best Answer
You could use either CONTAINS with FORMSOF(INFLECTIONAL, smörgås) or FREETEXT
CONTAINS:
FREETEXT (includes INFLECTIONAL and some other stuff automatically):