A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.


The fuzzystrmatch module provides functions to determine similarities and distance between strings based on various algorithms.

The Greenplum Database fuzzystrmatch module is equivalent to the PostgreSQL fuzzystrmatch module. There are no Greenplum Database or MPP-specific considerations for the module.

Installing and Registering the Module

The fuzzystrmatch module is installed when you install Greenplum Database. Before you can use any of the functions defined in the module, you must register the fuzzystrmatch extension in each database in which you want to use the functions. Refer to Installing Additional Supplied Modules for more information.

Module Documentation

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