Large library systems or consortium are seeing issues with patron name searches. For example, if staff look for a patron with the name of "John Smith" the autocomplete feature will show the first 10 results of patrons with the name "John Smith" or similar names like "Johnny Smith". However, if they search for a name such as "Mary Maryilyn" the search will not pull up the correct patron. The autocomplete will pull up names with "Mary" or "Maryilyn" but not the name itself. A regular patron search will also result in several pages of results instead of the one unique name.
The problem here is our patron searches are not weighted. We simply gather all patrons that match the search criteria and sort them by firstname and lastname. We need to do weighted searching. We could do something like use Elastic for indexing and searching patron data, or we could do something like https://stackoverflow.com/questions/6496866/best-way-to-do-a-weighted-search-over-multiple-fields-in-mysql
Also https://www.perl.com/pub/2003/09/25/searching.html/