Matching pattern in SQL

I have two tables and need to match all records by name. The problem is that in one table name format is "FirstName LastName", in another table - "LastName FirstName", and I cannot split into separate columns because some records might have few first names or last names, so I don't know where first or last name ends or starts. Eg. in first table I have "John Erick Smith" and need to join all records from another table where the name is "Smith John Erick". Any solution in SQL?