Provides adds high-performance fuzzy string matching functions, powered by the RapidFuzz C++ library.
Maintainer(s):
rustyconover
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, 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.
| 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
INSTALL rapidfuzz FROM community;
LOAD rapidfuzz;
About rapidfuzz
For more information regarding usage, see the documentation.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| rapidfuzz_hamming_distance | scalar | NULL | NULL | |
| rapidfuzz_hamming_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_hamming_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_hamming_similarity | scalar | NULL | NULL | |
| rapidfuzz_indel_distance | scalar | NULL | NULL | |
| rapidfuzz_indel_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_indel_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_indel_similarity | scalar | NULL | NULL | |
| rapidfuzz_jaro_distance | scalar | NULL | NULL | |
| rapidfuzz_jaro_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_jaro_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_jaro_similarity | scalar | NULL | NULL | |
| rapidfuzz_jaro_winkler_distance | scalar | NULL | NULL | |
| rapidfuzz_jaro_winkler_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_jaro_winkler_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_jaro_winkler_similarity | scalar | NULL | NULL | |
| rapidfuzz_lcs_seq_distance | scalar | NULL | NULL | |
| rapidfuzz_lcs_seq_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_lcs_seq_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_lcs_seq_similarity | scalar | NULL | NULL | |
| rapidfuzz_osa_distance | scalar | NULL | NULL | |
| rapidfuzz_osa_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_osa_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_osa_similarity | scalar | NULL | NULL | |
| rapidfuzz_partial_ratio | scalar | NULL | NULL | |
| rapidfuzz_partial_token_set_ratio | scalar | NULL | NULL | |
| rapidfuzz_postfix_distance | scalar | NULL | NULL | |
| rapidfuzz_postfix_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_postfix_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_postfix_similarity | scalar | NULL | NULL | |
| rapidfuzz_prefix_distance | scalar | NULL | NULL | |
| rapidfuzz_prefix_normalized_distance | scalar | NULL | NULL | |
| rapidfuzz_prefix_normalized_similarity | scalar | NULL | NULL | |
| rapidfuzz_prefix_similarity | scalar | NULL | NULL | |
| rapidfuzz_ratio | scalar | NULL | NULL | |
| rapidfuzz_token_set_ratio | scalar | NULL | NULL | |
| rapidfuzz_token_sort_ratio | scalar | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.