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
In reply to Re^10: String Comparison & Equivalence Challenge
by erix
in thread String Comparison & Equivalence Challenge
by Polyglot
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |