请问如何比较中文字符相似

[ykb]

比如：
电子工业出版社与北京电子工业出版社 是相似 与清华出版社是不相似的

两个字符串中有4个以上相同的字 是相似的

这个该如何实现？

[Chiff]

select 1 as id,'电子工业出版社' as name into #t
union all
select 2,'北京电子工业出版社'
union all
select 3,'清华出版社'
union all
select 4,'清华出版社分社'


select id,name into #t1 from #t where 1=2

declare @n int
set @n = 1

while @n < (select max(len(name)) from #t) - 3
begin
insert into #t1 select id,substring(name,@n,4) from #t where len(name) > @n + 2
set @n = @n + 1
end


select a.name,b.name as '与之近似' from #t a,#t b,
(select distinct a.id as aid,b.id as bid
from #t1 a,#t1 b where a.id < b.id and a.name = b.name) as c
where a.id = c.aid and b.id = c.bid

[yoki]

个字符串中有4个以上相同的字 是相似的 ??
应该是连续4个字符相同吧？

[shanxing]

俺是来学习的`~~

[ekun008]

www.solarstones.com/wzq