The thesaurus operator searches for documents containing a synonym for a search element. For example, you might perform a search using the word “dog,” looking for documents that use any of its synonyms (“canine,” “pooch,” “pup,” “watchdog,” and so on). Each result is relevance-ranked.
The Full-Text Search engine supplies a default thesaurus. With the Enhanced Full-Text Search engine, you can create a custom thesaurus. For more information, see “Creating a Custom Thesaurus (Enhanced Version Only)”.
The following example uses the thesaurus operator to find a result set that contains synonyms for the word “crave.” The first document is selected because it contains the word “want”; the second, because it contains the word “hunger”:
select t2.copy from i_blurbs t1, blurbs t2 where t1.id=t2.id and t1.index_any = "<thesaurus>(crave)"
score copy
----- -----------------------------------------------------------
78 They asked me to write about myself and my book, so here
goes: I started a restaurant called “de Gustibus” with two
. . .
of restaurant over another, when what they really want is a
. . .
78 A chef’s chef and a raconteur’s raconteur, Reginald
Blotchet-Halls calls London his second home. "Th’ palace
. . .
his equal skill in satisfying our perpetual hunger for
. . .
