Spelling Bee

0

Please login or register to vote for this query.

(click on this box to dismiss)

Block needs to be 1-500 only.

Ask Ubuntu

Q&A for Ubuntu users and developers

DECLARE @Question tinyint = 1;
DECLARE @Answer tinyint = 2;
-- DECLARE @PostLocked tinyint = 14;
-- DECLARE @PostUnlocked tinyint = 15;
WITH Words AS (
  SELECT '% [Aa]bsense %' AS Value
  UNION
  SELECT '% [Aa]bsentse %'
  UNION
  SELECT '% [Aa]bcense %'
  UNION
  SELECT '% [Aa]bsance %'
  UNION
  SELECT '% [Aa]cceptible %'
  UNION
  SELECT '% [Aa]ccidentaly %'
  UNION
  SELECT '% [Aa]ccomodate %'
  UNION
  SELECT '% [Aa]commodate %'
  UNION
  SELECT '% [Aa]cheive %'
  UNION
  SELECT '% [Aa]cknowlege %'
  UNION
  SELECT '% [Aa]knowledge %'
  UNION
  SELECT '% [Aa]cquaintence %'
  UNION
  SELECT '% [Aa]quaintance %'
  UNION
  SELECT '% [Aa]quire %'
  UNION
  SELECT '% [Aa]dquire %'
  UNION
  SELECT '% [Aa]quit %'
  UNION
  SELECT '% [Aa]crage %'
  UNION
  SELECT '% [Aa]cerage %'
  UNION
  SELECT '% [Aa]dress %'
  UNION
  SELECT '% [Aa]dultary %'
  UNION
  SELECT '% [Aa]dviseable %'
  UNION
  SELECT '% [Aa]dvizable %'
  UNION
  SELECT '% effect %'
  UNION
  SELECT '% [Aa]ffect %'
  UNION
  SELECT '% [Aa]gression %'
  UNION
  SELECT '% [Aa]gressive %'
  UNION
  SELECT '% [Aa]llegaince %'
  UNION
  SELECT '% [Aa]llegience %'
  UNION
  SELECT '% [Aa]legiance %'
  UNION
  SELECT '% [Aa]llmost %'
  UNION
  SELECT '% [Aa]lot %'
  UNION
  SELECT '% [Aa]llot %'
  UNION
  SELECT '% [Aa]matuer %'
  UNION
  SELECT '% [Aa]mature %'
  UNION
  SELECT '% [Aa]nually %'
  UNION
  SELECT '% [Aa]nnualy %'
  UNION
  SELECT '% [Aa]pparant %'
  UNION
  SELECT '% [Aa]parent %'
  UNION
  SELECT '% [Aa]pparrent %'
  UNION
  SELECT '% [Aa]parrent %'
  UNION
  SELECT '% [Aa]rtic %'
  UNION
  SELECT '% [Aa]rguement %'
  UNION
  SELECT '% [Aa]thiest %'
  UNION
  SELECT '% [Aa]thist %'
  UNION
  SELECT '% [Aa]wfull %'
  UNION
  SELECT '% [Aa]weful %'
  UNION
  SELECT '% [Bb]ecuase %'
  UNION
  SELECT '% [Bb]eatiful %'
  UNION
  SELECT '% [Bb]ecomeing %'
  UNION
  SELECT '% [Bb]egining %'
  UNION
  SELECT '% [Bb]eleive %'
  UNION
  SELECT '% [Bb]ellweather %'
  UNION
  SELECT '% [Bb]enifit %'
  UNION
  SELECT '% [Bb]ouy %'
  UNION
  SELECT '% [Bb]ouyant %'
  UNION
  SELECT '% [Bb]uisness %'
),
MyPosts (Id, Title, CreationDate, STitle, SBody)  
AS  
(  
SELECT 
  Posts.Id,
  Posts.Title,
  Posts.CreationDate,
  (
    SELECT count(*) FROM Words
    WHERE Posts.Title Like Words.Value
  ) AS STitle,
  (
    SELECT count(*) FROM Words
    WHERE Posts.Body Like Words.Value
  ) AS SBody
  FROM Posts
  WHERE Posts.PostTypeId IN (1,2)       -- Q(1) and A(2)
    AND Posts.Score >= ##Score:int##
    AND Posts.ClosedDate IS NULL
    AND Posts.CommunityOwnedDate IS NULL
    AND Posts.DeletionDate IS NULL
)

SELECT TOP 500
  Id as [Post Link],
  CreationDate,
  STitle,
  SBody
FROM MyPosts
WHERE (len(Title) < ##TitleLen:int## AND len(Title) >= (##TitleLen:int##) - 50)
  AND (STitle + SBody) > 1
GROUP BY CreationDate, Id, SBody, STitle
ORDER BY CreationDate ASC, Id ASC

-- (SELECT sum(*) from (SELECT * FROM Common WHERE Posts.Title Like Common.Value)) as PTitle

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results