$ psql
psql (14devel)

testdb=# select strict_word_similarity('Ashchenaz', 'Ashkenaz');
 strict_word_similarity 
------------------------
             0.46153846
(1 row)

Time: 1.381 ms
[download]

strict_word_similarity             0.46153846

that's pretty low.

Time: 1.381 ms
[download]

that's pretty rich

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

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.

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
[download]

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~