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

425 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
croaky1552848(None) 
creaky154911551creaky
croak115216631croak_
croaks125812981croaks
braky145015812br_aky
caky136222442c__aky
choky175711222cho_ky
cloak115214012cloak_
cloaks124411262cloaks
coaly105521592c_oaly
cocky164215932c_ocky
coky137526822c_o_ky
conky145818742c_onky
cooky145321362c_ooky
corky145221152c_orky
cracky175010222cracky
crake114823522cr_ake
cranky153910632cranky
crazy195511222cr_azy
creak115418432creak_
creaks124315962creaks
creamy134811362creamy
creasy114612302creasy
croaked143710532croaked
croaker133010682croaker
croakily1744732croakily
crock135921992crock_
crocks145118422crocks
crony105918672cro_ny
crook115217572crook_
crooks124914412crooks
croupy13458732croupy
crowdy15467172crowdy
drosky14486162drosky
freaky16439232freaky
oaky116419952__oaky
rocky144513852_rocky
rooky126117622_rooky
screaky16436212screaky
troak95213572troak_
troaks104410592troaks
arak86929573ar_ak_
araks94820883ar_aks
ariary94114203ariary
array86317143arra_y
beaky146118023_beaky
blocky17388353blocky
bosky145612393_bosky
brake116025343br_ake
braxy175410893br_axy
bray95232903br_a_y
bready124511183bready
break115319403break_
breaks124816423breaks
briary114912003briary
bricky17489093bricky
broach133611113broach
broad84817693broa_d
broadly1337153broadly
broads94515143broads
brock136017073brock_
brocks145214153brocks
broke116019783bro_ke
brolly114510853brolly
bronzy20306713bronzy
broody124510083broody
brook114717763brook_
brooks125813883brooks
broomy13449953broomy
brosy106115383bro_sy
brothy14519623brothy
browny144510043browny
cagy106321993c__agy
cake105439963c__ake
cakey145517273c__akey
canary11314693canary
caroach1488863caroach
casky144512683c_asky
cavy125920003c__avy
cay87155983c__a_y
cedary12419603cedary
chalky18468773chalky
chary135023133c_hary
chay124924873c_ha_y
cheeky18448613cheeky
chinky185610543chinky
choana1138443choana
chock164316613chock_
chocks174815313chocks
choke145118023cho_ke
chokey184811713chokey
chook146015043chook_
chooks155312793chooks
choosy14459103choosy
choppy18376293choppy
chromy16309903chro_my
chronaxy2343253chronaxy
chucky20418003chucky
chunky18468273chunky
clanky15469073clanky
clary105719613c_lary
clay95927413c_la_y
cloaca1037263cloaca
cloaked14368543cloaked
clock134917983clock_
clocks144916233clocks
cloddy13405233cloddy
cloggy1344873cloggy
clonk114417443clonk_
clonks125013473clonks
clotty11208263clotty
cloudy12517803cloudy
cloy96623833clo__y
clunky15447893clunky
coach125919453c_oach
coact96130573c_oact
coal66939253c_oa_l
coala77521123c_oala
coals76129603c_oals
coapt96131523c_oapt
coast75236263c_oast
coat67558343c_oa_t
coati75624633c_oati
coats75634993c_oats
coax136922973c_oa_x
cobby145516403c_obby
cock126332903c_ock_
cocks135227163c_ocks
coke107038383c_o_ke
colby124415063c_olby
colly104926773c_olly
coly96940533c_o_ly
comake144413423comake
comfy153710213c_omfy
commy144712643c_ommy
coney105932883c_oney
conk106531443c_onk_
conks115525703c_onks
cony96537833c_o_ny
cooey105828223c_ooey
cook107236933c_ook_
cookey155414333cookey
cooks115429143c_ooks
coolly114811393coolly
cooly105525423c_ooly
copay126516313c_opay
copy116229803c_o_py
coral76033453cora_l
corals85325143corals
corby125018533c_orby
cork106635693c_ork_
corks116028273c_orks
corny106023273c_orny
corody12149703corody
coronary1347693coronary
cory96941513c_o_ry
cosey106226713c_osey
cosy97232703c_o_sy
covary1438743covary
covey136121783c_ovey
cowry135512483c_owry
cowy126427363c_o_wy
coy810557553c_o__y
coyly135614893c_oyly
cozey196718543c_ozey
cozy185823803c_o_zy
craal74117753cr_aal
craals84113303craals
crab85727673cr_a_b
crabby15346753crabby
crabs95421393cr_abs
crack134120533cr_ack
crackly18397703crackly
cracks144817003cracks
craft105327663cr_aft
crafty14478913crafty
crag75625303cr_a_g
craggy13396603craggy
crags85622573cr_ags
crakes124921813cr_akes
cram85635493cr_a_m
cramp115120693cr_amp
crampy154710993crampy
crams96229153cr_ams
crane75331603cr_ane
crank114819613cr_ank
crankly16358123crankly
cranks125015313cranks
cranny114210273cranny
crap85731843cr_a_p
crape96128443cr_ape
crappy15446803crappy
craps95328643cr_aps
crash109120013cr_ash
crass76328043cr_ass
crate76537403cr_ate
crave105626313cr_ave
craw97725263cr_a_w
crawl104916713cr_awl
crawly144610763crawly
craws105723123cr_aws
craze165221463cr_aze
creaked143413233creaked
creakily1735393creakily
cream95721343crea_m
creams104715253creams
crease85519573crease
create85126373create
creek114917393creek_
creeks124812923creeks
creepy13418803creepy
crepey135110933crepey
crepy124812703cr_epy
cressy11439113cressy
crick135118753crick_
crickey18418143crickey
cricks144316053cricks
crikey15317783crikey
crimpy15489393crimpy
crinkly16387523crinkly
crispy13478563crispy
croakers14288503croakers
croakier14436263croakier
croaking153712153croaking
croc85723733cro__c
croci95818133cro_ci
crocked164014433crocked
crockery19356603crockery
crocket154615673crocket
crocs95722433cro_cs
crocus104813173crocus
croft105622683cro_ft
crofts114910593crofts
crojik1934113crojik
crojiks2033173crojiks
crone75231333cro_ne
crones84729243crones
crooked143910943crooked
crooker134111093crooker
crookery17415993crookery
croon75522783cro_on
croons85418423croons
crop87628633cro__p
crops96125233cro_ps
crore74922863cro_re
crores86121163crores
cross75124503cro_ss
crosse85216303crosse
crossly1277273crossly
crotch133410083crotch
croton84415453croton
crouch133910203crouch
croup95616783cro_up
croupe105114433croupe
croups104312553croups
crouse84619363crouse
croute84617273croute
crow96428133cro__w
crowd115815623cro_wd
crowds124910763crowds
crowed124717293crowed
crower114117553crower
crown105620083cro_wn
crowns115615113crowns
crows105727313cro_ws
croze164719453cro_ze
crozer175112843crozer
crozes174417663crozes
cruck135615323cruck_
crucks144412583crucks
cruddy1334193cruddy
crumby15408113crumby
crummy15365893crummy
crusty114911343crusty
cry89726243cr___y
crybaby1941933crybaby
curacy1339593curacy
dorky135518743_dorky
drake104918303dr_ake
dray85428093dr_a_y
dreamy12509993dreamy
dreary104611673dreary
drecky16486333drecky
drolly105411673drolly
drooly104911073drooly
droopy12458243droopy
dropsy12497473dropsy
droshky1841973droshky
drossy10528473drossy
drouk1039433drouk_
drouks1137123drouks
drowsy13487903drowsy
euroky1334823euro_ky
flaky155715583_flaky
floaty124210943floaty
flocky18468423flocky
foamy135313203_foamy
folky159214713_folky
foray115023973fora_y
forky156119643_forky
fray105428903fr_a_y
freak125115243freak_
freaks134713063freaks
friary124010093friary
frisky16406673frisky
frock145314653frock_
frocks154111213frocks
froggy1434493froggy
frosty124710633frosty
frothy15578373frothy
frouzy21395283frouzy
frowsy15498273frowsy
frowzy24485793frowzy
gooky135818033_gooky
grapy115416433gr_apy
gravy125512113gr_avy
gray85329893gr_a_y
greasy10419463greasy
groan65618423groa_n
groans74815063groans
groat65531973groa_t
groats74816653groats
grody103412063gro_dy
groggy1234803groggy
grok95819683gro_k_
groks105716123gro_ks
groovy13375403groovy
groszy19395703groszy
grotty10389833grotty
grouty104710983grouty
growly13499173growly
hoagy124710473_hoagy
hoary114516763_hoary
honky156218523_honky
hooky155220263_hooky
horary12310383horary
iroko939663iro_ko
irony85015903iro_ny
joky186215313_jo_ky
kooky114412873_kooky
laky116725823__laky
leaky125217723_leaky
loamy105913343_loamy
moray105423793mora_y
nooky124814813_nooky
oak76238653__oak_
oaks86527903__oaks
okay115917663__okay
peaky145718153_peaky
pocky165314603_pocky
poky135922153_po_ky
porky145019333_porky
pray96331533pr_a_y
pricky174210343pricky
proa66229963proa__
proas75028803proa_s
prosy106319253pro_sy
proxy175011013pro_xy
quaky214310743_quaky
racy95825683_r_acy
rake84841573_r_ake
raki87127833_r_aki
raku85423773_r_aku
ray66361993_r_a_y
ready94821503_ready
reeky125416263_reeky
risky126311523_risky
roach105717003_roach
road56332113_roa_d
roads66523613_roads
roam67132413_roa_m
roams74919613_roams
roan47234203_roa_n
roans54926443_roans
roar46328573_roa_r
roars55622233_roars
roast56230143_roast
rock105735183_rock_
rocks114626413_rocks
roily86121113_roily
rook85532033_rook_
rooks95325043_rooks
roomy107118063_roomy
rooty86423023_rooty
ropey106021873_ropey
ropy96323413_ro_py
rosary92810353_rosary
rosy76024873_ro_sy
rotary92411303_rotary
roupy106112713_roupy
rowdy125711533_rowdy
screak125311053screak_
screaks13469353screaks
scroggy14243843scroggy
shaky154616843_shaky
shoaly124010763shoaly
smoky14388683smo_ky
snaky125113913_snaky
sneaky13427843sneaky
soak87227663_soak_
soaks95220293_soaks
soapy106114783_soapy
spooky15418093spooky
stocky15369153stocky
streaky14447813streaky
throaty13428483throaty
toady96814343_toady
tokay125513053_tokay
tray77632593tr_a_y
treaty94414353treaty
tricky154211473tricky
troaked12438253troaked
trock114817603trock_
trocks123614633trocks
troika1035493troika
troke94821053tro_ke
trolly94012353trolly
trophy1438283trophy
trouty95211793trouty
troy77429683tro__y
tweaky1634023tweaky
wonky154011773_wonky
wreak125513273wreak_
wreaks134711113wreaks
yolky15529523_yolky

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164255.92319030.2
3Display Results4254250.1233455.3
 (SQL Overall)1786914256.18628886.4
 
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.