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

494 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
nickles13371382(None) 
mickles153415001mickles
nickels13338651nickels
nickle123814481nickle_
nickled144010441nickled
pickles153215441pickles
sickles133417541sickles
tickles133416851tickles
brickles162810282brickles
buckles153416092buckles
cackles153717202cackles
cockles153414642cockles
deckles143312802deckles
dickies143416342dickies
fickle153912972fickle_
fickler16348422fickler
ficklest17267902ficklest
hackles162917062hackles
heckles163711382heckles
hickies163614742hickies
huckles163612622huckles
inkles103515652_inkles
keckles12318762keckles
knuckles1384452knuckles
mackles154415752mackles
mickle143715132mickle_
mickler153310232mickler
micklest16219122micklest
muckles153413252muckles
neckless14236432neckless
nibbles114011692nibbles
niches114419142nic_hes
nicked135019682nick_ed
nickel123811342nick_el
nickeled15115512nickeled
nicker123818702nick_er
nickers134415092nickers
nicks114920492nick__s
nicols8810242nicol_s
niggles93512202niggles
nipples11319662nipples
pickle144215652pickle_
pickled164011882pickled
prickles162511092prickles
ruckles133414602ruckles
sickees134514212sickees
sickies133717502sickies
sickle124418322sickle_
sickled144713432sickled
sicklies14710012sicklies
stickles142512102stickles
suckles134516742suckles
tackles133816522tackles
tickle124616742tickle_
tickled144313132tickled
tickler133612652tickler
ticklers14339302ticklers
tinkles113713922tinkles
trickles143013762trickles
wickless1736082wickless
winkles143412772winkles
ackees124914573_ackees
aisles64721143ai_sles
anisoles81010123anisoles
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
cicalas1139303cicalas
cicale10314503cicale_
cicelies1269753cicelies
circles1139903circles
citoles9312553citoles
clickless1743983clickless
cockle143913573cockle_
cockled163710823cockled
coles76055063__coles
crackles164111273crackles
crinkles14269163crinkles
cycles1339303cyc_les
darkles124011933darkles
deciles104417723deciles
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
duckies143613813duckies
enisles72312603eni_sles
feckless17225783feckless
fices106031163fic__es
fiches145219533fic_hes
fickly18318533fickl_y
ficoes114613463fic_oes
ficuses12159203ficuses
fiddles123212603fiddles
files85441273fi__les
filles94224523fi_lles
fimbles143510663fimbles
finales104016013finales
fipples14298653fipples
fizzles18339063fizzles
freckles17126383freckles
funicles13246833funic_les
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
ickier12439923_ickier
ickiest133611043_ickiest
icones84616383_icones
idles66720123_i_dles
incages103013883incages
incases93615973incases
inches114419673inc_hes
incises93414893incises
incites93218483incites
incomes11712373incomes
incudes10319523incudes
incuses93514853incuses
indoles83716363indoles
ingles74420873_ingles
inhales10511863inhales
inkle94515833_inkle_
inkless11348713_inkless
insoles73516243insoles
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
knickers13306723knickers
knockless1442443knockless
knuckle1254233knuckle_
knuckled1463563knuckled
knuckler1383623knuckler
knucklers1483043knucklers
lichees123512783lichees
liches114724293lic_hes
licked134621563lick_ed
licker125222043lick_er
lickers134118253lickers
licks115325393lick__s
ligules82210923ligules
likes96231903li_k_es
lisles63416283li_sles
littles73212783littles
locales93715093locales
locules92812603locules
luckies133313683luckies
luckless14265893luckless
mackle143716433mackle_
mackled164111913mackled
macles107023223mac_les
macules114015133macules
micelles1288833micelles
micells11107683micells
miches134320733mic_hes
mickey174211853mick_ey
mickeys18447943mickeys
micks135525373mick__s
middles113415303middles
miggles113512033miggles
mikes115129893mi_k_es
miles74645073mi__les
milkless1434773milkless
milles84526563mi_lles
mingles103719003mingles
minkes124618783mink_es
mizzles17329493mizzles
muckle143413583muckle_
myceles1435213myceles
nacelles1048393nacelles
naches114622413nac_hes
nacres85614453nac_res
necked134715063neck_ed
necker124012793neck_er
neckers134210463neckers
necklaces1743513necklaces
necklines15115723necklines
necks115119333neck__s
neckties1445903neckties
needles83211563needles
nestles73015463nestles
nettles73214083nettles
nibble103713283nibble_
nibbled12389073nibbled
nibbler11379273nibbler
nibblers12306543nibblers
nicads938333nic_ads
nice65534713nic__e_
nicely1139493nicel_y
niceness1039843niceness
nicer74618293nic__er
nicest82315663nic__est
niceties10310863niceties
niche105016793nic_he_
niched125514063nic_hed
nick106627603nick___
nickelic1643273nickelic
nickelled1653793nickelled
nickelous1553413nickelous
nickered15117023nickered
nicking143516323nicking
nickling15278703nickling
nicknames1742753nicknames
nicoise937923nicoise
nicol71113293nicol__
nictates1039593nictates
nidates8311893nidates
nides65229133ni__des
niduses837013niduses
nieces84112713ni_eces
niellos736143niellos
nieves94311293ni_eves
nifties102612503nifties
niggle83612823niggle_
niggled10319203niggled
niggler93610293niggler
nigglers10307253nigglers
nihils937573nihil_s
nilled73919453ni_lled
nills54926673ni__lls
nils46132453ni__l_s
nimble103412943nimble_
nimbler11358063nimbler
nimblest1236923nimblest
nines55937343ni__nes
ninnies73713613ninnies
nipple103410373nipple_
nippled12307643nippled
nitchies1339073nitchies
nites55736343ni__tes
nitres65519333ni_tres
nitriles8269923nitriles
nixes124519623ni__xes
nixies135313873ni_xies
nobbles114014523nobbles
nobles83319723n_obles
nocked134617383nock_ed
nocks115121013nock__s
noctules1036583noctules
noddles92911293noddles
nodules8269703nodules
nombles113212343nombles
noodles83513193noodles
nookies113414963nookies
nopales93812523nopales
nozzles15276303nozzles
nubbles113412433nubbles
nuclei857723nuc_lei
nucleus956573nuc_leus
nukes95418123n_uk_es
numbles113814273numbles
nuncles939843nuncles
nuzzles15298123nuzzles
oscules938123oscules
panicles121010113panic_les
penuckles1743243penuckles
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
sanicles10149943sanic_les
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
snicked143811633snick_ed
snicker133012673snick_er
snickers143010963snickers
snicks124312473snick__s
sniffles14257713sniffles
sniggles10307313sniggles
sockless14267793sockless
socles8418453soc_les
spackles16319943spackles
speckles16268133speckles
spicules12219803spicules
stickies142211973stickies
stickle132410973stickle_
stickled15298973stickled
stickler14259573stickler
sticklers15227393sticklers
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
tingles83818323tingles
tinkle103714453tinkle_
tinkled123910473tinkled
tinkler113610543tinkler
tinklers12298183tinklers
tipples112811253tipples
titles63719923ti_tles
tittles73413253tittles
trickle133613443trickle_
trickled152610433trickled
truckles14319383truckles
tunicles10217133tunic_les
twinkles1535073twinkles
unbuckles1743193unbuckles
uncles8317163unc_les
unicycles16143263unicycles
viceless1337983viceless
vices105725533vic__es
vichies15310623vichies
vittles103211113vittles
wackes154717713wack_es
wiches144418753wic_hes
wickapes1943703wickapes
wicked164317413wick_ed
wicker154518673wick_er
wickers164114703wickers
wicket155318943wick_et
wickets164010943wickets
wicks144619363wick__s
widdles123514343widdles
wiggles123312463wiggles
wiles85437873wi__les
wimbles143010853wimbles
wimples143311173wimples
windles113518493windles
winkle133812833winkle_
winkled15299593winkled
wintles103414983wintles
wrinkles15296693wrinkles
yikes125117753yi_k_es
zizzles14307093zizzles

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.1561145455.1
2DLD Change Limit1340274947.37618170.7
3Display Results4944940.1862655.9
 (SQL Overall)1786914947.71823152.5
 
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.