ERROR: function dmetaphone(unknown) does not exist

Question

I want similar function like soundex('anne')

dmetaphone('anne') when I am trying to execute above query . It will give following error.

ERROR: function dmetaphone(unknown) does not exist

Answer 1

You probably forgot to add the fuzzystrmatch extension. Make sure that the contrib modules are installed, then run the following as superuser

CREATE EXTENSION fuzzystrmatch;

Then the function will be defined.