http://qs1969.pair.com?node_id=11129675


in reply to Re^9: String Comparison & Equivalence Challenge
in thread String Comparison & Equivalence Challenge

I think you must be right, or the two spellings would not occur in such similar contexts.

select substring(cmp.sim::text,1,5) sim , k1.text || chr(10) || k2.text || chr(10) as "txt1 vs txt2" , k1.book || ':' || k1.chapter || ':' || k1.verse || chr(10) || k2.book || ':' || k2.chapter || ':' || k2.verse "location" from kjv_simil_0_25 cmp join kjv k1 on id1=k1.id join kjv k2 on id2=k2.id where sim >= 0.5 and k1.text ~ 'Ashchenaz|Ashkenaz' and k2.text ~ 'Ashchenaz|Ashkenaz' order by 1 desc ; sim | txt1 vs txt2 | +location ------+------------------------------------------------------------+-- +------ 0.86 | And the sons of Gomer; Ashkenaz and Riphath and Togarmah. +| 1 +:10:3+ | And the sons of Gomer; Ashchenaz and Riphath and Togarmah.+| 1 +3:1:6 | | 0.86 | And the sons of Gomer; Ashchenaz and Riphath and Togarmah.+| 1 +3:1:6+ | And the sons of Gomer; Ashkenaz and Riphath and Togarmah. +| 1 +:10:3 | | (2 rows) Time: 6.959 ms