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 “croakier” 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.

242 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
croakier1443626(None) 
creakier14328331creakier
croaker133010681croak_er
brakier133812362br_akier
cakier123115242c__akier
chokier1638042cho_kier
coalier93416182c_oalier
cockier154013622c_ockier
corkier133114302c_orkier
crankier14339162crankier
crazier183610742cr_azier
creamier12319062creamier
creasier103210192creasier
croaked143710532croak_ed
croakers14288522croak_ers
croakiest15167172croakiest
croakily1744732croakily
croaking153712162croaking
crooker134111092crook_er
crosier94116572cro_sier
croupier1246882croupier
crozier18369932cro_zier
freakier15246482freakier
oakier104011392__oakier
rockier134911882_rockier
rookier114012382_rookier
beakier134012163_beakier
blockier1666133blockier
boskier13309173_boskier
brasier94516753br_asier
brazier183911473br_azier
breaker133912923break_er
brickier16307163brickier
broacher15329263broacher
broader103412613broa_der
broker124314243bro_k_er
bronzier1935633bronzier
broodier1157433broodier
brookie1347373brookie_
brookies1459143brookies
broomier1236873broomier
brownier13226913brownier
cagier93715933c__agier
cahier113615773c__ahier
carmaker1637313carmak_er
cavalier1348183cavalier
chalkier1736753chalkier
charier124317903c_harier
cheekier1735103cheekier
chinkier17377363chinkier
choker154314373cho_k_er
choosier1337173choosier
choppier17286643choppier
chromier1538033chro_mier
chunkier17395883chunkier
clankier14327083clankier
clavier1239173c_lavier
clayier1248323c_layier
cloaked14368543cloak_ed
cloaking15299713cloaking
clocker153910873clock_er
cloddier1234063cloddier
cloggier1244253cloggier
clothier1335363clothier
cloudier1135053cloudier
clunkier14345793clunkier
coacher143714123c_oacher
coaler84121713c_oa_ler
coarser93211203c_oarser
coaster94219043c_oaster
coater84329573c_oa_ter
coaxer153912793c_oa_xer
cobbier133410163c_obbier
cocker144320393c_ock_er
collier93618153c_ollier
comaker153410603comak_er
comfier1439163c_omfier
conker124721553c_onk_er
cooker124722453c_ook_er
cookie123716043c_ookie_
cookies133719273c_ookies
copier103722893c_o_pier
corker124720853c_ork_er
cornier93017093c_ornier
cosier84423753c_o_sier
cottier93814173c_ottier
courier93617893c_ourier
cowier113616163c_o_wier
cozier173315143c_o_zier
crabber133810733cr_abber
crabbier14326803crabbier
cracker153114173cr_acker
cracklier1744823cracklier
cradler102910513cr_adler
crafter124111333cr_after
craftier1376193craftier
craggier12116063craggier
crake114823523cr_ak_e_
crakes124921813cr_ak_es
crammer134010963cr_ammer
crampier14288903crampier
cranker133612793cr_anker
crapper133913193cr_apper
crappier14288133crappier
crasher124616163cr_asher
crasser94114343cr_asser
crater85026643cr_a_ter
craver114618473cr_a_ver
crawler123510463cr_awler
crawlier13216873crawlier
crazies183413853cr_azies
creaked143413233creak_ed
creakiest15238593creakiest
creakily1735393creakily
creaking153414123creaking
creamer113714093crea_mer
creaser94415743crea_ser
creepier1236253creepier
crepier1139743cr_epier
crier74724463cr___ier
crimpier14287323crimpier
crinklier1543843crinklier
crispier12297253crispier
croak115216633croak___
croaks125812983croak__s
croaky15528483croak__y
crocked164014433crock_ed
crockery19356603crock_ery
crocket154615673crock_et
crocking174313443crocking
crofter12299573cro_fter
cronies9622503cro_nies
crooked143910943crook_ed
crookeder1642823crookeder
crookery17415993crook_ery
crooking153611343crooking
crooner93714043cro_oner
cropper133312963cro_pper
croppie13278793croppie_
croppies143111133croppies
crosiers103312063cro_siers
crosser95015463cro_sser
croupiers1334653croupiers
crowder13389863cro_wder
crowdie1335913crowdie_
crowdies1437553crowdies
crower114117563cro__wer
crowner124012603cro_wner
crozer175112843cro__zer
croziers19287003cro_ziers
cruddier1244153cruddier
crumbier1456363crumbier
crummier1435603crummier
crustier10259533crustier
dorkier122810023_dorkier
dreamier11287293dreamier
drearier9297923drearier
droolier936073droolier
droopier1145573droopier
droskies13186343droskies
drossier956313drossier
drowsier1284903drowsier
flakier143910203_flakier
floatier1136983floatier
flockier1745343flockier
foamier12339003_foamier
folkier14359043_folkier
forkier144311593_forkier
friskier1535193friskier
froggier1354643froggier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
frouzier2043703frouzier
frowsier1444893frowsier
frowzier2343313frowzier
grapier103712603gr_apier
grazier173611133gr_azier
greasier9298083greasier
groaner82510133groa_ner
grodier939673gro_dier
groggier1134343groggier
groovier1233793groovier
grottier9316673grottier
groutier9297173groutier
growlier1234883growlier
hoarier104211743_hoarier
hokier134214033_ho_kier
hookier143811673_hookier
jokier17618753_jo_kier
kookier10398283_kookier
lakier104716273__lakier
leakier114010993_leakier
loamier9349163_loamier
peakier134411443_peakier
pockier153911603_pockier
pokier124914633_po_kier
porkier133712343_porkier
prickier16368143prickier
prosier93817483pro_sier
quakier20239203_quakier
racier85120973_r_acier
raker94529793_r_ak_er
rapier84019993_r_apier
readier83117423_readier
reekier113111123_reekier
riskier1138423_riskier
roadie72813813_roadie_
roadies83317443_roadies
roamer84715163_roa_mer
roarer63914333_roa_rer
roaster74116663_roaster
rocker124319573_rock_er
roilier7311523_roilier
rookie103613263_rookie_
rookies113917103_rookies
roomier93812243_roomier
rootier74915393_rootier
ropier84118803_ro_pier
rosier64221263_ro_sier
roupier9319493_roupier
rowdier11348593_rowdier
scroggier1343133scroggier
shakier143411153_shakier
shoalier1137073shoalier
smokier1356703smo_kier
snakier112810003_snakier
sneakier1245143sneakier
soaker105717533_soak_er
soapier93411713_soapier
spookier14175493spookier
stockier14217253stockier
streakier1334843streakier
throatier1244553throatier
trickier143010233trickier
troaked12438253troak_ed
troaking133310973troaking
troutier8277153troutier
tweakier1533143tweakier
wonkier1437423_wonkier
wreaker143610043wreak_er
yolkier14336123_yolkier

Search took 9 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.423422437.4
2DLD Change Limit1461622427.65319098.7
3Display Results2422420.1102200.0
 (SQL Overall)1786912428.18621828.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.