Re: How to find double entries

<p><font size="2">Hi,<br /><br /> In a recent linux magazine article (<a
href="http://www.linux-mag.com/id/5679">http://www.linux-mag.com/id/5679</a>)<br/> there was a mentioning of Full-Text
SearchIntegration.  Which I know<br /> nothing about, but sounded interesting to me.  You might want to<br /> check it
out.<br/><br /> Regards,<br /><br /> Tena Sakai<br /> tsakai@gallo.ucsf.edu<br /><br /><br /> -----Original
Message-----<br/> From: pgsql-sql-owner@postgresql.org on behalf of Andreas<br /> Sent: Tue 4/15/2008 8:15 PM<br /> To:
pgsql-sql@postgresql.org<br/> Subject: [SQL] How to find double entries<br /><br /> Hi,<br /><br /> how can I find
doubleentries in varchar columns where the content is<br /> not 100% identical because of a spelling error or the
personconsidered<br /> it "looked nicer" that way?<br /><br /> I'd like to identify and then merge records of e.g.  
'google','gogle',<br /> 'guugle'<br /><br /> Then I want to match abbrevations like  'A-Company Ltd.', 'a company<br />
ltd.','A-Company Limited'<br /><br /> Is there a way to do this?<br /> It would be OK just to list candidats up to be
manuallychecked afterwards.<br /><br /><br /> Regards<br /> Andreas<br /><br /> --<br /> Sent via pgsql-sql mailing
list(pgsql-sql@postgresql.org)<br /> To make changes to your subscription:<br /><a
href="http://www.postgresql.org/mailpref/pgsql-sql">http://www.postgresql.org/mailpref/pgsql-sql</a><br/><br /></font>