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

538 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
mickles15341500(None) 
mackles154415751mackles
mickle143715131mickle_
mickler153310231mickler
micklest16219121micklest
muckles153413251muckles
nickles133713821nickles
pickles153215441pickles
sickles133417541sickles
tickles133416851tickles
brickles162810282brickles
buckles153416092buckles
cackles153717202cackles
cockles153414642cockles
deckles143312802deckles
dickies143416342dickies
fickle153912972fickle_
fickler16348422fickler
ficklest17267902ficklest
hackles162917062hackles
heckles163711382heckles
hickies163614742hickies
huckles163612622huckles
inkles103515652_inkles
keckles12318762keckles
mackle143716432mackle_
mackled164111912mackled
macles107023222mac_les
macules114015132macules
micelles1288832micelles
micells11107682micells
miches134320732mic_hes
mickey174211852mick_ey
mickeys18447942mickeys
micks135525372mick__s
middles113415302middles
miggles113512032miggles
mikes115129892mi_k_es
miles74645072mi__les
milkless1434772milkless
milles84526562mi_lles
mingles103719002mingles
minkes124618782mink_es
mizzles17329492mizzles
muckle143413582muckle_
myceles1435212myceles
nickels13338652nickels
nickle123814482nickle_
nickled144010442nickled
pickle144215652pickle_
pickled164011882pickled
prickles162511092prickles
ruckles133414602ruckles
sickees134514212sickees
sickies133717502sickies
sickle124418322sickle_
sickled144713432sickled
sicklies14710012sicklies
stickles142512102stickles
suckles134516742suckles
tackles133816522tackles
tickle124616742tickle_
tickled144313132tickled
tickler133612652tickler
ticklers14339302ticklers
tinkles113713922tinkles
trickles143013762trickles
wickless1736082wickless
winkles143412772winkles
ackees124914573_ackees
aisles64721143ai_sles
amices105018013amic__es
ankles104818383_ankles
backless162910633backless
bibles104617643bi_bles
bices95029963bic__es
bicker144819173bick_er
bickers154316553bickers
bicycles1743883bicycles
bikes117529473bi_k_es
bikies124515163bi_kies
biles75542143bi__les
bindles104016453bindles
birkies133712433birkies
birles84920643bi_rles
brickle15279933brickle_
bricoles122610303bricoles
buckle144815193buckle_
buckled164411883buckled
buckler154112033buckler
bucklers16349503bucklers
buckoes153810393buckoes
cackle143416923cackle_
cackled164613293cackled
cackler153812573cackler
cacklers163710703cacklers
chickees19258513chickees
chicles143512503chic_les
chuckles1936803chuckles
cicalas1139293cicalas
cicale10314503cicale_
cicelies1269753cicelies
circles1139903circles
citoles9312553citoles
clickless1743983clickless
cockle143913573cockle_
cockled163710823cockled
coles76055063__coles
crackles164111273crackles
crinkles14269163crinkles
cycles1339303cyc_les
darkles124011933darkles
deciles104417713deciles
deckels14367363deckels
deckle1312012453deckle_
dibbles124013333dibbles
dices86434243dic__es
dicked144920863dick_ed
dickens144410133dickens
dicker134521403dick_er
dickers144117663dickers
dickey165913523dick_ey
dickeys17479303dickeys
dickie133913113dickie_
dickier143512453dickier
dickiest153412503dickiest
dicks125824693dick__s
diddles103915073diddles
dikes105831333di_k_es
dimples122813213dimples
dindles93817243dindles
dingles93818323dingles
dinkies123716033dinkies
dipoles101013753dipoles
domiciles1445423domiciles
duckies143613813duckies
feckless17225783feckless
fices106031163fic__es
fiches145219533fic_hes
fickly18318533fickl_y
ficoes114613463fic_oes
ficuses12159203ficuses
fiddles123212603fiddles
files85441273fi__les
filles94224523fi_lles
fimbles143510653fimbles
finales104016013finales
fipples14298653fipples
fizzles18339063fizzles
freckles17126383freckles
geckoes14325793geckoes
giggles103312933giggles
girdles92210003girdles
grackles15309183grackles
hackees165014103hackees
hackies163418243hackies
hackle154916813hackle_
hackled173312483hackled
hackler163512353hackler
hacklers173710303hacklers
heckle153112093heckle_
heckled17318463heckled
heckler16278573heckler
hecklers17357123hecklers
hickey185011993hick_ey
hickeys19508223hickeys
hickie153812473hickie_
hicks145322173hick__s
higgles123911803higgles
hikes125426983hi_k_es
hirples12149643hirples
hirsles101510073hirsles
huckle153913073huckle_
iceless9219963_iceless
ices66129643_ic__es
icicles1135943_icicles
icker114018443_ick_er
ickers123914183_ickers
ickier12439913_ickier
ickiest133611043_ickiest
icones84616383_icones
idles66720123_i_dles
impales113311763impales
ingles74420873_ingles
inkle94515833_inkle_
inkless11348713_inkless
isles54220563_i_sles
istles62814983_istles
ixtles13217063_ixtles
jacales16310323jacales
jackies202912623jackies
jackleg2135033jackleg
jacklegs2233953jacklegs
jiggles164111433jiggles
jingles153816383jingles
keckle11359423keckle_
keckled13376503keckled
kibbles153510253kibbles
kicked124415943kick_ed
kicker114116183kick_er
kickers124013293kickers
kickier12349053kickier
kickiest13319673kickiest
kicks104420083kick__s
kickups1443503kickups
kikes85122553ki_k_es
kindles123614843kindles
kirtles11309663kirtles
kittles113012493kittles
knuckles1384453knuckles
lichees123512783lichees
liches114724293lic_hes
licked134621563lick_ed
licker125222043lick_er
lickers134118253lickers
licks115325393lick__s
ligules82210913ligules
likes96231903li_k_es
lisles63416283li_sles
littles73212783littles
locales93715093locales
locules92812603locules
luckies133313683luckies
luckless14265893luckless
maces97139963mac__es
maches134827233mac_hes
macks135127603mack__s
macle96127003mac_le_
macled116718113mac_led
maculas113114013maculas
macule104115273macule_
maculed123510053maculed
mailes84329113m_ailes
makes115336853m_ak_es
males75049793m__ales
mangles104021463mangles
mantles94820703mantles
maples104819423m_aples
marbles114516653marbles
measles92412753measles
meddles113213253meddles
meikle1236653meikle_
merles85322763m_erles
mettles94115023mettles
miauled1036663miauled
miauls8178713miaul_s
micas96823053mic__as
mice87442223mic__e_
micell1098193micel_l
micella11106823micella
micelle1178343micelle
miche126219243mic_he_
miched143913393mic_hed
mick126333423mick___
microbes1439403microbes
microns113814783microns
micros104115363mic_ros
mics87435143mic___s
midcults1343223midcults
middies113116153middies
middle103414983middle_
middled123311893middled
middler112712273middler
middlers123410193middlers
midges103516473mi_dges
midleg1038553mi_dleg
midlegs1156323mi_dlegs
midsoles1137763midsoles
miggle104012113miggle_
mike105535283mi_k_e_
miked125020453mi_k_ed
mikveh18132543mi_kveh
mikvehs19111683mi_kvehs
mikvos1554023mi_kvos
milages103114403milages
milds86422053mi__lds
mile66352563mi__le_
miler75733063mi__ler
milers84625163mi__lers
milked134612573milk_ed
milker124814323milk_er
milkers134411613milkers
milkier133411163milkier
milkiest142911083milkiest
milkmen1565213milkmen
milks115020583mi__lks
mille75029133mi_lle_
milled94326173mi_lled
miller84625413mi_ller
millers93621333mi_llers
millet84030743mi_llet
millets94216843mi_llets
mills75435053mi__lls
milos75428013mi__los
mils66045323mi__l_s
milts75430713mi__lts
mimes95732023mi__mes
mimeses1139073mimeses
minces104420803mi_nces
mindless11319443mindless
mines75651953mi__nes
mingle93518783mingle_
mingled113612733mingled
mingler104213833mingler
minglers113011283minglers
minke115421763mink_e_
minks115829273mink__s
minnies93617363minnies
minuses93512703minuses
minutes93513433minutes
minxes154612983mi_nxes
mioses84318853mi_oses
miracles1238333miracles
mirages102213533mirages
mires75640883mi__res
mirexes1636993mirexes
mirker123712693mirk_er
mirkest13309723mirk_est
mirkier13319053mirkier
mirkiest142910253mirkiest
mirks115122143mirk__s
miscalls1239003miscalls
miscites12313783miscites
miscodes13310423miscodes
miscues11312393miscues
misdoes10312493misdoes
mises74740563mi__ses
misfiles133110983misfiles
miskals13369763miskals
miskeep1536403miskeep
miskeeps1644163miskeeps
misknew1633883misknew
misled94719313mi_sled
mislies92922283mislies
mispled12310463mispled
misrules1039383misrules
missels94614813missels
misses85130873mi_sses
missies93423983missies
missiles103015083missiles
misuses93216023misuses
mites75141803mi__tes
mitises9315543mitises
mitoses9312183mitoses
mitres83922073mi_tres
mixes147224403mi__xes
mizzle16279993mizzle_
mizzled18327633mizzled
mobiles112813123mobiles
mocked154716613mock_ed
mocker143315443mock_er
mockers153812943mockers
mocks135023823mock__s
mockups1733343mockups
modules102511003modules
mokes114631033m_ok_es
moles74747923m__oles
morales93619403morales
motiles93317433motiles
mottles93415803mottles
muches134718993muc_hes
mucked153816093muck_ed
mucker143816393muck_er
muckers153612793muckers
muckier153411473muckier
muckiest163210913muckiest
mucks134622643muck__s
mucuses11148513mucuses
muddles112914353muddles
muffles153910443muffles
mules75034293m__ules
mumbles133014433mumbles
muscles11310563muscles
musicales1346703musicales
muskies133614663muskies
mutules9311843mutules
muzzles17299683muzzles
mycele1335853mycele_
mycoses1437723mycoses
myrtles1235733myrtles
neckless14236433neckless
nibbles114011693nibbles
niches114419143nic_hes
nicked135019683nick_ed
nickel123811343nick_el
nickeled15115513nickeled
nicker123818703nick_er
nickers134415093nickers
nicks114920493nick__s
nicols8810243nicol_s
niggles93512203niggles
nipples11319663nipples
oscules938123oscules
pickaxes2344913pickaxes
picked154421313pick_ed
pickeer153710113pickeer
pickeers16347243pickeers
picker144422173pick_er
pickers153718093pickers
picket144924313pick_et
pickets154314183pickets
pickier153912973pickier
pickiest162712593pickiest
picks135226143pick__s
pickups1754253pickups
piculs103511753picul_s
piddles114314273piddles
piffles15368763piffles
pikes115031033pi_k_es
piles74742613pi__les
pilules9510623pilules
pimples133012423pimples
pinkies133818263pinkies
pinkoes135512313pinkoes
pinoles93418703pinoles
pintles94118723pintles
pizzles17329273pizzles
prickle153611013prickle_
prickled17358073prickled
quickies2336773quickies
rackle123917293rackle_
rankles113114543rankles
reckless14257973reckless
rices75536153ric__es
riches115022083ric_hes
ricked136523623rick_ed
rickets134915093rickets
rickey154613973rick_ey
rickeys16548983rickeys
ricks115126133rick__s
riddles93215023riddles
riffles133911163riffles
rifles94217703ri_fles
riles55343643ri__les
rilles64725503ri_lles
rimples113114223rimples
ripples113513293ripples
riskless1235763riskless
rockless14297293rockless
ruckle124414583ruckle_
ruckled144111033ruckled
runkles114111943runkles
scales84529313_scales
shackles173010593shackles
sices75637273sic__es
sickbed16396823sickbed
sickbeds17254213sickbeds
sicked134524403sick_ed
sickee124622223sick_ee
sicken124615253sick_en
sickens134411483sickens
sicker124023903sick_er
sickest131813793sick_est
sickie123715743sickie_
sicklied1546583sicklied
sicklier1457213sicklier
sickliest1547513sickliest
sickly153110483sickl_y
sickness1437833sickness
sickos125112033sick_os
sicks115127623sick__s
sidles74721153si_dles
sikes96236083si_k_es
silkies113715693silkies
similes92915233similes
simples113014943simples
singles83520433singles
sizzles15349633sizzles
smiles84522293smi__les
sockless14267793sockless
socles8418453soc_les
spackles16319943spackles
speckles16268133speckles
spicules12219803spicules
stickies142211973stickies
stickle132410973stickle_
stickled15298973stickled
stickler14259573stickler
sticklers15227383sticklers
strickles1567813strickles
suckle124015963suckle_
suckled144212513suckled
suckler133413093suckler
sucklers14379963sucklers
suckless14288823suckless
tackle123815733tackle_
tackled143913183tackled
tackler134013323tackler
tacklers143010773tacklers
tackless14419483tackless
ticals83214713tical_s
ticked134720523tick_ed
ticker124321503tick_er
tickers133617723tickers
ticket124524853tick_et
tickets134113683tickets
ticklish1755283ticklish
ticks115823293tick__s
tikes95628903ti_k_es
tiles55542103ti__les
tingles83818313tingles
tinkle103714453tinkle_
tinkled123910473tinkled
tinkler113610543tinkler
tinklers12298183tinklers
tipples112811253tipples
titles63719923ti_tles
tittles73413253tittles
trickle133613443trickle_
trickled152610433trickled
truckles14319383truckles
twinkles1535073twinkles
uncles8317163unc_les
viceless1337983viceless
vices105725533vic__es
vichies15310623vichies
vittles103211113vittles
wackes154717713wack_es
wiches144418753wic_hes
wickapes1943703wickapes
wicked164317413wick_ed
wicker154518673wick_er
wickers164114703wickers
wicket155318943wick_et
wickets164010943wickets
wicks144619363wick__s
widdles123514343widdles
wiggles123312463wiggles
wiles85437873wi__les
wimbles143010843wimbles
wimples143311173wimples
windles113518493windles
winkle133812833winkle_
winkled15299593winkled
wintles103414983wintles
wrinkles15296693wrinkles
yikes125117753yi_k_es
zizzles14307093zizzles

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340275388.06316622.5
3Display Results5385380.1862892.5
 (SQL Overall)1786915388.40521260.1
 
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.