stem

The stem operator searches for documents containing the specified word and its variations. For example, if you specify the word “cook,” the Enhanced Full-Text Search engine produces documents that contain “cooked,” “cooking,” “cooks,” and so on. To relevance-rank the result set, include the many modifier in the query. See “Operator modifiers”.

The following query uses the stem operator to find documents that contain variations of the word “create,” that is, words that contain the word “create” as a stem. Notice that even though the first document contains a word in which “create” is not a perfect stem (“creative”), the document is still selected:

select t1.score, t2.copy
from i_blurbs t1, blurbs t2
where t1.id=t2.id and t1.score > 10
and t1.index_any = "<many><stem>create"
score     copy 
-----    ----------------------------------------------------
78    Anne Ringer ran away from the circus as a child.  A
    university creative writing professor and her family
    . . . 
78    If Chastity Locksley didn’t exist, this troubled world
    would have created her!  Not only did she master the mystic