Re^10: 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
[download]

Comment on Re^10: String Comparison & Equivalence Challenge Download Code

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~

[reply]


XP is just a number
	PerlMonks