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

232 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
crackly1839770(None) 
crackle153611251crackle
cracky175010221crack_y
crankly16358121crankly
blackly1835252blackly
cackle143416922c_ackle
crack134120532crack__
cracked163514742cracked
cracker153114172cracker
crackled17428862crackled
crackles164111272crackles
cracks144817002crack_s
crackup1743562crackup
crankily1755622crankily
crankle133610062crankle
cranky153910632crank_y
crassly1276652crassly
crawly144610762cra_wly
crazily2136922crazily
crickey18418142crickey
crinkly16387522crinkly
frankly17315632frankly
freckly19124592freckly
grackle14338892grackle
hackly18298732_hackly
packly17228332_packly
prickly18367892prickly
racily11715172_racily
rackle123917292_rackle
rankly133910452_rankly
slackly1635262slackly
trickly16369892trickly
archly1437353ar_chly
blackfly2243013blackfly
blankly1634263blankly
bracken15409813bracken
bracket154117233bracket
braky145015813bra_k_y
brambly16296253brambly
brashly15427613brashly
bravely15428233bravely
brawly144312353bra_wly
brickle15279933brickle
bricky17489093brick_y
briskly16165403briskly
cackled164613303c_ackled
cackler153812573c_ackler
cackles153717203c_ackles
cagily12411563c_agily
cakey145517273c_a_key
caky136222443c_a_k_y
calmly1337613c_almly
caracal11312513caracal_
caracals12310743caracals
carack142113173carack__
caracks152211563carack_s
caracol11310423caracol_
caracole12310353caracole
caracols12310413caracols
caracul1138823caracul_
caraculs1238033caraculs
carcel105018673carcel_
carcels114516063carcels
casky144512683c_ask_y
cecally1459393cecally
chalky18468773chalk_y
chally144314293cha_lly
chancily1845243chancily
charily15310283charily
chicly16429203chic_ly
chuckle1836443chuckle
chucky20418003chuck_y
cicely1338833c_icely
clack134720173clack__
clacked164113603clacked
clacker153813773clacker
clacks144516343clack_s
clanky15469073clank_y
clerkly1643573clerkly
coaly105521593coa__ly
cockily1838493c_ockily
cockle143913573c_ockle
cocky164215933c_ock_y
coracle112011723corac_le
craal74117753cra_al_
craals84113303cra_als
crabbily1744343crabbily
crabby15346753cra_bby
crackers164111723crackers
cracking174013903cracking
cracklier1744823cracklier
crackling18157003crackling
cracknel1643703cracknel
cracknels1743433cracknels
crackpot1843833crackpot
crackups1843123crackups
cradle93313163cra_dle
craftily1644783craftily
crafty14478913cra_fty
craggily1543703craggily
craggy13396603cra_ggy
crake114823523cra_k_e
crakes124921813cra_kes
crampy154710993cra_mpy
crank114819613crank__
cranked143812843cranked
cranker133612783cranker
crankled15408153crankled
crankles143510153crankles
cranks125015313crank_s
cranny114210273cra_nny
crapola1136913crapola
crappy15446803cra_ppy
cravenly1644663cravenly
crawl104916713cra_wl_
crawls114712083cra_wls
crazy195511223cra__zy
creakily1735393creakily
creaky154911553creak_y
creamily1536363creamily
crick135118753crick__
cricked164814283cricked
cricket154716953cricket
cricks144316053crick_s
crikey15317783cr_ikey
crinkle13359413crinkle
crisply14426523crisply
croakily1744733croakily
croaky15528483croak_y
crock135921993crock__
crocked164014433crocked
crockery19356603crockery
crocket154615673crocket
crocks145118423crock_s
crossly1277273crossly
crucify1744063crucify
cruck135615323cruck__
crucks144412583cruck_s
crudely1336273crudely
cruelly1236563cruelly
crumbly16347523crumbly
crumply16336093crumply
crusily12199093crusily
curably142010773cura_bly
curacy1339593curac__y
dankly14419463_dankly
darkly145411073_darkly
drably123511613dra_bly
drawly134910723dra_wly
drecky16486333dreck_y
erectly1257483erectly
exactly1953823exactly
feckly18335963_feckly
fickly18318533_fickly
frailly1337313frailly
freckle16106643freckle
gracile102512603gracile
grackles15309183grackles
grandly1238743grandly
gravely14469063gravely
grayly13287963gra_yly
hackle154916813_hackle
irately1047683irately
jacky215412343_jack_y
knuckly1542473knuckly
lacily11612763_lacily
lackey154813353_lackey
lankly13439623_lankly
mackle143716433_mackle
oracle84313293orac_le
orally93113593ora_lly
pricily142710283pricily
prickle153611013prickle
pricky174210343prick_y
quacky24376963quack_y
quickly2534073quickly
rack106234883_rack__
racked134526083_racked
racker124824553_racker
racket125229423_racket
rackety16499113_rackety
racks115028853_rack_s
racy95825683_rac__y
rally84725903_ra_lly
rankle103414883_rankle
raptly11338913_raptly
rarely93513653_rarely
rashly123410213_rashly
rattly94111543_rattly
rawly115115833_ra_wly
richly1438003_richly
rickey154613973_rickey
rocky144513853_rock_y
ruckle124414583_ruckle
scarcely1534313scarcely
scrabbly17164623scrabbly
scraggly15294143scraggly
scrawly15197193scra_wly
shackle16409543shackle
sickly153110483_sickly
slickly1635853slickly
spackle15369573spackle
sparkly16348133sparkly
starkly14277033starkly
tackey154613083_tackey
tackily1637503_tackily
tackle123815733_tackle
tacky145617443_tack_y
thickly19415573thickly
tracery12399793tracery
trachle12311853trachle
track114823013track__
tracked143716133tracked
tracker133515173tracker
tracks124818843track_s
trackway20113783trackway
treacly1237093treac_ly
trickily1736233trickily
trickle133613443trickle
tricksy16436583tricksy
tricky154211473trick_y
truckle13358863truckle
uracil8311543uracil_
uracils939373uracils
wackily1936053_wackily
wacky174714933_wack_y
weakly1636483wea_kly
whacky21556493whack_y
wrack145413883wrack__
wracked174110113wracked
wracks154711113wrack_s
wrinkly17295753wrinkly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272325.89022755.0
3Display Results2322320.0932494.6
 (SQL Overall)1786912326.38927968.5
 
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.