On 8 Aug, 10:36, Dave <david.greenh...@praybourne.co.uk> wrote:
> Hi everyone,
>
> Can anyone give pointers on doing fuzzy searches in mysql.
>
> Currently when people are entering an address, it will check the town
> and county to make sure they match. However if they dont, then i want
> it to come back with a list of "possibilities"
>
> I have tried the MATCH / AGAINST and this sort of works, but will miss
> out some really good possibilites like this:
>
> There is a town called Brierley and a town called Briery
> There is a town called Brierley Hill and a town called Briery Hill
>
> If someone searched for Breirly then none of the above would come back
>
> Am i missing something obvious?
>
> Thanks in advance
> Dave



Me again, I managed to get soundex working (though the information on
MySQL website is not really helpful) This is bringing back a lot more
than anything else i tried, but now its too many and some which
shouldnt really be there.

Is there a way i can pipe the results through something else to narrow
it down?

Thanks
Dave.