Can you rename files based on partial file name match?

I have been struggling with this for a while now.

Let's say I have a list of 200 files names that are correct. I also have a list of 700 files names that are incorrect.

I want to rename 200 of the 700 incorrect file names based on my correct list of 200 files.

These names are very similar but not identical.

From the good list here are four sample file names:
redwoods CA magenta (Calif) (USA)!.png
Canyons cali evening !border USA.png
marshes california morning USA (1 of 2).png
marshes california morning USA (2 of 2).png

In the list of 700 files there are partial matches that need to be renamed from the list above the files would be:
redwoods california magenta USA.png
Canyons california sunset USA.png
marshes california morning USA (image 1).png
marshes california morning USA (image 2).png

and need to be changed to:
redwoods CA magenta (Calif) (USA)!.png
Canyons cali evening !border USA.png
marshes california morning USA (1 of 2).png
marshes california morning USA (2 of 2).png

I tried doing some sort of Vlookup in google sheets to find partial matches so I could create a CSV to import in to AR. but couldn't get it to work, or get it to mark which ones matched.

It seems like this is something AR was designed to do...but for the life of me I cannot figure it out.