X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 5AF3CD1B507
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Nov 2003 05:21:56 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 19658-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 14 Nov 2003 01:21:25 -0400 (AST)
Received: from pmserver.parabolemaurice.com (unknown [202.123.29.194])
	by svr1.postgresql.org (Postfix) with ESMTP id A9905D1B531
	for <pgsql-sql@postgresql.org>; Fri, 14 Nov 2003 01:21:20 -0400 (AST)
Received: by PMSERVER with Internet Mail Service (5.5.2657.72)
	id <W59LH7K6>; Fri, 14 Nov 2003 09:30:28 +0400
Message-ID: <94BCF3512BFBD711B79D004005420B1F0863DD@PMSERVER>
From: Gulshan Babajee <gulshan.babajee@parabolemaurice.com>
To: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: Compare strings which resembles each other
Date: Fri, 14 Nov 2003 09:30:27 +0400
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/242
X-Sequence-Number: 16057

Hy, I have a table containing some rows. Each row contains a field name
which is of type String.

For example:
in row1 string1 is "Adieu Poulet",
in row2 string2 is "Adieu a Poulet",
in row3 string3 is "Adiue Poulet",
in row4 string4 is "Adieu Pouleet", etc..
(That is each string resembles each other a bit, they are somewhat similar
to each other)

What type of query should I make so as it return me all these string. That
is I watn a query which return me strings which are similar or somewhat
similar to each other.

thanks in advance
gulshan