In superuser dashboard's Users page, searching for accounts with certain types of names returns no results

What steps does it take to reproduce the issue?

• When does this issue occur?
  When searching in the superuser dashboard's "Users" page for Dataverse accounts with certain types of names, including names that have more than three words, such as names that include middle names (John Paul Stevens), or names that have a last name with a single quote (John O'Henry)

• Which page(s) does it occurs on?
  The superuser dashboard's "Users" page

• What happens?
  When searching for such names, for example John Paul Stevens, no results are found. Searching for John Paul will return acconts with the name John Paul Stevens (plus any other accounts that include John Paul), but adding (space)Stevens will return no results.

• To whom does it occur (all users, curators, superusers)?
  superusers

• What did you expect to happen?
  Results are found when searching for these types of names

Which version of Dataverse are you using?
v6.2, 5.10.1 and 5.11

Any related open or closed issues to this bug report?
https://github.com/IQSS/dataverse/issues/5808

Screenshots:
Searching for John O' (and searches that include all characters up to and including the single quote) returns accounts with the name John O'Henry plus accounts with names that include John, e.g. John Smith:

Searching for John O'Henry returns no results:

Start at the superuser dashboard's Users page and reproduce the searches for “John Paul Stevens” and “John O'Henry,” comparing them with shorter searches. Trace the user-search handling from that page and verify that searches containing more than three words or a single quote return the expected accounts.