> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-560f2a74.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).

<Info>
  **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';
  ```
</Info>

Columns:

* `name` ([String](/reference/data-types/index)) — 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    │
 │ [...]      │
 └────────────┘
```