Regex for all possible name writings for finding people with same name written differently

I have full name field. I need to be able to find all users with similar names when new user is registering.

Is it possible to create regular expression from newly added full name that would match similar names with at least 2 parts present? For example for 'Harry James Potter' this regex needs to match 'Harry Potter', 'James Potter', 'Potter Harry' etc, and vice versa (for 'Harry Potter' it needs to match 'Harry James Potter').

I'am using PHP. Names are in the mySQL table.

EDIT: this question has absolutely nothing in common (beside word "name" in the title) with Regular expression for first and last name . So please don't mark it as a duplicate.

https://stackoverflow.com/questions/66739644/regex-for-all-possible-name-writings-for-finding-people-with-same-name-written-d March 22, 2021 at 10:37AM