SQL_函数比较两个字符串的相似度

USE [SooilSemanticsDB_ImportData]
GO
/****** Object:  UserDefinedFunction [dbo].[get_semblance_By_2words]    Script Date: 2015/6/18 15:44:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create   function [dbo].[get_semblance_By_2words] 
( 
@word1 varchar(500), 
@word2 varchar(500)   
) 
returns nvarchar(4000) 
as 
begin 
declare @re int 
declare @maxLenth int 
declare @i int,@l int 
declare @tb1 table(child varchar(500)) 
declare @tb2 table(child varchar(500)) 
set @i=1 
set @l=1
set @maxLenth=len(@word1) 
if len(@word1)<len(@word2)  
begin 
set @maxLenth=len(@word2) 
end 
while @l<=len(@word1)  
begin 
while @i<=len(@word1) and @i<=len(@word1)-@l+1
begin 
insert @tb1 (child) values( SUBSTRING(@word1,@l,@i) ) 
set @i=@i+1  
end
set @i=1 
set @l=@l+1 
end 
set @i=1 
set @l=1 
while @l<=len(@word2)  
begin 
while @i<=len(@word2) and @i<=len(@word2)-@l+1
begin 
insert @tb2 (child) values( SUBSTRING(@word2,@l,@i) )  
set @i=@i+1 
end 
set @i=1 
set @l=@l+1 
end   
select @re=isnull(max( len(a.child)*100/  @maxLenth ) ,0) from @tb1 a, @tb2 b where a.child=b.child 
return @re 
end