Word Trivia II: Name a 5-letter word containing 4 pronouns 4

[SantaMufasa]

This should be a quick and easy one for you WordSmiths. No mixing the 5 letters to derive the 4 pronouns.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 19:38 (16Dec04) UTC (aka "GMT" and "Zulu"),
@ 12:38 (16Dec04) Mountain Time

 

[strongm]

[white]usher
giving: us, she, he, her[/white]

 

[AnotherHiggins]

[COLOR=white]Usher - He She Us Her[/color]

[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886

 

[SantaMufasa]

Starbursts to both "Strongm" and John for simultaneous posts of an excellent answer.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 20:38 (16Dec04) UTC (aka "GMT" and "Zulu"),
@ 13:38 (16Dec04) Mountain Time

 

[AnotherHiggins]

DANG! Ya' beat me, strongm.

Thanks, SantaMufasa, for your generosity with the pointy thing.

[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886

 

[ESquared]

A five letter word with five pronouns:

[white]yours - you, your, yours, our, ours (5)

Allowing longer words, there are

nourishers - our, I, she, he, her, hers (6)
fourflushers - our, us, she, he, her, hers (6)
britishers - I, it, she, he, her, hers (6)

In total, I found:

3 6-pronoun words
96 5-pronoun words
490 4-pronoun words[/white]

And building on strongm's answer:

[white]ushers - us, she, he, her, hers (5)[/white]

-------------------------------------
• Every joy is beyond all others. The fruit we are eating is always the best fruit of all.
• It is waking that understands sleep and not sleep that understands waking. There is an ignorance of evil that comes from being young: there is a darker ignorance that comes from doing it, as men by sleeping lose the k

 

[AnotherHiggins]

I considered [COLOR=white white]hers using Ushers[/color], but that wasn't the puzzle!

But nice work, EE. I have to really jump to compete against you and your SQL dictionary.

[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886

 

[ESquared]

SELECT 
   Word,
   Value,
   Position,
   Cnt   
FROM (
   SELECT
      WordID,
      Cnt = Count(*)
   FROM Dictionary D1
      INNER JOIN dbo.Split('he,him,she,her,it,we,us,they,them,I,me,you,thee,thou,his,
hers,its,our,ours,their,theirs,my,mine,your,yours,thy,thine',',')
      P ON D1.Word LIKE '%' + P.Value + '%'
   GROUP BY
      WordID
   HAVING
      Count(*) >= 4
) A INNER JOIN (
   SELECT WordID, Word, Value, Position = charindex(Value, Word)
   FROM Dictionary D1
      INNER JOIN dbo.Split('he,him,she,her,it,we,us,they,them,I,me,you,thee,thou,his,
hers,its,our,ours,their,theirs,my,mine,your,yours,thy,thine',',')
      P ON D1.Word LIKE '%' + P.Value + '%'
) B ON A.WordID = B.WordID
WHERE
   Len(Word) <=5
ORDER BY
   Cnt DESC,
   Len(Word),
   Word,
   Position,
   Len(Value)

There has to be a better way to restrict an aggregate to a certain number, but NOT collapse the aggregate, all in one query. I could have made a temp table (probably better form). Doing the join to the pronoun list twice sucks, but the query ran quickly so it was easier just to do it this way.

 

[SantaMufasa]

Esquared,

All I can say is "You Da' (SQL*Dictionary) Man" !!! If I could award more than one star, I would.

Cheers,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 21:33 (16Dec04) UTC (aka "GMT" and "Zulu"),
@ 14:33 (16Dec04) Mountain Time