The need for more info notwithstanding, there is only one set of data/attachments not two. The data posted doesn't shed any light on the problem - there are just highlighted rows with no explanation. Even so, it would seem that by using wild card searches you are slowing things down tremendously, as well as returning every combination of the same records that satisfies the broad criteria.
I suspect you'd be a lot happier if you had a table for modified data. You might have to put this into a separate db due to file size just for this purpose but can't say because I have no idea where you're at size-wise on your current file. In the modified data would be extra fields to split the first and last names into last, first and co-owner name (spouse/partner/whatever). The idea would be to use this modified table joined to your other table and eliminate the LIKE situation. Obviously this would depend on the primary data being divided according to some reliable pattern.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.