> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table which shows all available stemmers.

# system.stemmers

<h2 id="description">
  Description
</h2>

Shows all available stemmers.
These can be used in the function [stem](/reference/functions/regular-functions/nlp-functions).

**Availability**

`system.stemmers` is present only in ClickHouse builds compiled with the `libstemmer` dependency (`USE_LIBSTEMMER`). On builds without it, the table does not exist and queries against it will fail with `UNKNOWN_TABLE`. You can check whether your build has it enabled with:

```sql theme={null}
SELECT value FROM system.build_options WHERE name = 'USE_LIBSTEMMER';
```

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types/string)) — Identifier of the Snowball stemmer (language/algorithm)

<h2 id="example">
  Example
</h2>

```sql theme={null}
SELECT * FROM system.stemmers;
```

```text theme={null}
 ┌─name───────┐
 │ arabic     │
 │ armenian   │
 │ basque     │
 │ catalan    │
 │ danish     │
 │ dutch      │
 │ english    │
 │ [...]      │
 └────────────┘
```