declare @synonyms table 
(rowID int identity (1,1), searchword varchar(20), synonymWord varchar(20) 
 primary key (searchword,rowid)
)
insert into @synonyms
select 'check','try out' union all
select 'check','test' union all
select 'check','confirm' union all
select 'check','ensure' union all
select 'check','verify' union all
select 'check','try' union all
select 'check','prove' 

---------------------------------
select synonymWord 
from @synonyms 
where searchword = 'check'

declare @synonyms table (rowID int identity (1,1), searchword varchar(20), synonymWord varchar(20)
							primary key (searchword,rowid))

--------------------------------------------------------------
declare @synonym_list varchar(7900)
declare @sepChar varchar(50)
declare @element varchar(4)
declare @searchword varchar(20)
--------------------------------------------------------------
set @searchword = 'check'
set @synonym_list = 'try out, test, examine, confirm, verify'
set @sepchar = ','
set @synonym_list = @sepChar+@synonym_list+@sepChar		
--------------------------------------------------------------
;WITH
L0 AS (SELECT 1 AS C UNION ALL SELECT 1),	--2 rows
L1 AS (SELECT 1 AS C FROM L0 AS A, L0 AS B),--4 rows  "L0 as A, L0 as B" is just shorthand way to code a cross join	
L2 AS (SELECT 1 AS C FROM L1 AS A, L1 AS B),--16 rows
L3 AS (SELECT 1 AS C FROM L2 AS A, L2 AS B),--256 rows
L4 AS (SELECT 1 AS C FROM L3 AS A, L3 AS B),--65536 rows
Tally AS (SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY C) AS N FROM L4),
syns AS
(select Row_Number() over (order by N) as E,
		ltrim(rtrim(substring(@synonym_list,N+1,charindex(@sepChar,@synonym_list,N+1)-(N+1)))) as synWord
 from tally
 where substring(@synonym_list,N,1) = @sepChar
  and N < len(@synonym_list)
)
--
insert into @synonyms
select @searchword,synword from syns
----------------------------------------------
select *
from @synonyms 
where searchword = 'check'