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.+| 13:1:6 | | 0.86 | And the sons of Gomer; Ashchenaz and Riphath and Togarmah.+| 13:1:6+ | And the sons of Gomer; Ashkenaz and Riphath and Togarmah. +| 1:10:3 | | (2 rows) Time: 6.959 ms