Improve name searching on Students

[Brian Lewis]

Principally this is motivated by the need to reconcile the students list to the names independently collected in the Exams system.

‌

[Brian Lewis]

Implementation (open to discussion) is as follows:

‌

– if Given Name and/or Family Name is entered into search window without wild card, an exact match search is performed.

If either given name or Family Name contains a * , then this triggers a fuzzy search.

The search will then match using

1. Like, rather than = , respecting the wild card entered by the user
2. Soundex - will match on Soundex
3. Swap - will match on a swap of Given and Family Names, the match may be = or ‘like’ or soundex.

If a fuzzy search is used, the results are forced into a search order showing the ‘best’ matches first; e.g. exact matches, then like, then swap, then soundex

‌

‌

[Brian Lewis]

feat(students): "fuzzy" searching on student name

Resolves #1146

→ <<cset 595c03635719>>