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
;