Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.multikabel.nl!newshub2.home.nl!newshub1.home.nl!home.nl!not-for-mail From: Frank van Bortel Newsgroups: comp.databases.oracle.server,microsoft.public.sqlserver.server Subject: Re: How to do a "fuzzy" or approximate matching of strings in a SQL where clause Date: Mon, 08 Aug 2005 21:05:12 +0200 Organization: @Home Benelux Lines: 22 Message-ID: References: <1123514686.757953.315070@g43g2000cwa.googlegroups.com> <1123511868.e647dc33c74835f95c58a2bd3345f028@bubbanews> <1123522291.474278.110070@g14g2000cwa.googlegroups.com> Reply-To: frank.van.bortel@gmail.com NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: news2.zwoll1.ov.home.nl 1123527505 8908 82.75.30.178 (8 Aug 2005 18:58:25 GMT) X-Complaints-To: usenet@corp.home.nl NNTP-Posting-Date: Mon, 8 Aug 2005 18:58:25 +0000 (UTC) User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <1123522291.474278.110070@g14g2000cwa.googlegroups.com> X-Enigmail-Version: 0.92.0.0 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249122 microsoft.public.sqlserver.server:340486 D Goyal wrote: > AFAIK soundex will check for similar sounding words. I am looking for > simillar phrases. > For example > 1. "SQL server help request" > 2. "Re: Re: SQL Server help request - followup" > 3. "FW: forwarded for your attention: SQL Server help request " > My application will be a helpdesk system where I want to check for > subject line, search for similar instances that happen in past and do > something. > > Thanks > Oracle Text indexing will do just that, and a whole lot more. Gists, Soundex (but better than SOUNDEX()!), proximity, multi language, multi column, multiple document type (finally you can search through all those Presentations and Documents, and get answers in seconds when searching for that one phrase!) -- Regards, Frank van Bortel