Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: generate codes excluding profane words (was "Odd way to spend my lunch hour...")

    I've been asked to develop on algorithm for generating easily remembered six character codes from peoples names. The codes will be published by a State Government agency for the general population to use them to look up records on a website.

    The algorithm was easy, but then it occured to me that this government agency would not want to be pulishing any codes that inadvertently formed or contained profane words. Any such codes would have to be excluded.

    So now I am spending my lunch typeing obscene words into Google.

    And getting paid for it.

    Does anybody know where I can get a list of profane, obscene, or racist terms?

    Seriously. I'm not just $hitting you.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    So you're looking to come up with an Obscene table?

    And you can't make one yourself?

    And you're getting paid to do this?

    That's too funny.

    You going for case sensitivity as well?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105
    they must have a list like that for car license plates....i would aim your search in that direction....
    You're obsessed and distressed 'cuz you can't make any sense
    Of the ludicrous nonsense and incipient senescence
    That will deem your common sense useless

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No case sensitivity. All the codes will be upper case. And I'm not trying to circumvent people entering profanity, so I don't have to check for F_CK, or F^CK, or other substitutions.

    Since I'm searching for embedded strings, I can omit all profane words that have smaller obscenities embedded in them, like, well, you don't really need an example, do you?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    You can have a few beers with my dad after the Redskins lose.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Interesting discussion (and one useful link) at vbulletin itself.

    -PatP

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I'm not trying to prevent cursing. These codes are auto-generated, so I just don't want our Attorney General's office sending out a bulletin asking people to type profanity into their search page!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Exactly, that's why the link to the list in the thread that I referenced might be useful.

    -PatP

  9. #9
    Join Date
    May 2004
    Posts
    9

    Cool English Dictionary

    You better look in an Book (English Dictionary) or an online dictionary might have grouped these words, I don't know.

  10. #10
    Join Date
    Aug 2004
    Posts
    17
    Quote Originally Posted by Thrasymachus
    You can have a few beers with my dad after the Redskins lose.
    Or sit in the same room with me after meeting with boss! ; )

    I have seen lists like this before under the topic of license plates. The story was about NY's DMV and the list of things they have banned (some were pretty funny...). I think I saw the list on smokinggun.com....

Posting Permissions

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