How to filter large amount of data and extract their similarities then create a record with them in a database

I have two tables in my database and im pulling record from both, in both records, there are titles from both that has similar names and i want to tract them and add them to a new table. This is a loom video about the issue https://www.loom.com/share/ae410a112ef045fe821c78e343469782