News for hackers. Stuff that matters.
Re:The state of full text search in PostgreSQL 12 by combatentropy on Monday February 03, 2020 @08:37PM (#22231481)
Have you looked into Soundex or Metaphone? I myself have not used them. I just saw them mentioned in PHP's function list and thought they might be useful some day.

- https://www.php.net/manual/en/function.soundex.php

- https://www.php.net/manual/en/function.metaphone.php

PostgreSQL has an extension, fuzzystrmatch, that uses the same algorithms:

- https://www.postgresql.org/docs/12/fuzzystrmatch.html

But it warns that the functions "do not work well with multibyte encodings (such as UTF-8)." So maybe first translate any such characters to ASCII?

Re:The state of full text search in PostgreSQL 12 by bmn__ on Tuesday February 04, 2020 @12:41PM (#22238483)
These only work with English, so not a general solution. There are more modern, better tools for the problem.