WORD_STEM()

All functions > STRING > WORD_STEM()

Returns the stem (root form) of a word using language-specific stemming rules.

Signatures

Returns: Stemmed (root) form of the word

WORD_STEM(word: VARCHAR, [language: VARCHAR]) → VARCHAR

Notes

• Uses Porter stemming algorithm
• Reduces words to their root form (e.g., 'running' → 'run')
• Language-specific rules applied
• Not all word forms stem perfectly (e.g., 'runner' may not stem)

Examples

SELECT
    f1 := WORD_STEM('running'), -- Stem running to run
    f2 := WORD_STEM('runs'), -- Stem runs to run
    f3 := WORD_STEM('runner'), -- May not stem all forms
    f4 := WORD_STEM('happiness'), -- Stem happiness
    f5 := WORD_STEM('cats'), -- Plural to singular
    f6 := WORD_STEM('running', 'en') -- English stemming
;