On Thursday, 14 November, 2019 09:35, Eric <e...@deptj.eu> wrote: >On Thu, 14 Nov 2019 00:24:09 +0000 SQLite mailing list >sqlite-users@mailinglists.sqlite.org said
>> A growing number of organisations now ask me for my DOB or my postcode, >> rather than my name, when looking me up. I think you just explained >> why. In my country we have an increasing number of foreign family names, >> which probably helps it along. >UK postcodes are incredibly fine-grained, compared to most of the rest of >the world, where they would be much less useful for identification. Bounding the search space to displaying a handful of names is better then guessing how someone else decided to spell something. It is quite obvious how that someone spelled "schmidt" as "chmit" when one is looking at a list of names associated with a given post code because you are now using a bag-of-mostly-water to intelligently choose from amongst a small list of candidates (a few hundred lets say) rather than the electronic precision of an index lookup. Similar results could be achieved "the old fashioned way" by presenting the user with a list of candidates matching the soundex, but this does not always work and may often not narrow down the selection list sufficiently to help the bag-of-mostly-water discern the name. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users