From: Lou Vanek <vanek@...>
Date: 2005-12-05T06:21:47+09:00
Subject: Re: Fuzzy Searching a Database

this was discussed on both this ML and the Rails ML about a week ago. The
threads have the word 'fuzzy' in the subject.

TomRossi7 wrote:

> How would you recommend implementing something like a fuzzy search with
> Ruby and a SQL database.  For example, I want to search a field in a
> table for anything that is similar to "Frank Smithe".  I would want an
> array of matches with some sort of score telling me how good of a match
> the item received ("frank smithe" 100%, "frank smith" 90%).
> 
> Am I making sense?  Is there a third party app I would need?
> 
> Thanks,
> Tom
> 
> 
>