### Re^10: String Comparison & Equivalence Challenge

by erix (Prior)
 on Mar 15, 2021 at 15:07 UTC Need Help??

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 (Friar) 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~

Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11129675]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2022-01-25 16:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
In 2022, my preferred method to securely store passwords is:

Results (67 votes). Check out past polls.

Notices?