Re: Searching by Name

[CRPence <CRPbottle@xxxxxxxxx>]

On 19-Feb-2014 15:01 -0800, Holm, Paul wrote:
> Looking for insight  or recommendations or experiences with the
> following:
>
> A client has SQL based web application that searches multiple
> databases on different systems on many fields but in particular:
> NAME
>
> Issue:  User is looking for a person named "Joe", they type Joe into
> the search and don't get the full results because databases are
> storing the name as "Joseph".  Same thing with Nikki and Nicole.
>
> Obviously, we can use SQL wildcards % and LIKE so you could search by
> "Jo%" or "Ni%" but users may not do that.  I've started to analyze
> FULL TEXT searches.  Anyone already been down this road?

  Name variants are part of the information I offered in the following 
message [link], with reference to IBM InfoSphere Global Name Analytics 
and possibly also available for the site noted as providing a much 
smaller database:
<http://stackoverflow.com/questions/5596706/parsing-a-full-name-into-its-constituents>