WORD_STEM
All functions > STRING > WORD_STEM
Returns the stem (root form) of a word using language-specific stemming rules.
Syntax
WORD_STEM(expr, lang)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
word | VARCHAR | Yes | Word to stem |
language | VARCHAR | No | Language code for stemming rules (optional, defaults to 'en') |
Returns
Stemmed (root) form of the word
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)