| Oracle8i interMedia Text Reference Release 2 (8.1.6) Part Number A77063-01  | 
  | 
Query Operators, 17 of 26
Use the stem ($) operator to search for terms that have the same linguistic root as the query term.
The iMT stemmer, licensed from Xerox Corporation's XSoft Division, supports the following languages: English, French, Spanish, Italian, German, and Dutch.
| Syntax | Description | 
|---|---|
| 
 $term  | 
 Expands a query to include all terms having the same stem or root word as the specified term.  | 
| Input | Expands To | 
|---|---|
| 
 $scream  | 
 scream screaming screamed  | 
| 
 $distinguish  | 
 distinguish distinguished distinguishes  | 
| 
 $guitars  | 
 guitars guitar  | 
| 
 $commit  | 
 commit committed  | 
| 
 $cat  | 
 cat cats  | 
| 
 $sing  | 
 sang sung sing  | 
If stem returns a word designated as a stopword, the stopword is not included in the query or highlighted by CTX_QUERY.HIGHLIGHT or CTX_QUERY.MARKUP.
| 
 | 
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved.  | 
 
  |