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

290 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
crackle15361125(None) 
cackle143416921c_ackle
crackled17428861crackled
crackles164111271crackles
crackly18397701crackly
crankle133610061crankle
grackle14338891grackle
rackle123917291_rackle
brickle15279932brickle
cackled164613302c_ackled
cackler153812572c_ackler
cackles153717202c_ackles
caracole12310352caracole
chuckle1836442chuckle
cockle143913572c_ockle
coracle112011722corac_le
crack134120532crack__
cracked163514742cracked
cracker153114172cracker
cracklier1744822cracklier
cracknel1643702cracknel
cracks144817002crack_s
crackup1743562crackup
cracky175010222crack_y
cradle93313162cra_dle
crake114823522cra_k_e
crankled15408152crankled
crankles143510152crankles
crankly16358122crankly
crinkle13359412crinkle
freckle16106642freckle
gracile102512602gracile
grackles15309182grackles
hackle154916812_hackle
mackle143716432_mackle
oracle84313292orac_le
prickle153611012prickle
rankle103414882_rankle
ruckle124414582_ruckle
shackle16409542shackle
spackle15369572spackle
tackle123815732_tackle
trachle12311852trachle
trickle133613442trickle
truckle13358862truckle
ackee115825373__ackee
ankle95220253__ankle
arable81821003ara_ble
blackleg1734233blackleg
blackly1835253blackly
brabble10349973brabble
brace95629273brac__e
bracelet12310693bracelet
braciole1246973braciole
bracken15409813bracken
bracket154117233bracket
bractlet1239283bractlet
braille939713braille
brake116025343bra_k_e
bramble133710033bramble
brattle9249253brattle
brickles162810283brickles
bricole112810493bricole
buckle144815193_buckle
cable95329913c_a_ble
cache125122483c_ac_he
cacklers163710703c_acklers
cajole154011183c_ajole
cake105439963c_a_k_e
candle94321483c_andle
cantle84522153c_antle
caracal11312513caracal_
caracals12310743caracals
carack142113173carack__
caracks152211563carack_s
caracol11310423caracol_
caracoled1445983caracoled
caracoler1346413caracoler
caracoles13310073caracoles
caracols12310413caracols
caracul1138823caracul_
caraculs1238033caraculs
carcase11312733carcase
carcel105018673carcel_
carcels114516063carcels
cariole9818343cariole
carle74535703c_a_rle
carpale113414353carpale
castle84918963c_astle
cattle85118903c_attle
caudle93912913c_audle
cenacle1139123cenac_le
chickee183111553chickee
chicle134312543chic_le
chuckled2045163chuckled
chuckler1935553chuckler
chuckles1936803chuckles
cicale10314503c_icale
circle1039703circ_le
clack134720173clack__
clacked164113603clacked
clacker153813773clacker
clacks144516343clack_s
cockled163710823c_ockled
cockles153414643c_ockles
coracles121811163corac_les
craal74117753cra_al_
craaled10339423cra_aled
craals84113303cra_als
crackers164111723crackers
crackhead2143323crackhead
cracking174013903cracking
crackliest1844883crackliest
crackling18157003crackling
cracknels1743433cracknels
crackpot1843833crackpot
cracksmen1943073cracksmen
crackups1843123crackups
cradled113410813cra_dled
cradler102910513cra_dler
cradles103114133cra_dles
crakes124921813cra_kes
crambe1239073cra_mbe
crane75331603cra__ne
crank114819613crank__
cranked143812843cranked
cranker133612783cranker
crankier14339163crankier
crankily1755623crankily
cranks125015313crank_s
cranky153910633crank_y
crape96128443cra__pe
crapola1136913crapola
crappie13298983crappie
crassly1276653crassly
crate76537403cra__te
crave105626313cra__ve
crawl104916713cra_wl_
crawled133710403cra_wled
crawler123510463cra_wler
crawls114712083cra_wls
crawly144610763cra_wly
craze165221463cra__ze
crazily2136923crazily
creche13310763crec_he
creole8913733cr_eole
crick135118753crick__
cricked164814283cricked
cricket154716953cricket
crickey18418143crickey
cricks144316053crick_s
crimple13408693crimple
cringle103010353cringle
crinkled15357153crinkled
crinkles14269163crinkles
crinkly16387523crinkly
cripple13378583cripple
crocine11314153crocine
crock135921993crock__
crocked164014433crocked
crocket154615673crocket
crocks145118423crock_s
crucible1445193crucible
cruck135615323cruck__
crucks144412583cruck_s
crumble133410403crumble
crumple13368363crumple
curable112414513cura_ble
cycle1239523c_yc_le
darkle113813943_darkle
deckle1312012453_deckle
drabble12238883drabble
draggle1056103draggle
drake104918303dra_k_e
facile112514883_facile
fickle153912973_fickle
fragile1147843fragile
frankly17315633frankly
frazzle18305223frazzle
freckled18104443freckled
freckles17126383freckles
freckly19124593freckly
grabble12339643grabble
grace85124543grac__e
graciles112511613graciles
granule839473granule
grapple12378003grapple
hackee154921833_hackee
hackie154615623_hackie
hackled173312493_hackled
hackler163512353_hackler
hackles162917063_hackles
hackly18298733_hackly
heckle153112093_heckle
huckle153913073_huckle
jackleg2135043_jackleg
keckle11359423_keckle
knuckle1254233knuckle
mackled164111923_mackled
mackles154415753_mackles
macle96127003_mac_le
macule104115273_macule
mickle143715133_mickle
miracle1138843mirac_le
muckle143413583_muckle
nickle123814483_nickle
orache114013593orac_he
oracles93212423orac_les
packly17228333_packly
pickle144215653_pickle
prattle9208833prattle
prickled17358073prickled
prickles162511093prickles
prickly18367893prickly
rabble103818243_rabble
race66746263_rac__e
raceme1039733_raceme
racily11715173_racily
rack106234883_rack__
racked134526083_racked
racker124824553_racker
racket125229423_racket
racks115028853_rack_s
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rake84841573_ra_k_e
rakee96031173_ra_kee
rale45050563_ra__le
ramble104519973_ramble
rankled123910653_rankled
rankles113114543_rankles
rankly133910453_rankly
rassle63813203_rassle
rattle64717613_rattle
retackle1445043retackle
ruckled144111033_ruckled
ruckles133414603_ruckles
runkle103611543_runkle
scrabble14196993scrabble
scramble14177253scramble
scrapple1434683scrapple
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
sickle124418323_sickle
slackly1635263slackly
spackled17297803spackled
spackles16319953spackles
sparkle133710213sparkle
speckle15297553speckle
stickle132410973stickle
strickle1467793strickle
suckle124015963_suckle
tackled143913193_tackled
tackler134013323_tackler
tackles133816523_tackles
tickle124616743_tickle
trace75829613trac__e
trachled1438313trachled
trachles13311753trachles
track114823013track__
trackable1736743trackable
trackage1545653trackage
tracked143716133tracked
tracker133515173tracker
trackless15246723trackless
trackmen1635573trackmen
tracks124818843track_s
tractile10311073tractile
trample11299703trample
trauchle1344963trauchle
treacle939973treac_le
trickie132611033trickie
trickled152610433trickled
trickles143013763trickles
trickly16369893trickly
truckled15327313truckled
truckler14297453truckler
truckles14319383truckles
uracil8311543uracil_
uracils939373uracils
wacke145918623_wack_e
wrack145413883wrack__
wracked174110113wracked
wracks154711113wrack_s
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle
wrinkle14296923wrinkle

Search took 8 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.390458182.1
2DLD Change Limit1340272906.50020619.5
3Display Results2902900.1102636.4
 (SQL Overall)1786912907.00025527.3
 
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.