http://qs321.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

Replies are listed 'Best First'.
Re^11: String Comparison & Equivalence Challenge
by Polyglot (Chaplain) on Mar 15, 2021 at 15:19 UTC

    It would appear that the spelling difference is related to the time of writing. There is an earlier spelling, and a later spelling. The earlier spelling was applied to a person who was also mentioned at a later date with the alternate spelling, and that second spelling was used for a separate individual as well.

    In Hebrew, the two words are almost identical. If you don't put your glasses on, they might appear so. Here they are:

    אַשְׁכֲּנַ֥ז

    אַשְׁכְּנָ֑ז

    Blessings,

    ~Polyglot~