Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “crookest” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
crookest143668(None) 
coolest9318642c_oolest
crankest1438142crankest
croakiest15167172croakiest
crocket154615672crocke_t
crockets16339542crockets
crooked143910942crooke_d
crookedest1752572crookedest
crooker134111092crooke_r
crookery17415992crookery
crooks124914412crook_s_
crossest1012012122crossest
rookiest122912172_rookiest
bookrest1436493_bookrest
briskest14337803briskest
broadest1138573broadest
brocket154013383brocke_t
brockets16328123brockets
broodiest1237823broodiest
brooked143610033brooke_d
brookies1459143brookies_
brooklet1456403brooklet
brooklets1543683brooklets
brooks125813883brook_s_
broomiest1356913broomiest
brownest1398893brownest
bruskest14315903bruskest
chirkest1735383chirkest
choicest15226453choicest
chokes154917383c_hokes_
chokiest1738723chokiest
chooks155312793chook_s_
chooses125717413chooses_
choosiest1437323choosiest
chromiest1637783chromiest
closest94312533c_losest
cockiest163013293c_ockiest
cokes115537193c__okes_
coldest102514753c_oldest
congest104618773c_ongest
contest93523233c_ontest
cooees85621893c_ooees_
cooked135921363c_ooke_d
cooker124722453c_ooke_r
cookers134619463c_ookers
cookery164210393c_ookery
cookey155414333c_ooke_y
cookeys16478503c_ookeys
cookies133719273c_ookies_
cookless14258633c_ookless
cookout13410143c_ookout
cooks115429143c_ook_s_
corkiest143114793corkiest
corniest102117303corniest
coronet94227173corone_t
coronets103814363coronets
cosiest93819853c_osiest
cowiest123614673c_owiest
coyest11316053c__oyest
coziest184014353c_oziest
crakes124921813cr_akes_
crankiest1538823crankiest
crassest103411523crassest
craziest19319923craziest
creakiest15238593creakiest
creoles9913323creoles_
crepiest12310383crepiest
crest74632693cr___est
cricket154716953cricke_t
crickets16418123crickets
crispest12177373crispest
croaked143710533croake_d
croaker133010683croake_r
croakers14288503croakers
croaks125812983croak_s_
crochet143616663croche_t
crochets15359833crochets
crocked164014433crocke_d
crockery19356603crockery
crockpot1844293crockpot
crocks145118423crock_s_
crones84729243cr_ones_
cronies9622503cronies_
crook115217573crook___
crookeder1642813crookeder
crookedly1942023crookedly
crooking153611343crooking
crookneck1651333crookneck
crooned103813343croone_d
crooner93714043croone_r
crooners103911393crooners
croons85418423croo_ns_
cropless1237793cropless
croquet1859683croque_t
croquets1955213croquets
crores86121163cr_ores_
crosses94220793crosses_
croupes114613103croupes_
croupiest1337053croupiest
croutes94815643croutes_
crowfeet1645553crowfeet
crownet123714113crowne_t
crownets13407673crownets
crozes174417663cr_ozes_
crudest104510333cr_udest
cruelest1059183cruelest
drollest937353drollest
drooliest1036343drooliest
droopiest1235743droopiest
drunkest1334423drunkest
frankest1536963frankest
gooiest82813883_gooiest
grodiest10310553grodiest
grooves11368803grooves_
grooviest1334083grooviest
grossest93810093grossest
hookiest152712103_hookiest
kookiest11268133_kookiest
lookist1139563_lookist
loosest75811563_loosest
poorest9312773_poorest
prosiest10416523prosiest
protest9317533pr_otest
proudest1138943proudest
provokes1776603provokes_
prowest12311533pr_owest
rankest112713813_rankest
rocket125425283_rocke_t
rockets134615363_rockets
rockiest142912223_rockiest
rooked114918143_rooke_d
rookery14398313_rookery
rookies113917103_rookies_
rooks95325043_rook_s_
roomiest102611993_roomiest
rooses65526233_rooses_
roost55730933_roo__st
rootiest83115593_rootiest
ropiest93317773_ropiest
rosiest73919213_rosiest
scrooges1137163scrooges_
soonest7415593_soonest
spookiest15156393spookiest
trokes104019263tr_okes_
wrongest1236733wrongest
zooiest16199923_zooiest

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1561145455.1
2DLD Change Limit1461621469.48615408.2
3Display Results1461460.0602433.3
 (SQL Overall)1786911469.70218418.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.