Something like this:

CREATE TABLE [dbo].[Products](

[ProductDesc] [varchar](200) NULL

)

INSERT INTO Products(ProductDesc) SELECT 'WidgetA'

INSERT INTO Products(ProductDesc) SELECT 'WidgetB'

INSERT INTO Products(ProductDesc) SELECT 'WidgetC'

INSERT INTO Products(ProductDesc) SELECT 'WidgetD'

INSERT INTO Products(ProductDesc) SELECT 'WidgetE'

CREATE TABLE [dbo].[Exceptions](

[ProductDesc] [varchar](200) NULL

)

INSERT INTO Exceptions(ProductDesc) SELECT 'Big WidgetD'

INSERT INTO Exceptions(ProductDesc) SELECT 'Small WidgetE'

GO

select

*

from

[dbo].[Products] p

where

not exists(select 1 from [dbo].[Exceptions] e where e.ProductDesc like '%' + p.ProductDesc + '%');

GO

drop table [dbo].[Products];

drop table [dbo].[Exceptions];

GO