Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!local01.nntp.dca.giganews.com!nntp.rogers.com!news.rogers.com.POSTED!not-for-mail NNTP-Posting-Date: Mon, 08 Aug 2005 13:55:28 -0500 Date: Mon, 08 Aug 2005 14:55:41 -0400 From: Mark Malakanov User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 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 References: <1123514686.757953.315070@g43g2000cwa.googlegroups.com> In-Reply-To: <1123514686.757953.315070@g43g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Lines: 19 NNTP-Posting-Host: 69.198.112.35 X-Trace: sv3-yDOGHZ2bUkCc8+l7MrBmk3oDRCymFtJZZoaLVKQdAROkR7XeZeTKCB1OFjvmhYyp6XkOSgEnpwNC2NA!pVBXBTA8rxQiGAU/rZb9SE0Rc3w12RWc8hlqdIaJ43yoWv+naJwr7yM64tZ0tyA3uyNafgwz X-Complaints-To: abuse@rogers.com X-DMCA-Complaints-To: abuse@rogers.com X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249121 microsoft.public.sqlserver.server:340484 You can look into Warehouse Builder OWB_MATCH_MERGE package, that allows to do couple of fuzzy matches. Fuctions are Similarity, Jaro_Winkler, JW_SIMILARITY, DOUBLE_METAPHONE, EDIT_DISTANCE. I suppose that purchase of 1 license of OWB is required to legally use this package on all databases in your enterprise. goyald@gmail.com wrote: > Hello > My input data consists of a string field. I need to find rows where > this string field is matching "approximately"!! i.e. I need some kind > of a fuzzy match. > > Is there any such inbuilt facilitty/function in SQLServer or Oracle? > > Thanks and regards >