Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 137DB2E0046
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Wed, 16 Apr 2008 00:15:53 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 11364-05
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Wed, 16 Apr 2008 00:15:47 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by developer.postgresql.org (Postfix) with SMTP id B75022E0030
	for <pgsql-sql@postgresql.org>; Wed, 16 Apr 2008 00:15:45 -0300 (ADT)
Received: (qmail invoked by alias); 16 Apr 2008 03:15:44 -0000
Received: from i3ED6CB12.versanet.de (EHLO [192.168.0.112]) [62.214.203.18]
	by mail.gmx.net (mp056) with SMTP; 16 Apr 2008 05:15:44 +0200
X-Authenticated: #14269776
X-Provags-ID: V01U2FsdGVkX1+GWvdnv2aG8oY/ND9fYBrBl1mKif8OFhGeWmL3Xj
	0QRYLohO2D1ixB
Message-ID: <48056F5F.30507@gmx.net>
Date: Wed, 16 Apr 2008 05:15:43 +0200
From: Andreas <maps.on@gmx.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT;
	rv:1.8.1.13) Gecko/20080313 SeaMonkey/1.1.9
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: How to find double entries
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/86
X-Sequence-Number: 30625

Hi,

how can I find double entries in varchar columns where the content is 
not 100% identical because of a spelling error or the person considered 
it "looked nicer" that way?

I'd like to identify and then merge records of e.g.   'google', 'gogle', 
'guugle' 

Then I want to match abbrevations like  'A-Company Ltd.', 'a company 
ltd.', 'A-Company Limited'

Is there a way to do this?
It would be OK just to list candidats up to be manually checked afterwards.


Regards
Andreas