if exists (select 1 from sysobjects where name='_list1')
begin drop table _list1 print '_list1 deleted' end

print'Create table where to copy the words'
CREATE TABLE [_list1] (
	[words] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
)

declare @sent varchar(50), @word varchar(50), @wl int, @i int, @j int, @r int

set     @j = 1                     -- outer loop counter: row count
set     @word = ''                 -- a single word, between two spaces
set @r = 10
--select  @r =  COUNT(F1) FROM ESwik -- total # of rows in the input table
SET NOCOUNT ON

print'copy words'
while @j < @r +1
BEGIN
   select @sent = F1 from ESwik where id = @j
   set    @wl   = len(@sent)       -- length of the current row
   set    @i = 1                   -- inner loop counter: char count
   while  @i < 2 + @wl
   BEGIN
      if substring(@sent, @i,1) <> ' ' set @word = @word + substring(@sent, @i,1)
      else begin insert into _list1 select @word set @word ='' end
      set @i = @i + 1
   END
   set @j = @j + 1
END

if exists (select 1 from sysobjects where name='_list2')
begin drop table _list2 print '_list2 deleted' end

CREATE TABLE [_list2] (
	[wcnt] [int] NULL ,
	[words] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL 
)

INSERT INTO   _list2 (wcnt, words)
SELECT  COUNT (words) AS wcnt, words
FROM          _list1
GROUP BY       words
ORDER BY COUNT(words) DESC