I have a list of product codes and the number of characters vary. I'm trying to lookup a product from my product list to a partial part number, returning the partial part number. The first list is my product list and the second list is the partial part list. The difficulty in this is that the partial part list isn't nessarily the first few characters of the product, some are the first few characters and some are characters in the middle of the list. Does anyone know if there's away to look these up?

Product Codes
USX2065-JZX-TR
LAN8710A-EZC-TR
SEC1300-JZX-01G1
USX2064-AEZG-TR
USB5434-3086JZX-TR


Partial Part #
X2065
LAN8710
SEC1300
2064
3086JZ