1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Can Anyone Find or Make this Word from Value Calculator?

Discussion in 'Programming' started by MindReality, Nov 15, 2019.

  1. #1
    Hi,

    I am currently using this "Word Value" and "Word from Value" Calculator at this page:
    https://www.dcode.fr/word-value
    SEMrush
    What it does is:
    1. Converts words to numbers based on "A=1, B=2, C=3, etc..." and then adds up the sum of it.
    Hence the word "CAT" = 3+1+20 = 24
    3. Converts numbers to words by doing the reverse.
    Hence the numbers 24 = CAT

    Can anyone find out where else is offering such a tool?

    Or else is there someone able to duplicate such a web tool?
     
    Solved! View solution.
    MindReality, Nov 15, 2019 IP
    JEET likes this.
    SEMrush
  2. #2
    This can be duplicated if you can provide a database of all valid english words.

    Then a database will need to be made which stores actual word plus its numerical value.

    When someone searches "24", it will list all words which have a numerical value of 24 in the database.

    What is the use of this anyways?
     
    JEET, Nov 15, 2019 IP
  3. MindReality

    MindReality Well-Known Member

    Messages:
    200
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #3
    Can the word sources be obtained from public sources such as https://wordnet.princeton.edu/ and https://www.wiktionary.org/ ? This is what I found out the word from value calculator is doing.

    A program can be created to scan every word and store its numerical value into a database to be pulled back when required.

    This is for numerology usage.

    I'm looking for either another tool like the one I mentioned (unfortunately they started limiting the results to 250 words), or I hope to find a programmer who can duplicate it for me.
     
    MindReality, Nov 15, 2019 IP
    JEET likes this.
  4. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #4
    I understood the calculation for first 2 methods, addition and reduction, but was not able to find the calculation for the third "multiply" method.
    How is that one done?
     
    JEET, Nov 15, 2019 IP
  5. MindReality

    MindReality Well-Known Member

    Messages:
    200
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #5
    I only need the addition/sum method. That is the only one I use on that page.
     
    MindReality, Nov 15, 2019 IP
    JEET likes this.
  6. MindReality

    MindReality Well-Known Member

    Messages:
    200
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #6
    How would you go about creating such a database btw?

    And what database would you use? SQL?
     
    MindReality, Nov 15, 2019 IP
    JEET likes this.
  7. MindReality

    MindReality Well-Known Member

    Messages:
    200
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #7
    I have create a new thread with a more specific subject and a better project description. We can continue the discussion here:
    https://forums.digitalpoint.com/threads/programmer-needed-for-numerology-name-generator.2860631/
     
    MindReality, Nov 16, 2019 IP
    JEET likes this.
  8. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #8
    Give me some time, trying to download dictionary files. Really big files. Do you have MYSQL and PHP hosting?
     
    JEET, Nov 16, 2019 IP
  9. MindReality

    MindReality Well-Known Member

    Messages:
    200
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #9
    Could you let me know which links you are downloading from? I would like to download too so I can get a feel of how long it might take to download the files and how big they are.
    Do you know which links are the correct ones that contain the word files? Or do you just download every link and then check the files to find out after that?

    I have a dedicated server on Liquid Web. It is a linux server with PHP and MYSQL.
     
    MindReality, Nov 16, 2019 IP
  10. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #10
    I downloaded a couple of files from there, but most are corrupt, won't unzip. Not even with 7zip.
    They are basically html webpages of their website, zipped and made available for download.
    One I downloaded was named html.lst, which did not worked.
    Then I downloaded another tar.7z file from articles folder, which even on 100MBPS connection did not got downloaded completely. So cannot unzip it.

    But I think I have found another place from where I can get words and make a database for you. About 200,000 words are enough?
     
    JEET, Nov 16, 2019 IP
  11. MindReality

    MindReality Well-Known Member

    Messages:
    200
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #11
    Which pages and links did you download from? I want to see the problem myself because so far some of the links I downloaded from seems find.
     
    MindReality, Nov 17, 2019 IP
  12. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #12
    Did you get a SQL database file in any of those zips? If so, please upload somewhere so I can download here and use it in the script.

    Let me try if I can find again the links I downloaded. Will post here if I do find.
     
    JEET, Nov 17, 2019 IP
  13. malky66

    malky66 Acclaimed Member

    Messages:
    3,661
    Likes Received:
    2,070
    Best Answers:
    84
    Trophy Points:
    515
    #13
    I don't know why you need a massive database of words for this seems like overkill, found this on the web, copy and paste it into a html file, it does the letters to numbers calculation but not the numbers to words, I imagine a competent programmer could sort that quite easily.
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    
    <html xmlns="http://www.w3.org/1999/xhtml">
    
    <head>
      <title>Hello!</title>
    </head>
    
    <body>
    <div id='container' ng-cloak ng-app='WordValue' ng-controller='WordController'>
    
        <label for="word">Word:</label>
        <input id='word' type='text' size='50' ng-model='word' placeholder='Enter a word' autofocus>
    
        <div id='results' ng-show='word'>{{ word }} = {{ word_value(sum) }}</div>
    </div>
    
    <noscript>
    Javascript must be enabled to use this page.
    </noscript>
    
    <script src="https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.3.8/angular.min.js"></script>
    
    <script type='text/javascript' language='Javascript'>
    
    var app = angular.module("WordValue", []);
    
    app.controller('WordController', function WordController($scope) {
        $scope.word_value = function() {
            if (! $scope.word) {
                return;
            }
    
            var word = $scope.word.toLowerCase();
    
            var sum = 0;
    
            // Only count letters.
            for (var i = 0; i < word.length; i++) {
                var charCode = word.charCodeAt(i);
                // a = 97, z = 122
                if (charCode >= 97 && charCode <= 122) {
                    sum += charCode - 96;
                }
            }
    
            return sum;
        }
    });
    
    </script>
    
    
    </body>
    
    </html>
    
    Code (markup):
     
    malky66, Nov 17, 2019 IP
    sarahk and JEET like this.
  14. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #14
    @malky66
    Word to number is simple, no problem there.
    The massive database is for the reverse itself, numbers to word.
    Store the word and its pre-calculated number in the database.
    When someone enters a number in the search, simply pull out the words which have that same number.
    With an index on the number column, this will be fairly quick.

    Any other way you can think off please let us know.
    Thanks
     
    JEET, Nov 17, 2019 IP
  15. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #15
    @MindReality
    I have made a database, I was able to get roughly 90k words total.
    I have not made any user interface yet. sending query directly to get results.
    If you want me to complete the project, let me know and we can decide on a small fee...
    If there are any more requirements, please let me know now so that I can adjust the database accordingly.
    I hope this is what you wanted...

    This is the result I am getting when I search for "numbers"

    These are all with value "100"
    (top 40 displayed)

    regimented
    receptor
    eulogize
    temazepam
    radiocarbon
    polyamide
    thickening
    roommate
    outlier
    pixilated
    maxillaria
    pictural
    socrates
    clockwise
    excellent
    fountain
    nihilist
    fenestral
    awfully
    whooper
    appertain
    shakeout
    operetta
    pandurate
    utensil
    ventose
    morphemic
    breviary
    forewarn
    rufous
    nestling
    scrummage
    dortmanna
    sculpted
    honduras
    conjunct
    placeseeker
    broomweed
    trademarked
    posting


    These with value "75"
    (top 20 displayed)

    calliandra
    copepoda
    carrot
    tying
    knowl
    bracteate
    cooley
    shelfy
    booming
    murre
    cinguli
    buxom
    bethune
    overfed
    monro
    across
    brunt
    simone
    equals
    cheshire


    These with value "24"
    (all displayed, 98 total found in my database)

    abdel
    abu
    act
    adar
    aden
    ain
    akka
    amia
    ani
    arda
    are
    babar
    babble
    bail
    bali
    bang
    barba
    bata
    bedded
    bibbed
    blade
    bog
    brac
    cachi
    canada
    capac
    casa
    cat
    cecal
    cfo
    chaff
    cli
    crab
    cu
    dado
    dafla
    dane
    das
    dean
    deface
    dhabi
    dhak
    dik
    doe
    ear
    eccm
    edna
    edo
    een
    elbe
    emf
    ene
    era
    es
    fabaceae
    facie
    faq
    fide
    flea
    fr
    gamba
    gap
    gel
    glad
    gob
    gpa
    haje
    hao
    hdl
    hp
    ian
    ibid
    io
    jaded
    jaffa
    jam
    kal
    kid
    km
    lbj
    leaf
    leg
    maia
    naha
    ncdc
    nee
    nj
    ode
    oed
    peba
    ph
    qcd
    rea
    rf
    sad
    se
    tac
    wa
     
    JEET, Nov 17, 2019 IP
  16. MindReality

    MindReality Well-Known Member

    Messages:
    200
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    105
    #16
    One of the list of words was taken from this hierarchy of links:
    https://wordnet.princeton.edu/
    https://wordnet.princeton.edu/download
    https://wordnet.princeton.edu/download/current-version
    https://wordnetcode.princeton.edu/wn3.1.dict.tar.gz
    wn3.1.dict\dict\adj.txt (The folder and file in the zip file)

    I'm looking forward to the links you tried downloading from which gave trouble so I can check it myself.

    Btw, I would also like to know which word source you got your words from. I have been finding other word sources as well and would like to compare and decide which ones to use.

    Your query results is an example of what I am looking for. Do you have a personal website or Facebook that we could connect with? You can PM me about it if you like.
     
    MindReality, Nov 17, 2019 IP
  17. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #17
    JEET, Nov 17, 2019 IP
  18. JEET

    JEET Notable Member

    Messages:
    2,610
    Likes Received:
    188
    Best Answers:
    4
    Trophy Points:
    215
    #18
    JEET, Nov 17, 2019 IP
  19. sarahk

    sarahk iTamer Staff

    Messages:
    25,465
    Likes Received:
    3,529
    Best Answers:
    102
    Trophy Points:
    665
    #19
    I'm curious - why would you ever want a list of words with a specific value?
     
    sarahk, Nov 17, 2019 IP
    JEET likes this.
  20. mmerlinn

    mmerlinn Notable Member

    Messages:
    2,420
    Likes Received:
    355
    Best Answers:
    6
    Trophy Points:
    290
    #20
    The only reason I can see for him assigning values to words is when he is dealing with words in languages that assign values to individual letters, like Hebrew, Arabic, Greek, and so on. However, he is not doing that at all.
     
    mmerlinn, Nov 17, 2019 IP
    JEET likes this.