Searching for the Inflectional Form of a Specific Word (Generation Term)
You can search for all the different tenses of a verb or both the singular and plural forms of a noun. For example, the query shown in this topic searches for any form of "foot" ("foot", "feet", and so on) in the Comments column of the ProductReview table.
Note that Full-Text Search uses stemmers. Stemmers allow you to search for the different tenses of a verb, or both the singular and plural forms of a noun. For example, this query searches for any form of "foot" ("foot", "feet", and so on) in the Comments column of the ProductReview table. For more information about stemmers, see Word Breakers and Stemmers.
USE AdventureWorks2008R2;
GO
SELECT Comments, ReviewerName
FROM Production.ProductReview
WHERE CONTAINS (Comments, 'FORMSOF(INFLECTIONAL, "foot")');
GO