Skip to main content
Version: Next

fuzzystrmatch

The fuzzystrmatch module provides functions that determine similarities and distance between strings, based on the Soundex, Levenshtein, Metaphone, and Double Metaphone algorithms.

The Apache Cloudberry fuzzystrmatch module is equivalent to the PostgreSQL fuzzystrmatch module. There are no MPP-specific considerations for the module.

Install and register the module​

fuzzystrmatch is built and installed by a default Apache Cloudberry build. Register the extension in each database in which you want to use it:

CREATE EXTENSION fuzzystrmatch;

Module documentation​

See fuzzystrmatch in the PostgreSQL documentation for details about the individual functions in this module.