Freetext does much of what you are looking for. Other than that here is
something. I have marked positions to insert your search query

set nocount on
declare @table table (word varchar(50))
declare @searchphrase varchar(1000)
declare @word varchar(50)
declare @count int
set @searchphrase =' the rain in spain stays mainly in the plain '
select @searchphrase =ltrim(rtrim(@searchphrase ))
select @count=len(@searchphrase)-len(replace(@searchphrase,' ',''))
while @count>=0
begin
if @count>0
begin
--insert search query here
insert into @table
select left(@searchphrase, charindex(' ',@searchphrase))
end
else
begin
--insert search query here
insert into @table
select @searchphrase
end
select @searchphrase=substring(@searchphrase, charindex('
',@searchphrase)+1,1000)
select @count=@count-1
end

select * from @table