Searching for Any 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, this query searches for any form of dry (dry, dried, drying, and so on) in the Description column of the Categories table.

USE Northwind

GO

SELECT Description, CategoryName

FROM Categories

WHERE CONTAINS (Description, 'FORMSOF(INFLECTIONAL, "dry")')

GO

Note that a single term cannot be used to match both nouns and verbs in the same query.