Accessing and Changing Relational Data
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.