Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^7: String Comparison & Equivalence Challenge

by LanX (Sage)
on Mar 15, 2021 at 13:58 UTC ( #11129666=note: print w/replies, xml ) Need Help??


in reply to Re^6: String Comparison & Equivalence Challenge
in thread String Comparison & Equivalence Challenge

> A list of all the words in the KJV Bible, showing the number of occurrences for each, can be found HERE.

So what's the difference between Ashchenaz and Ashkenaz ?

Cheers Rolf
(addicted to the Perl Programming Language :)
Wikisyntax for the Monastery

Replies are listed 'Best First'.
Re^8: String Comparison & Equivalence Challenge
by erix (Prior) on Mar 15, 2021 at 14:15 UTC
    $ psql psql (14devel) testdb=# select strict_word_similarity('Ashchenaz', 'Ashkenaz'); strict_word_similarity ------------------------ 0.46153846 (1 row) Time: 1.381 ms
      strict_word_similarity             0.46153846

      that's pretty low.

      Time: 1.381 ms

      that's pretty rich

      Cheers Rolf
      (addicted to the Perl Programming Language :)
      Wikisyntax for the Monastery

Re^8: String Comparison & Equivalence Challenge
by Polyglot (Friar) on Mar 15, 2021 at 14:38 UTC

    Good question. They were two different people, and, perhaps because of this, the Masoretes added a different set of vowels/pronunciation marks to each of the two in the original Hebrew. The actual Hebrew consonants between the two words are the same. I suppose it would be a little like Freddie vs. Freddy -- they're basically the same name, but represent two different people; or maybe Rebekah vs. Rebecca, etc.

    Blessings,

    ~Polyglot~

      Which two people please?

      This looks rather like a transcription problem, probably caused by using Greek in between Hebrew and English.

      Cheers Rolf
      (addicted to the Perl Programming Language :)
      Wikisyntax for the Monastery

        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

        The first mention is of a son of Gomer:

        "And the sons of Gomer; Ashkenaz, and Riphath, and Togarmah." (Genesis 10:3)

        The later individualkingdom (I see now that I have earlier misspoken) referenced by this name is evident here:

        "Set ye up a standard in the land, blow the trumpet among the nations, prepare the nations against her, call together against her the kingdoms of Ararat, Minni, and Ashchenaz; appoint a captain against her; cause the horses to come up as the rough caterpillers." (Jeremiah 51:27)

        Blessings,

        ~Polyglot~

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11129666]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (4)
As of 2021-10-28 13:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (96 votes). Check out past polls.

    Notices?