---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: splink_udfs
excerpt: |
  DuckDB Community Extensions
  Phonetic, text normalization and address matching functions for record linkage.

extension:
  name: splink_udfs
  description: Phonetic, text normalization and address matching functions for record linkage.
  version: 0.0.11
  language: C++
  build: cmake
  license: MIT
  maintainers:
    - RobinL

repo:
  github: moj-analytical-services/splink_udfs
  variegata: cf00056f887486d0aee0a853a764f9775aa40438
  ref: c5b384ba3a62ea016e23c4fd408e012921595ea0

docs:
  hello_world: |
    LOAD splink_udfs;
    SELECT soundex(unaccent('Jürgen'));  -- returns 'J625'
  extended_description: |
    The splink_udfs extension provides functions for data cleaning and phonetic matching.

    Includes `soundex(str)`, `strip_diacritics(str)`, `unaccent(str)`,
    `ngrams(list,n)`, `double_metaphone(str)`
    and faster versions of `levenshtein` and `damerau_levenshtein`.

extension_star_count: 7
extension_star_count_pretty: 7
extension_download_count: 30499
extension_download_count_pretty: 30.5k
image: '/images/community_extensions/social_preview/preview_community_extension_splink_udfs.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Linux ARM64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| macOS AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| macOS ARM64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Windows AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ✅ | ✅ | ✅ | ✅ | ✅ |

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

|      function_name       | function_type | description | comment | examples |
|--------------------------|---------------|-------------|---------|----------|
| _get_nicknames           | scalar        | NULL        | NULL    |          |
| double_metaphone         | scalar        | NULL        | NULL    |          |
| ngrams                   | scalar        | NULL        | NULL    |          |
| nickname_lookup_versions | table         | NULL        | NULL    |          |
| soundex                  | scalar        | NULL        | NULL    |          |
| strip_diacritics         | scalar        | NULL        | NULL    |          |
| unaccent                 | scalar        | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

|    function_name    | function_type |                                                                                                                                                                        description                                                                                                                                                                        | comment |                 examples                  |
|---------------------|---------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------|-------------------------------------------|
| damerau_levenshtein | scalar        | Extension of Levenshtein distance to also include transposition of adjacent characters as an allowed edit operation. In other words, the minimum number of edit operations (insertions, deletions, substitutions or transpositions) required to change one string to another. Characters of different cases (e.g., `a` and `A`) are considered different. | NULL    | [damerau_levenshtein('duckdb', 'udckbd')] |
| levenshtein         | scalar        | The minimum number of single-character edits (insertions, deletions or substitutions) required to change one string to the other. Characters of different cases (e.g., `a` and `A`) are considered different.                                                                                                                                             | NULL    | [levenshtein('duck', 'db')]               |

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

|      name      |                       description                       | input_type | scope  | aliases | typed_value |
|----------------|---------------------------------------------------------|------------|--------|---------|-------------|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR    | GLOBAL | []      | post.db.tmp |