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

423 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
circled123758(None) 
circle1039701circle_
circler1136421circler
circles1139901circles
circlet11311471circlet
birched15349912birched
birled94416992bir_led
caroled103717692caroled
cinched153910862cinched
circlers1235352circlers
circlets1235662circlets
cricked164814282cricked
curdled113910662curdled
curled95021652cur_led
cycled1436542c_ycled
dirled84514902dir_led
encircled1443332encircled
girdled10217452girdled
hirpled13157142hirpled
hirsled11118112hirsled
icicled1234292icicled
kirtled12287032kirtled
recircled1443522recircled
tirled74714362tir_led
ailed66240283ai__led
aircrew12113913aircrew
aired66032923air__ed
airshed11258533airshed
airted74214503air_ted
airthed11328303airthed
aisled74516183ai_sled
arced88224163_arc_ed
arched125717323_arched
arcked136211943_arcked
argled85314553_argled
ariled75620323_ariled
auricled11135703auricled
bicycled1843133bicycled
billed94224903bi_lled
birchen14347883birchen
birches143412323birches
birded104414303bir_ded
birdied11329433birdied
birle75023633bir_le_
birler85715083bir_ler
birles84920643bir_les
birred94713203bir_red
birthed13228593birthed
bitched153212923bitched
bricked164312063bricked
bridled113611143bridled
burbled124312673burbled
burgled115511423burgled
burled94825383bur_led
byrled12437173byr_led
cabled114819873c_abled
cached145419203c_ached
cackled164613303cackled
cairned1037643cair_ned
cajoled17428283cajoled
called94126733c_alled
canaled103615563canaled
canceled13279403canceled
candled113815743candled
caracoled1445993caracoled
carcel105018673carc_el
carcels114516063carcels
carded105424903car_ded
cared86050093car__ed
caried94528693car_ied
carked134024823car_ked
carle74535703car_le_
carles85435083car_les
caroler93816753caroler
carolled1138833carolled
caromed123713623caromed
carped115923763car_ped
carried103717153carried
carted98631443car_ted
carved124320853car_ved
castled104311513castled
caviled1348723caviled
ceiled94114953c_eiled
celled94420323c_elled
cerated103922473cerated
cered85227443cer__ed
checked193710023checked
chicle134312543chicle_
chicles143512503chicles
chilled133310933chilled
chirked173810333chir_ked
chirmed15379733chir_med
chirped15379783chir_ped
chirred133612123chir_red
chiseled1435883chiseled
chocked194411613chocked
chortled14326613chortled
chromed153510923chromed
chucked19469733chucked
chuckled2045163chuckled
churched1934653churched
cicale10314503cicale_
cicely1338833ci_cely
cichlid1545313cichlid
cinches144215773cinches
circa9311403circ__a
circling1338423circling
circuit1148833circuit
circuited1444563circuited
circular1247903circular
circulated1588063circulated
circus104310593circ_us
circuses1238253circuses
circusy14374593circusy
cire65836373cir__e_
cires74932913cir__es
cirque1735853cirque_
cirques1836463cirques
cirriped1344183cirriped
cirsoid1038123cirsoid
ciscoes113610733ciscoes
cisted95217523ci_sted
cited84421953ci__ted
citied94014143ci_tied
citole8311503citole_
citoles9312553citoles
citrated112712253citrated
clacked164113603clacked
cliched153711023cliched
clicked164112453clicked
clinched16347383clinched
clocked164112833clocked
clucked163810133clucked
coached153313843coached
coacted123611613coacted
coaled95022713c_oaled
cobbled143411633cobbled
cocked155022563c_ocked
cockled163710823cockled
coddled123410573coddled
coerced1238583coerc_ed
coffled16297363coffled
coiled95123943c_oiled
coled85540763c__oled
cooled95224593c_ooled
coracle112011723coracle_
coracles121811163coracles
corbeled1338373corbeled
corded105923353cor_ded
cored85044223cor__ed
corked135020783cor_ked
corned95224523cor_ned
cornfed1337383cornfed
corslet9318063corslet
coruler9311713coruler
couched154115793couched
coupled124312673coupled
cowled125218393c_owled
craaled10339423craaled
cracked163514743cracked
crackled17428863crackled
cradled113410813cradled
craned96121653c_raned
craped116120523c_raped
crated94827773c_rated
craved125417773c_raved
crawled133710403crawled
crazed184714453c_razed
cred76530883c_r__ed
creed85727393c_r_eed
creeled104012013creeled
creped114115703c_reped
crewed125316563c_rewed
cribbed14407663cribbed
cribbled15305803cribbled
cricket154716953cricket
crickey18418143crickey
cricoid1239243cricoid
cried84624283c_r_ied
crimped143910763crimped
crimpled15366933crimpled
cringed113312403cringed
crinkled15357153crinkled
crippled15336793crippled
crisped124010103crisped
crocked164014433crocked
crowed124717303c_rowed
cuddled124110763cuddled
cuittled1133993cuittled
culled94022473c_ulled
cupeled1257793cupeled
curated104717583curated
curbed114615873cur_bed
curches143512743curches
curded104217163cur_ded
curdle95514313curdle_
curdler103511563curdler
curdles103814573curdles
cured85932133cur__ed
curler85221323cur_ler
curlew114010903cur_lew
curred94319263cur_red
curried103313653curried
cursed94321253cur_sed
curule83614123curule_
curved124815223cur_ved
cuttled10319933cuttled
cycle1239523c_ycle_
cycler1335913c_ycler
cycles1339303c_ycles
darkled13378723darkled
dartled9409853dartled
dialed84716453di_aled
dialled9510133dialled
dibbled133510843dibbled
diced95824683di_c_ed
dicked144920863di_cked
diddled114212053diddled
dilled84122223di_lled
dimpled132810303dimpled
dindled104412723dindled
directed1238233directed
dirked124912273dir_ked
dirtied93210853dirtied
disced104914653disc_ed
discoed11312483discoed
ditched143711903ditched
drilled94711673drilled
encircle1243943encircle_
encircles1343923encircles
farced125216533farc_ed
feruled11318423feruled
fiddled13329633fiddled
filched16307423filched
filed95331903fi__led
filled104922263fi_lled
fired94829743fir__ed
firmed125411883fir_med
fizzled19357273fizzled
forced126316523forc_ed
frilled113911603frilled
furled104717053fur_led
garbled114512803garbled
gargled104210673gargled
giggled114010073giggled
gilled84521633gi_lled
girded93712493gir_ded
girdle82110463girdle_
girdler9227313girdler
girdles92210003girdles
girned84010513gir_ned
girted83912873gir_ted
girthed12266243girthed
grilled94012833grilled
gurgled10399123gurgled
higgled13339073higgled
hilled104022223hi_lled
hired95226263hir__ed
hirple11158973hirple_
hirples12149643hirples
hirseled12106253hirseled
hirsle9159573hirsle_
hirsles101510073hirsles
hitched163312253hitched
hurdled12379833hurdled
hurled104617453hur_led
hurtled11339593hurtled
iced78721893_i_c_ed
icicle1036583icicle_
icicles1135943icicles
idled74915213_i_dled
impled113812513_impled
inched124514483_inched
ired55131873_ir__ed
irised73913153_irised
irked104510923_ir_ked
ironed74916013_ironed
isled64615993_i_sled
itched123812023_itched
jiggled17358843jiggled
jingled164111063jingled
kibbled16367983kibbled
kicked124415943ki_cked
killed113918773ki_lled
kindled133410543kindled
kirned11408623kir_ned
kirtle10309473kirtle_
kirtles11309663kirtles
kittled12388193kittled
libeled10249413libeled
licked134621563li_cked
lurched13358033lurched
macled116718113_macled
marbled123212113marbled
marched153813403marched
marled95523163mar_led
miauled1036663miauled
miched143913393mi_ched
middled123311903middled
milled94326173mi_lled
minced114114913minc_ed
mingled113612733mingled
miracle1138843miracle_
miracles1238333miracles
mired85729223mir__ed
miscued1239293miscued
misled94719313mi_sled
mispled12310463mispled
misruled1137083misruled
mizzled18327633mizzled
muraled10410833muraled
muscled1237783muscled
nibbled12389073nibbled
niched125514063ni_ched
nicked135019683ni_cked
nickled144010443nickled
niggled10319203niggled
nilled73919453ni_lled
nippled12307643nippled
nurled74016233nur_led
oiled64429473oi__led
parceled1338343parceled
parched154013693parched
parled94626293par_led
paroled104217633paroled
perched154713243perched
periled10316323periled
picked154421313pi_cked
pickled164011883pickled
piddled123311253piddled
pieced113912103piec_ed
pierced12347593pierc_ed
piffled16366403piffled
piled85232993pi__led
pilled94222753pi_lled
pimpled14289193pimpled
pinched153812453pinched
pirated102515613pirated
pitched153512923pitched
priced115018883pric_ed
pricked164613833pricked
prickled17358073prickled
prilled104713003prilled
purfled13248733purfled
purled94520753pur_led
purpled12299783purpled
recircle1244433recircle_
recircles1344433recircles
riced85825543ri_c_ed
ricked136523623ri_cked
riddled103012043riddled
riffled14338603riffled
rifled104115003ri_fled
riled65833253__riled
rilled74525653ri_lled
rimpled123311423rimpled
rippled123110273rippled
rivaled1138933rivaled
ruled65822523__ruled
scorched16187203scorched
sicced11489653si_cced
sicked134524403si_cked
sickled144713433sickled
sidled84215173si_dled
singled93914683singled
sired66134283sir__ed
siruped1036013siruped
sizzled16367883sizzled
skirled12348183skir_led
smirched1634673smirched
spiraled1137733spiraled
swirled11308223swir_led
thirled11328093thir_led
ticced11438443ti_cced
ticked134720523ti_cked
tickled144313133tickled
tierced10347053tierc_ed
tiled64832943ti__led
tilled74722953ti_lled
tincted1037273tincted
tingled93712803tingled
tinkled123910473tinkled
tippled12358393tippled
tired65228903tir__ed
titled73815003ti_tled
torched133511363torched
triced95518673tric_ed
tricked144016163tricked
trickled152610433trickled
triclad1037443triclad
trifled113711963trifled
trilled84116313trilled
tripled104113833tripled
turtled8309683turtled
twirled11385983twir_led
unruled8311373unruled
vialed105112593vi_aled
vialled1156843vialled
viced115118183vi_c_ed
virile9313433virile_
vittled11347343vittled
warbled133212163warbled
warsled112910443warsled
whirled14368043whir_led
wicked164317413wi_cked
widdled133511233widdled
wiggled13299603wiggled
wiled95231553wi__led
willed104722453wi_lled
wimbled15298153wimbled
wimpled15338823wimpled
winced124415343winc_ed
winched163110593winched
windled123713483windled
winkled15299593winkled
wintled11339843wintled
wired95327643wir__ed
witched163012193witched
wricked174910193wricked
yirred10426963yir_red
zinced18419413zinc_ed
zincked2334233zincked
zizzled15315853zizzled

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.513348325.5
2DLD Change Limit1340274236.93619323.4
3Display Results4234230.1602643.8
 (SQL Overall)1786914237.60923484.2
 
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.