> >
> > OK so I think you are asking for fuzzy logic searches... is that
> correct?
> > Alan
> >
>
> Yes

well, you know of course that Google are making billions of dollars from
their proprietary search algorithms....they don't tell us mortals their
secrets..
but ibphoenix.com may have some interesting things.
otherwise you can start by doing something like
take a few 'random' substrings of the supplied search string, then issue a
select on the field
WHERE FIELD CONTAINING randomstring1 OR FIELD CONTAINING randomstring2 OR
FIELD CONTATING randomstring3

you get the drift I'm sure.
the more OR clauses the more matches.
Alan