How to verify whether partial strings exist in cells across columns in an Excel worksheet?

How can I verify partial strings in cells across columns without having to look for an exact match?

I have a single spreadsheet with two columns that contain corresponding pairs of data in the form of text, or "strings". However, each corresponding pair almost matches except for a couple characters on the end. I need to make excel recognize the pairs despite the inexact string match, and return a "yes" or a "no" as to whether or not there a corresponding pair exists between the two columns. I want it to tell me "yes" or "no" in a single cell.

I do not want to delete characters from either column to make them match, they have to stay as they are.

My solution was that if I used an IF statement to determine whether A:A=B:B, all I would need to do is tell excel to also substitute the conflicting text characters with empty spaces, but that didn't work :( It returns #VALUE instead of a yes or no. I placed the function inside D1.

This is my formula:

=IF(SUBSTITUTE(A:A,"-Z","")*A:A=B:B,"Yes","No")

I think maybe I need a formula that will accomplish the following:

If a string with a length of up to 12 characters in a cell of column A matches another string in a cell of column B, return "true" in C2

I don't know what formula that would be. I would appreciate any help! Thanks in advance!