SQL запрос. Из названия нужно убрать лишнее слова по списку из другой таблицы

create function dbo.fnEliminateWords
(
 @Value varchar(max),
 @WordsList varchar(max)
)
returns varchar(max)
as
begin
 declare @result varchar(max) = @Value;
 
 select
  @result = replace(@result, ltrim(rtrim(value)), '')
 from
  string_split(@WordsList, ',');
 
 return @result;
end;
go
 
declare @t table (s varchar(max));
declare @w table (w varchar(100));
 
insert into @t
values
 ('Unisex Tunic 491 Purple Care UK Tax Tab'),
 ('BC Dress RC 5716 Lavender BR01 White');
 
insert into @w
values
 ('Unisex'), ('Tunic'), ('Care'), ('UK'), ('Tax'), ('TAB'), ('BC'), ('Dress'), ('RC'), ('Lavender');
 
declare @WordsList varchar(max);
 
select
 @WordsList = string_agg(w, ',')
from
 @w;
 
select
 dbo.fnEliminateWords(s, @WordsList)
from
 @t;
go
 
drop function dbo.fnEliminateWords;
go

declare @t table (s varchar(max));
declare @w table (w varchar(100));
 
insert into @t
values
 ('Unisex Tunic 491 Purple Care UK Tax Tab'),
 ('BC Dress RC 5716 Lavender BR01 White');
 
insert into @w
values
 ('Unisex'), ('Tunic'), ('Care'), ('UK'), ('Tax'), ('TAB'), ('BC'), ('Dress'), ('RC'), ('Lavender');
 
select
 rtrim(c.x.value('./text()[1]', 'varchar(max)'))
from
 @t t cross apply
 (select cast(cast('' as xml).query('sql:column("t.s")') as varchar(max))) a(s) cross apply
 (select cast('<w>' + replace(a.s, ' ', '</w><w>') + '</w>' as xml)) b(x) cross apply
 (
  select
   wl.w + ' '
  from
   (select row_number() over (order by (select 1)), w.n.value('./text()[1]', 'varchar(100)') from b.x.nodes('w') w(n)) wl(rn, w)
  where
   not exists(select 1 from @w where w = wl.w)
  order by
   wl.rn
  for xml path(''), type
 ) c(x);

...
select
 t.*, rtrim(c.x.value('./text()[1]', 'varchar(max)'))
...