You can try something like this here:

USE [MyDatabase]
GO
declare test cursor for select PK from TableIWishToShread
open test
declare @PK int
declare @content varchar(max)
fetch next from test into @PK
while @@fetch_status=0
begin
select @content=TextData from TableIWishToShread where PK=@PK
insert into tblwords (word)
select *from dbo.ShredMe(@content)
where name not in (select word from tblwords)
fetch next from test into @PK
end
close test
deallocate test

the below script is used to build the inverted file index.

CREATE TABLE tblWordList(SubdocumentID int, WordID int, Position int)
Create table tblWords(WordID int not null identity primary key, Word
varchar(max),Little int)

Here is shredme:
USE [SonarProd]

GO

/****** Object: UserDefinedFunction [dbo].[ShredMe] Script Date: 09/05/2007
14:40:40 ******/

CREATE FUNCTION [dbo].[ShredMe](@postDescription [nvarchar](max))

RETURNS TABLE (

[Name] [nvarchar](200) NULL

) WITH EXECUTE AS CALLER

AS

EXTERNAL NAME [GoldShredder].[UserDefinedFunctions].[ShredMe]

GO

EXEC sys.sp_addextendedproperty @name=N'AutoDeployed', @value=N'yes' ,
@level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'FUNCTION',@level1name=N'ShredMe'

GO

EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile',
@value=N'ShredMe.cs' , @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'FUNCTION',@level1name=N'ShredMe'

GO

EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=22 ,
@level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'FUNCTION',@level1name=N'ShredMe'

Here is the assembly. http://www.indexserverfaq.com/goldshredder.dll