CREATE PROCEDURE REALSLOW_Int_JOIN_test
                 @str    nvarchar(MAX),
                 @tookms int OUTPUT AS

DECLARE @start datetime
SELECT @start = getdate()

INSERT Int_JOIN(word)
SELECT u.word
FROM   usrdictwords u
WHERE  charindex(',' + ltrim(str(wordno)) + ',' COLLATE Slovenian_BIN2,
                 ',' + @str + ',' COLLATE Slovenian_BIN2) > 0

SELECT @tookms = datediff(ms, @start, getdate());

SELECT word FROM Int_JOIN
TRUNCATE TABLE Int_JOIN
go


CREATE PROCEDURE REALSLOW_Str_JOIN_test
                 @str    nvarchar(MAX),
                 @tookms int OUTPUT AS

DECLARE @start datetime
SELECT @start = getdate()

INSERT Str_JOIN(wordno, guid)
SELECT u.wordno, u.guid
FROM   usrdictwords u
WHERE  charindex(',' + u.word + ',', ',' + @str + ',') > 0

SELECT @tookms = datediff(ms, @start, getdate());

SELECT wordno FROM Str_JOIN

TRUNCATE TABLE Str_JOIN
go