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

350 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
buttons931033(None) 
burtons9310851burtons
button8310271button_
buttony1236171buttony
muttons949281muttons
batons85519422b_atons
battens95313262battens
betons84919552b_etons
bettors93312472bettors
bostons9312902bostons
bottoms1136992bottoms
boutons9310782boutons
bunions92210472bunions
burton8311272burton_
buteos84913412buteo_s
buttals938502buttals
butters94521722butters
buttes84822562butt_es
butties93217952butties
butting103519282butting
buttock1545562buttock
buttocks1645232buttocks
buttoned1137502buttoned
buttoner1036972buttoner
buttoners1145702buttoners
butts75824252butt__s
cottons9312192cottons
futons93911512fu_tons
gluttons944272gluttons
jettons1437272jettons
mutons84314362mu_tons
mutton8510452mutton_
muttony1235322muttony
putons83515152pu_tons
rattons73815322rattons
rebuttons1143502rebuttons
unbuttons1142132unbuttons
abettors1056133abettors
ablutions1146593ablutions
abutilons1142963abutilons
abuttals1043923abuttals
abutters1056993abutters
abutting1137003abutting
actions94218513actions
attorns738443_attorns
auctions104012143auctions
authors10311853authors
autos56523323au_to_s
autumns943763autumns
baboons113211073baboons
bacons104917583b_acons
ballons93916963ballons
barons85025383b_arons
baryons121010473baryons
barytons1345573barytons
basions94213953basions
bastions10411693bastions
batboys1465833batboys
bathos116215633batho_s
baton75822423b_aton_
batten85217123batten_
batters94626013batters
battiks1337143battiks
batting104422273batting
battings114010573battings
battles94517683battles
batts76727563batt__s
battues94610193battues
baudrons1135763baudrons
beacons11410733beacons
beckons15279143beckons
belons84119413b_elons
benthons1337973benthons
bentos86218303bento_s
bestows1248863bestows
betatrons1145083betatrons
bethorns1337323bethorns
beton76022063b_eton_
betony114211583b_etony
bettas84913923bett_as
betters94422093betters
betting103921403betting
bettor83612223betto_r
bicrons113410473bicrons
billons93013363billons
biltong1034683biltong
biltongs1133813biltongs
biotins93114453biotins
biotrons1037233biotrons
bisons83914373b_isons
bitten84715123bitten_
bitterns10428953bitterns
bitters94920363bitters
bitting103717293bitting
bittings11339293bittings
bittock1544433bittock
bittocks1644443bittocks
bitts75022593bitt__s
blazons1836163blazons
bolsons969483bolsons
bonbons1139333bonbons
boons75031913b__oons
borons85520543b_orons
bosons85016653b_osons
boston8513043boston_
bottles94216273bottles
bottom1048723botto_m
botts75224863bott__s
bourbons1245343bourbons
bourdons1136433bourdons
bouton8311533bouton_
buboes104513993bu_boes
buckoes153810393buckoes
buckos143710893bucko_s
buffoons1643093buffoons
buffos14447853buffo_s
bugloss1035893bugloss
bulbous1138293bulbous
bullions101710043bullions
bullous9311663bullous
bumkins15318013bumkins
buncos104011593bunco_s
bunion83111313bunion_
bunkos124210323bunko_s
bunns74718293bu__nns
buns66243723bu___ns
bunters94717123bunters
bunting103718833bunting
buntings11348773buntings
bunts75729803bunt__s
buoys104810633bu__oys
burans85019303bu_rans
burbots1168673burbots
burdens1039713burdens
burgeons1146053burgeons
burgoos1037123burgoos
burins84221893bu_rins
burnous938823burnous
burns74926773bu__rns
burros85114993burro_s
burrows12399093burrows
burstone1057133burstone
burstones1187153burstones
burthens1335383burthens
busboys14325023busboys
buskins133310943buskins
busters94724133busters
bustics11810883bustics
busting104221793busting
bustles93816323bustles
busts75227693bust__s
butane8313653bu_tane
butanes9312743butanes
butanol945433butanol
butanols1044713butanols
butanone1044963butanone
butanones1144713butanones
butches144315363butches
butene8312623bu_tene
butenes9313033butenes
buteo75419893buteo__
butes714535873bu_t_es
butlers94518053butlers
butles84423913bu_tles
butling103516813butling
buts67247693bu_t__s
butt65143743butt___
butte74924293butt__e
butted94722063butt_ed
butter84724233butt_er
buttery124311193buttery
buttinski1551233buttinski
buttinsky1841133buttinsky
buttonbush1751563buttonbush
buttoning1246463buttoning
buttonless1242963buttonless
buttress1035883buttress
butty104020113butt__y
bututs8409423bu_tuts
butyls1176753bu_tyls
butyrins1345423butyrins
butyrous1345443butyrous
cantons95221203cantons
cartons94122473cartons
cations94524143cations
cautions103313183cautions
chitons122611913chitons
citrons92913223citrons
cotton8312993cotton_
cottony1237253cottony
cratons94316033cratons
crotons93714373crotons
customs11348263customs
custos84014313custo_s
cutdowns1443343cutdowns
cutins83919983cu_tins
cutters94218963cutters
cutties93118843cutties
cutting103817493cutting
cuttings11277613cuttings
cuttles93613923cuttles
cytons111710183_cytons
daltons8310403daltons
dattos74311903datto_s
dittos74111973ditto_s
duotone836893duotone
duotones937643duotones
durions839963durions
duteous838453duteous
elutions82513053elutions
fattens105111713fattens
fusions1039153fusions
futon83113773fu_ton_
futtock1644153futtock
futtocks1743833futtocks
glutton844893glutton_
gluttony1242513gluttony
guenons836563guenons
guidons936623guidons
gustoes879873gustoes
gutters83715513gutters
gutting93415923gutting
guttles83011933guttles
hutting113016033hutting
introns73515023introns
jetons134512613_jetons
jetton1338033jetton_
juntos134110843junto_s
jupons15377803ju_pons
jutties143814003jutties
jutting153313713jutting
kations114013663kations
keybuttons195933keybuttons
kittens11347583kittens
lattens75014673lattens
lattins74115483lattins
leptons91910423leptons
lotions74614763lotions
lottos64613103lotto_s
luteins7310103luteins
luteous739273luteous
matrons93517633matrons
mattins93316143mattins
meltons9410923meltons
misbuttons1452113misbuttons
mittens9349883mittens
motions94215003motions
mottoes93412193mottoes
mottos84615243motto_s
moutons9410313moutons
muntins92715133muntins
muons75816173mu__ons
mutations111211453mutations
muton73817003mu_ton_
mutters94117143mutters
mutts75120253mutt__s
nations74720563nations
natrons73215663natrons
nektons1136393nektons
neustons836833neustons
neutrons838293neutrons
newtons1036813newtons
nitons64614903_nitons
notions74014483notions
nutations91411763nutations
nutters74215433nutters
nutting83316233nutting
nuttings9276783nuttings
options93810603options
ottos54714323_otto_s
outdoes8313123outdoes
outdone8311643outdone
outgoes8312643outgoes
outgone8311463outgone
outguns8318693outguns
outmans92413283outmans
outrows10311403outrows
outruns72911543outruns
outsins73417863outsins
outtold8107603outtold
outtrots838373outtrots
outturns835913outturns
partons94620513partons
patrons93818103patrons
pattens95414923pattens
photons123814433photons
phytons15319063phytons
pistons93016373pistons
pitons85319043_pitons
plutons938343plutons
pontons93315553pontons
potions93417423potions
pottos84615873potto_s
protons93118003protons
puntos85915793punto_s
putdowns1443523putdowns
putlogs1065083putlogs
puton73617913pu_ton_
puttees93612913puttees
putters94219193putters
putties94420023putties
putting103218573putting
putto75617663putto__
putts75719273putt__s
pythons1537363pythons
quittors17155413quittors
rations74123433rations
ratoons73815473ratoons
rattans73411953rattans
rattens74213403rattens
ratton64116123ratton_
rattoons8327513rattoons
rebutton1043833rebutton_
rhytons13295883rhytons
ructions102811683ructions
rutins63818393ru_tins
rutting82718043rutting
setons64620173_setons
sextons143710413sextons
subtone9310343subtone
subtones10311383subtones
suctions103012903suctions
suitors73012493suitors
sultans72411833sultans
summons1158003summons
suntans72111733suntans
suttas63813793sutt_as
suttees74114063suttees
tattoos738643tattoos
testons7313553testons
tons46553053___tons
toons55027533__toons
tritons73814883tritons
tuitions838283tuitions
turions7311573turions
turnons737863turnons
tutors6912333tu_tors
tutties73216473tutties
tutting83515913tutting
tuttis63611373tutt_is
udons65411463_u_dons
unbutton1042463unbutton_
unions64216753_unions
uptoss836093_uptoss
uptowns12194343_uptowns
utters63817123_utters
wantons103713013wantons
wittols1035733wittols
wontons103310533wontons
yupons11398353yu_pons

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.1561145455.1
2DLD Change Limit1340273506.25021444.3
3Display Results3503500.1262777.8
 (SQL Overall)1786913506.53227356.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.