Re: Merge rows based on Levenshtein distance

From: Michael Nolan <htfoot(at)gmail(dot)com>
To: mongoose <akarargyris(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Merge rows based on Levenshtein distance
Date: 2014-12-03 20:05:32
Message-ID: CAOzAqu+=gLa7wRMcacLtS5UGHhF6+UbWbNGN9yWKsqWo3fArXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Have you considered using a soundex function to sort names into similarity
groups? In my experience it works fairly well with Western European names,
not quite as well with names from other parts of the world. It also
doesn't deal well with many nicknames (Mike instead of Michael, etc.)

--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-12-03 20:28:59 Re: INSERT to partitioned table doesn't return row count
Previous Message Kris Deugau 2014-12-03 19:19:47 INSERT to partitioned table doesn't return row count