How to join two table with partial match

Hello, need your expect help to refine my View in order to join two tables with partial match of the whole word list. In the attached screenshot, ProductID 12 and 36 should not be listed because the whole word in ProductName is not = to "Mix" but SillMix and MixPastora.  

SELECT        dbo.Products.ProductID, dbo.Products.ProductName, dbo.NAMES.FullName
FROM            dbo.Products INNER JOIN
                         dbo.NAMES ON dbo.Products.ProductName LIKE '%' + dbo.NAMES.FullName + '%'

Select allOpen in new window

Output-Example.jpg