Results 1 to 10 of 10

Thread: Misused words

  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Unanswered: Misused words

    Good morning.I am looking for design help with a database I want to put on a new and upcoming web site. Now, it has to be super easy to use.

    Here is the scenario. I sea so many people use words that sound alike in the wrong way. Such as the words, beet and beat or maul and mall or manor and manner (Or sea and see . Now, so far I have a list of almost 400 words that are often misused. How could I best set up a database (Access 2003) that will help people be able to look up words they are looking for and give the comparitive word. i.e. If they look up "to" they will also find "too" and "two" and the meaning for each word and how each word would be used in a sentence. In this way, they will know witch (which) word to use.
    Look, so many professional people have no (know) clue what they are writing and I want to help as many of them as I (eye) can. It has to be easy to search, add (ad) words to and fun to navigate. Thank you. drBob

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by drbob
    I am looking for design help with a database
    sure

    what part were you having trouble with?

    you seem to have the concept well under control
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2009
    Posts
    2
    Yes, i have been using Access for several years. I have the database made but am not able to set up the search button to search the 3 possible fields. It will only search one field that i am clicked in. i.e. if I want it to search for the three words "aisle", I'll or "Isle" I want the user to be able the desired word in the search box and come back with all three results. Now, all three of these words are a part of one record. So, if I am clicked in the Word1 field and type in "I'll" it will not find it because "I'll" is in the Word2 field. And "Isle" is in the Word3 field with a word3 definition field below it.

    Is there a way to put a pull down menu on the form so the user can choose the word they are looking for? i.e., if they chose "Aisle" they will get all 3 spellings and usage of the words mentioned above. Thanks for your time and quick response. remember, "Awl the people in the bored room wore a blew shirt as they weight for brake.? Bob

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by drbob
    Look, so many professional people have no (know) clue what they are writing and I want to help as many of them as I (eye) can.
    You mean kind of like
    Quote Originally Posted by drbob
    Here is the scenario. I sea so many people use words that sound alike in the wrong way.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by drbob
    I have the database made
    if you have fields called Word1, Word2, Word3, then might i suggest that you redesign it

    map each word to its homonym

    how you decide to record the homonym is another matter -- if i were doing it, i might decide to use english phonology but an equally effective strategy is simply to use one of the homonyms
    Code:
    word homonym
    isle   isle
    i'll   isle
    aisle  isle
    the main point is, each of the words that sounds alike is mapped to the same thing, and when you look up one of them, the query will return the others

    make sense?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If I were doing this in SQL Server or CLR I would use some sort of soundex function or metaphone. This is essentially (as I understand it) an application of rudy's phonology link. I haven't used these in Access, however if you google "VBA soundex" and "VBA metaphone" I'm sure there will be algorithms. You can then store the function output as an attribute of the word and join on this.
    I suggest this as an alternative - it is more code heavy and less intensive (as you are not manually adding mappings), however you will still need to enter words in the first place. I downloaded a list of about 300k english words recently for a project - I can dig up the link if useful.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Also, if one might be so bold - these aren't homonyms
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by pootle flump
    Also, if one might be so bold - these aren't homonyms
    you're right, girlfriend

    i had to look it up, not being an expert on homo words like you, and discovered that i should've said homophone

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    ooooh, snap
    Testimonial:
    pootle flump
    ur codings are working excelent.

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Look, so many professional people have no (know) clue what they are writing
    I would argue that such individuals are so very very far from "professional".
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •