DuckDB Extensions
Indel functions in the RapidFuzz DuckDB extension
Function category
Indel
4 functionsInsertion-and-deletion edit distance — no substitutions counted.
Signature
rapidfuzz_indel_distance(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Argument
col1
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Insertions+deletions to transform one string into another (no substitutions). Raw count of edits required.
Related functions
- rapidfuzz_indel_similarity() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_normalized_distance() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_normalized_similarity() — Insertions+deletions to transform one string into another (no substitutions)
Signature
rapidfuzz_indel_normalized_distance(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Argument
col1
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Insertions+deletions to transform one string into another (no substitutions). Edit distance scaled to [0, 1] — 0 means identical.
Related functions
- rapidfuzz_indel_distance() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_similarity() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_normalized_similarity() — Insertions+deletions to transform one string into another (no substitutions)
Signature
rapidfuzz_indel_normalized_similarity(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Argument
col1
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Insertions+deletions to transform one string into another (no substitutions). Similarity scaled to [0, 1] — 1 means identical.
Related functions
- rapidfuzz_indel_distance() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_similarity() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_normalized_distance() — Insertions+deletions to transform one string into another (no substitutions)
Signature
rapidfuzz_indel_similarity(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
VARCHAR
|
Mode Positional | Description |
Argument
col1
|
Type
VARCHAR
|
Mode Positional | Description |
Description
Insertions+deletions to transform one string into another (no substitutions). Raw count of matches.
Related functions
- rapidfuzz_indel_distance() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_normalized_distance() — Insertions+deletions to transform one string into another (no substitutions)
- rapidfuzz_indel_normalized_similarity() — Insertions+deletions to transform one string into another (no substitutions)