Posts with typos; younger than X days, scoring at least Y

1

Please login or register to vote for this query.

(click on this box to dismiss)

first U&L question was August 10 2010; as of 1/20/2018 oldest age in days is 2720 days. Q/A -- Nice score=10; Good score=25; Great score=100. Q's only: Popular=1,000 views, Notable=2,500 views, Famous=10,000 views http://hyperboleandahalf.blogspot.com/2010/04/alot-is-better-than-you-at-everything.html 2018-02-21: 234 hits at 3600 / 5 2018-02-25: 186 hits at 3600 / 5 2018-03-01: added space in front of "dont" search text 2018-03-04: 150 hits at 3600 / 5 2018-03-11: 108 at 3600 / 5 2018-03-18: 62 at 3600 / 5

DevOps

Q&A for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT Id as [Post Link], Id, CreationDate, Score, ViewCount, LEN(Body) as Size
FROM Posts
WHERE (
   Body LIKE '% teh %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%plz%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%idk%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% sth%' COLLATE SQL_Latin1_General_Cp1_CI_AS 
OR Body LIKE '% smth%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%wanna %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%gotta%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%dunno%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% dont %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% cant %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%doesnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR
(  Body LIKE '%wont %' COLLATE SQL_Latin1_General_Cp1_CI_AS
   AND
   Body NOT LIKE '%wont to%' COLLATE SQL_Latin1_General_Cp1_CI_AS
)
OR Body LIKE '%hasnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%isnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%didnt %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%whats %' COLLATE SQL_Latin1_General_Cp1_CI_AS

OR Body LIKE '%everytime%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%seperate%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%alot%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%usefull %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%adress %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%deamon%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%succesfully%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%enviroment%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%formated%' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '% Ive %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%comand %' COLLATE SQL_Latin1_General_Cp1_CI_AS
OR Body LIKE '%approx %' COLLATE SQL_Latin1_General_Cp1_CI_AS

-- too many false-positives
-- OR Body like '% i %'  
or Body like '% i''m %' or Body like '% i''d %' COLLATE SQL_Latin1_General_CP1_CS_AS
)
-- "plz" exceptions
AND Id NOT IN (387156, 306157, 223386, 9385, 402471, 402463)
AND ClosedDate IS NULL
AND DATEDIFF(DAY, CreationDate, GETDATE()) < ##Age:int?3600##
AND Score >= ##Score:int?5##
ORDER by CreationDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results