Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^10: String Comparison & Equivalence Challenge

by erix (Prior)
on Mar 15, 2021 at 15:07 UTC ( #11129675=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
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 examining the Monastery: (2)
As of 2021-10-18 22:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (76 votes). Check out past polls.

    Notices?