stem ($)

Use the stem ($) operator to search for terms that have the same linguistic root as the query term.

If you use BASIC_LEXER to index your language, then you can improve stemming performance by using the index_stems attribute of BASIC_LEXER.

Japanese stemming is supported with JAPANESE_LEXER.

Specify your stemming language with the BASIC_WORDLIST wordlist preference.

Syntax

Syntax	Description
$term	Expands a query to include all terms having the same stem or root word as the specified term.

Examples for Stem ($) Operator

Input	Expands To
$scream	scream screaming screamed
$distinguish	distinguish distinguished distinguishes
$guitars	guitars guitar
$commit	commit committed
$cat	cat cats
$sing	sang sung sing

Behavior with Stopwords

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.

Related Topics

• BASIC_LEXER Attributes

• BASIC_WORDLIST

• JAPANESE_LEXER

• Oracle Text Indexing Elements