On 12/04/2017 15:55, Ken Dibble wrote:
<snip>
I'm looking for suggestions on how to produce results that include
close matches on last names that doesn't require pre-processing.
About 20 years ago I did some work on marketing databases and one of the
big tasks is de-duping data. We did things like substituting vowels
with a * in the search value, then you get a more general match that
avoids some spelling mistakes. Unfortunately approaches like this would
require you to store the processed data.
Do you have the surname is a separate field with an index? If so you
could show the results of matches in a box below the search which
changes as they type each letter. The user can then see the list going
smaller as they type and will hopefully see what they are looking for.
If they have typed the whole name in and can't see the match they can
remove letters to look for a partial match. I would only match from say
the 3rd character or more as it may be too slow to display all the matches.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR.
Tel:0161 831 3700
Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
