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

399 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
button831027(None) 
burton8311271burton
buttons9310331buttons
buttony1236171buttony
mutton8510451mutton
baton75822422b_aton
batten85217122batten
beton76022062b_eton
bettor83612222bettor
bitten84715122bitten
boston8513042boston
bottom1048712bottom
bouton8311532bouton
bunion83111312bunion
burtons9310852burtons
buteo75419892buteo_
buteos84913412buteos
butt65143742butt__
butte74924292butt_e
butted94722062butted
butter84724232butter
buttes84822562buttes
butting103519282butting
buttock1545562buttock
buttoned1137502buttoned
buttoner1036972buttoner
butts75824252butt_s
butty104020112butt_y
cotton8312992cotton
futon83113772fu_ton
glutton844892glutton
jetton1338032jetton
muton73817002mu_ton
muttons949282muttons
muttony1235322muttony
puton73617912pu_ton
putto75617662putto_
ratton64116122ratton
rebutton1043832rebutton
unbutton1042462unbutton
abettor956193abettor
ablution1047223ablution
abutilon1043083abutilon
abuttal954553abuttal
abutted1056983abutted
abutter957513abutter
abutting1137003abutting
action84719683action
attorn6310793_attorn
auction93412933auction
author939763author
auto47432083au_to_
autos56523323au_tos
autumn836013autumn
baboon103613913baboon
bacon95620593b_acon
ballon84117493ballon
baron78131243b_aron
baryon111211613baryon
baryton1246003baryton
basion84315853basion
bastion9312473bastion
batboy1387533batboy
bathos116215633bathos
batman105214063batman
batmen104414303batmen
batons85519423b_atons
batt65053873batt__
batted95623653batted
battens95313263battens
batter84928873batter
battik1238093battik
batting104422273batting
battle85217863battle
batts76727563batt_s
battu75216613batt_u
battue84311003battue
batty105422243batt_y
beacon10511373beacon
beaten84617063beaten
beckon14309383beckon
belon73924113b_elon
benthon1237693benthon
bento75922953bento_
bentos86218303bentos
bestow1149463bestow
betatron1045223betatron
bethorn1238643bethorn
betons84919553b_etons
betony114211583b_etony
betook12439603betook
betta74916843bett_a
bettas84913923bettas
betted94721163betted
better84723703better
betting103921403betting
bettors93312473bettors
bicron103710773bicron
billon83713823billon
biltong1034683biltong
biotin83215823biotin
biotron937293biotron
bison75716983b_ison
bitt65545803bitt__
bitted94418483bitted
bitter84622673bitter
bittern94810683bittern
bitting103717293bitting
bittock1544433bittock
bitts75022593bitt_s
bitty106119173bitt_y
blazon1736763blazon
blotto8198443blotto_
bolson8410683bolson
bonbon10310073bonbon
boon67142173b__oon
boron76727143b_oron
boson76019733b_oson
bostons9312893bostons
bott66548573bott__
bottle84916073bottle
bottoms1136983bottoms
botts75224863bott_s
bourbon1135813bourbon
bourdon1036423bourdon
boutons9310783boutons
bubo85621903bu_bo_
bucko134614023bucko_
buckos143710893buckos
buffo135112183buffo_
buffoon1543713buffoon
buffos14447853buffos
bullion91911033bullion
bumkin14308083bumkin
bun56348143bu___n
bunco94616083bunco_
buncos104011593buncos
bunions92210473bunions
bunko115514513bunko_
bunkos124210323bunkos
bunn65023653bu__nn
bunt65850853bunt__
bunted95219183bunted
bunter85020383bunter
bunting103718833bunting
bunts75729803bunt_s
buoy95921783bu__oy
buran75225303bu_ran
burbot10815653burbot
burden9412473burden
burgeon1036433burgeon
burgoo938933burgoo
burin75626063bu_rin
burn65636423bu__rn
burro75018493burro_
burros85114993burros
burrow114610803burrow
burstone1057133burstone
burthen1236363burthen
busboy13307443busboy
buskin123811493buskin
busman10310253busman
busmen1039893busmen
bust65947783bust__
busted95123153busted
buster84726493buster
bustic101012693bustic
busting104221793busting
bustle84015483bustle
busts75227693bust_s
busty105621013bust_y
but55963023bu_t__
butane8313653butane
butanol945433butanol
butanone1044963butanone
butch125416543bu_tch
bute66739673bu_t_e
butene8312623butene
butes714535873bu_tes
butle75023103bu_tle
butled94818603butled
butler84220033butler
butles84423913butles
butling103516813butling
buts67247693bu_t_s
buttals938503buttals
butters94521713butters
buttery124311193buttery
butties93217953butties
buttocks1645233buttocks
buttoners1145703buttoners
buttoning1246463buttoning
butut75522913bu_tut
bututs8409423bututs
butyl1089103bu_tyl
butyls1176753butyls
butyrin1245813butyrin
buxom1647153bu_xom
canton85722993canton
carton84522663carton
cation83925503cation
caution93013513caution
chiton112612393chiton
citron83112983citron
cottons9312193cottons
cottony1237253cottony
craton84517193craton
croton84415453croton
custom104010273custom
custos84014313custos
cutdown1344083cutdown
cutin75022773cu_tin
cutter84520993cutter
cutting103817493cutting
cuttle84113893cuttle
cutty105417223cutt_y
cyton101511463_cyton
dalton7311273dalton
datto65416423datto_
dattos74311903dattos
ditto65315603ditto_
dittos74111973dittos
duotone836893duotone
durion7510963durion
elution72913823elution
fatten94314903fatten
fusion939773fusion
futons93911513fu_tons
futtock1644153futtock
gittin72910553gittin
gluttons944273gluttons
gluttony1242513gluttony
gotten73410113gotten
grutten885283grutten
guenon736403guenon
guidon837373guidon
gusto65414643gusto_
gutta64613383gutt_a
guttae73210583guttae
gutted84716363gutted
gutter73817703gutter
gutting93415923gutting
guttle74111973guttle
gutty94516993gutt_y
hutted104616333hutted
hutting113016033hutting
intron64215023intron
jeton124815403_jeton
jettons1437273jettons
junto125114563junto_
juntos134110843juntos
jupon14479193ju_pon
jutted144315023jutted
jutting153313713jutting
jutty154914643jutt_y
kation104315683kation
keybutton185993keybutton
kitten104611483kitten
latten65018203latten
lattin64316223lattin
lepton82510793lepton
litten64014873litten
lotion65716523lotion
lotto55217573lotto_
lottos64613103lottos
lutein6311263lutein
matron83918313matron
mattin84416633mattin
melton8311553melton
misbutton1352313misbutton
mitten83914093mitten
motion85217553motion
motto76119513motto_
mottos84615243mottos
mouton8410853mouton
multiton1087343multiton
muntin82915183muntin
muon65722733mu__on
mutation101412883mutation
mutons84314363mu_tons
mutt65739403mutt__
mutter84418883mutter
mutts75120253mutt_s
nation64322803nation
natron64116023natron
nekton1036583nekton
neuston736083neuston
neutron737763neutron
newton936983newton
niton55418283_niton
notion64516583notion
nutation81513103nutation
nutted74316973nutted
nutter63918053nutter
nutting83316233nutting
nutty84816873nutt_y
option83612713option
otto45220643_otto_
ottos54714323_ottos
outbox1537453outbox
outdo6312703outdo_
outdone8311643outdone
outfox1636133outfox
outgo6312093outgo_
outgone8311463outgone
outgun7349643outgun
outman83115033outman
outran63218883outran
outrow9311173outrow
outrun63213293outrun
outsin63617553outsin
outtold8107603outtold
outtrot7312613outtrot
outturn737123outturn
outworn101610753outworn
parton84720993parton
patron84018043patron
patten84418193patten
petto76021043petto_
photon1111514823photon
phyton143610253phyton
piston83515923piston
piton76121583_piton
pluton838853pluton
ponton83217643ponton
potion84519573potion
potto75320943potto_
pottos84615873pottos
proton84318893proton
punto75121323punto_
puntos85915793puntos
putdown1343883putdown
putlog965553putlog
putons83515153pu_tons
putt66937843putt__
putted94220253putted
puttee85919723puttee
putter83921443putter
putti76018743putt_i
puttie84116303puttie
putting103218573putting
putts75719273putt_s
putty104721403putt_y
python1447143python
quittor16285603quittor
ration64226013ration
ratoon64417373ratoon
rattan63613603rattan
ratten64217383ratten
rattons73815323rattons
rattoon7359243rattoon
rebuttons1143503rebuttons
rhyton12356113rhyton
rotten64115433rotten
ruction93611613ruction
rutin55421343ru_tin
rutted74518403rutted
rutting82718043rutting
rutty85617803rutt_y
seton55223543_seton
sexton133610793sexton
sitten64113823sitten
subtone9310343subtone
suction93713043suction
suitor63311053suitor
sultan63012593sultan
summon1037623summon
suntan62613003suntan
sutta54015333sutt_a
suttas63813793suttas
suttee63721543suttee
tattoo6310973tattoo
teston6313303teston
ton310265103___ton
toon47740633__toon
triton63914893triton
tuition738823tuition
turion6313163turion
turnon638193turnon
tutor5712493tu_tor
tutted75117443tutted
tutti54614673tutt_i
tutting83515913tutting
tuttis63611373tuttis
tutty85217023tutt_y
udon56017743_u_don
unbuttons1142133unbuttons
union54519793_union
unto45824283_unto_
untorn63012343_untorn
unwon84512343_unwon
upon65817583_u_pon
uptorn8268093_uptorn
uptown11274963_uptown
utter54218763_utter
wanton94413813wanton
wittol935923wittol
wonton93410963wonton
yupon10469483yu_pon

Search took 10 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163998.70312951.4
3Display Results3993990.3261223.9
 (SQL Overall)1786913999.16919488.6
 
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.