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

435 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
burtons931085(None) 
burton8311271burton_
buttons9310331buttons
barons85025382bar_ons
baryons121010472baryons
barytons1345572barytons
batons85519422b_atons
betons84919552b_etons
borons85520542bor_ons
bostons9312902bostons
bourbons1245342bourbons
bourdons1136432bourdons
boutons9310782boutons
bunions92210472bunions
burans85019302bur_ans
burbots1168672burbots
burdens1039712burdens
burgeons1146052burgeons
burgoos1037122burgoos
burins84221892bur_ins
burnous938822burnous
burns74926772bur__ns
burros85114992burro_s
burrows12399092burrows
burstone1057132burstone
burstones1187152burstones
burthens1335382burthens
button8310272button_
buttony1236172buttony
cartons94122472cartons
durions839962durions
futons93911512fu_tons
mutons84314362mu_tons
muttons949282muttons
partons94620512partons
putons83515152pu_tons
turions7311572turions
turnons737862turnons
abortions1147783abortions
aprons8316993apr_ons
argons75018203_argons
arsons63917213_arsons
auctions104012143auctions
aurous64119263aur_ous
autos56523323au_to_s
baboons113211073baboons
bacons104917583b_acons
ballons93916963ballons
barhops14288113barhops
baritone1058643baritone
baritones1158943baritones
barlows12259973barlows
barns76335143bar__ns
baron78131243bar_on_
barong96015823bar_ong
barongs105310833bar_ongs
barony115915303bar_ony
barrens94414323barrens
barrows123411683barrows
bartend1038753bartend
bartends1136793bartends
barters94223033barters
baryon111211613baryon_
baryton1246003baryton_
barytone1356023barytone
barytones1455563barytones
basions94213953basions
bastions10411693bastions
baton75822423b_aton_
battens95313263battens
baudrons1135763baudrons
beacons11410733beacons
beckons15279143beckons
belons84119413b_elons
benthons1337973benthons
bentos86218303bento_s
berlins93216013berlins
berthas12398763berthas
berths114712423bert_hs
bestows1248863bestows
beton76022063b_eton_
betony114211583b_etony
bettors93312473bettors
bicrons113410473bicrons
billons93013363billons
biltong1034683biltong
biltongs1133813biltongs
biotins93114453biotins
biotrons1037233biotrons
biros75325133bir_o_s
births115713603birt_hs
bisons83914373b_isons
blazons1836163blazons
blurters10348373blurters
blurting11258773blurting
blurts84412643blurt__s
bolsons969483bolsons
bonbons1139333bonbons
boons75031913b__oons
boreens9310403boreens
boron76727143bor_on_
borrows12349253borrows
borts76735453bort__s
bortzes1838223bortzes
borzois1835833borzois
bosons85016653b_osons
boston8513043boston_
bottoms1136993bottoms
bourbon1135813bourbon_
bourdon1036423bourdon_
bourgeons1244393bourgeons
bourns84114063bour__ns
boursins1037513boursins
bouton8311533bouton_
brains85125473b_rains
brans75437433b_r_ans
brawns115614083b_rawns
brens75823363b_r_ens
brins75533973b_r_ins
briony1149043b_riony
brios74725723b_rio_s
bronc91714343b_r_onc
broncs101611153b_r_oncs
broods95416383b_roods
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b_r_oos
bros65635663b_r_o_s
broths115013923b_roths
browns116415633b_rowns
brows105425983b_r_ows
brucins1158003brucins
bruins86014953b_ruins
brulots946223brulots
brumous11107443brumous
brutes86118683brut_es
bruting102612993bruting
bruts75922953brut__s
bryony1435833b_ryony
buboes104513993bu_boes
buckoes153810393buckoes
buckos143710893bucko_s
buffoons1643093buffoons
buffos14447853buffo_s
bugloss1035893bugloss
buhrstone14103153buhrstone
buhrstones1592933buhrstones
bulbous1138293bulbous
bullions101710043bullions
bullous9311663bullous
bumkins15318013bumkins
buncos104011593bunco_s
bunion83111313bunion_
bunkos124210323bunko_s
bunns74718293bu__nns
buns66243723bu___ns
bunters94717123bunters
bunting103718833bunting
buntings11348773buntings
bunts75729803bunt__s
buoys104810633bu__oys
buran75225303bur_an_
buras74736293bur__as
burbles114916803burbles
burbot10815653burbo_t
burbs95423493bur__bs
burden9412473burden_
burdies104117563burdies
burdock1644603burdock
burdocks1744033burdocks
burds84626063bur__ds
bureaus979293bureaus
burets84321263bur_ets
burettes1048953burettes
burgees104915893burgees
burgeon1036433burgeon_
burgers103918573burgers
burgess10409343burgess
burghs12519923bur_ghs
burgles105615963burgles
burgonet1148103burgonet
burgonets1243513burgonets
burgoo938933burgo_o
burgout1049773burgout
burgouts1145123burgouts
burgs84924093bur__gs
burials93612083burials
buriers94017193buriers
buries84633273bur_ies
burin75626063bur_in_
burkas124513803bur_kas
burkers133716623burkers
burkes124421313bur_kes
burking143716323burking
burlaps1156253burlaps
burlers94120273burlers
burleys12479673burleys
burling104421133burling
burls74228853bur__ls
burn65636423bur__n_
burners94115673burners
burnets93813263burnets
burnies94017823burnies
burning104215503burning
burnings11387623burnings
burnoose1043313burnoose
burnout9310453burnout
burnouts1045263burnouts
burnt75230323bur__nt
burping124012943burping
burps94220173bur__ps
burqas174410903bur_qas
burrers93814493burrers
burring104016993burring
burritos1044473burrito_s
burro75018493burro__
burrow114610803burro_w
burrs74925653bur__rs
burrstone1183993burrstone
burrstones12113833burrstones
burs65847423bur___s
bursars94510893bursars
bursas85318273bur_sas
burses84425513bur_ses
bursters1038983bursters
bursting1138703bursting
bursts85116243bur_sts
burthen1236363burthen
burying133413913burying
busboys14325023busboys
buskins133310943buskins
busters94724133busters
bustics11810883bustics
busting104221793busting
bustles93816323bustles
busts75227693bust__s
butane8313653bu_tane
butanes9312743bu_tanes
butene8312623bu_tene
butenes9313033bu_tenes
buteos84913413bu_teos
butes714535873bu_t_es
butles84423913bu_tles
buts67247693bu_t__s
buttals938503buttals
butters94521723butters
buttes84822563bu_ttes
butties93217953butties
butting103519283butting
buttock1545563buttock
buttocks1645233buttocks
buttoned1137503buttoned
buttoner1036973buttoner
buttoners1145703buttoners
butts75824253bu_t_ts
bututs8409423bu_tuts
butyls1176753bu_tyls
cantons95221203cantons
carbons115418943carbons
cardons104519933cardons
carton84522663carton_
cartoons104012803cartoons
chitons122611913chitons
citrons92913223citrons
cordons104415763cordons
cortins92421333cortins
cottons9312193cottons
cratons94316033cratons
croons85418423_croons
crotons93714373crotons
curators10311723curators
curios83218333curio_s
curious93813563curious
curns74924273cur__ns
currans9310613currans
cursors93910023cursors
curtains10259703curtains
curtals93111623curtals
customs11348263customs
custos84014313custo_s
cutins83919983cu_tins
cytons111710183_cytons
daltons8310403daltons
diurons838823diur_ons
duotone836893duotone
duotones937643duotones
durations10311463durations
durians839573durians
durion7510963durion_
durns64819863dur__ns
durocs9569703dur_ocs
duros65422693dur_o_s
euros54920243eur_o_s
fourgons1234833fourgons
frons86124043_fr_ons
furans94515953fur_ans
furious103110633furious
furlong11295413furlong
furlongs12304073furlongs
furors9310953fur_ors
furrows13327793furrows
fusions1039153fusions
futon83113773fu_ton_
garcons102411643garcons
garrons82713463garrons
girons75014373gir_ons
gluttons944273gluttons
gorgons938853gorgons
guenons836563guenons
guerdons1044233guerdons
guidons936623guidons
gustoes879873gustoes
gyrons105511223gyr_ons
herons94820543her_ons
hurters103413643hurters
hurting113914033hurting
hurtles103913753hurtles
hurts86922823hurt__s
introns73515023introns
irons55324133_ir_ons
jargons1558203jargons
jetons134512613_jetons
jettons1437273jettons
juntos134110843junto_s
jupons15377803ju_pons
jurors1338283jur_ors
kroons103711243_kroons
kurgans12145653kurgans
kurtas10349883kurt_as
kurtoses12105623kurtoses
kurtosis1294403kurtosis
lardons83914493lardons
leptons91910423leptons
lurdans837073lurdans
maroons92615553maroons
marrons93216973marrons
martens93714953martens
martins93322063martins
matrons93517633matrons
meltons9410923meltons
merlons93311273merlons
morions94014643morions
morons84919543mor_ons
moutons9410313moutons
muntins92715133muntins
muons75816173mu__ons
mureins9310733mureins
muton73817003mu_ton_
mutton8510453mutton_
muttony1235323muttony
natrons73215663natrons
nektons1136393nektons
neurons7410443neur_ons
neustons836833neustons
neutrons838293neutrons
newtons1036813newtons
nitons64614903_nitons
orlons6411013_orlons
outrows10311403outrows
outruns72911543outruns
pardons103817623pardons
parsons93516873parsons
partans94418283partans
parton84720993parton_
patrons93818103patrons
pereons92815003pereons
perrons93115483perrons
persons93717013persons
photons123814433photons
phytons15319063phytons
pistons93016373pistons
pitons85319043_pitons
plutons938343plutons
pontons93315553pontons
portions10514413portions
prions84317783_prions
protons93118003protons
puntos85915793punto_s
purins83722653pur_ins
puritans1037633puritans
purlins93415423purlins
purloins1077033purloins
puton73617913pu_ton_
quartans1736283quartans
quartos16328733quarto_s
rattons73815323rattons
rebuttons1143503rebuttons
rhytons13295883rhytons
ructions102811683ructions
rutins63818393ru_tins
sartors7314963sartors
sermons9311783sermons
setons64620173_setons
sextons143710413sextons
subtone9310343subtone
subtones10311383subtones
suctions103012903suctions
suitors73012493suitors
sultans72411833sultans
summons1158003summons
suntans72111733suntans
surgeons947033surgeons
surtout7411673surtout
surtouts846203surtouts
tarpons92612203tarpons
tartans72615823tartans
testons7313553testons
tons46553053___tons
tortoni738033tortoni
tortonis848743tortonis
tritons73814883tritons
tuitions838283tuitions
turbans939563turbans
turbos8910783turbo_s
turbots988023turbots
tureens7289873tureens
turgors836833turgors
turion6313163turion_
turkois1135133turkois
turnon638193turnon_
turns55623233tur__ns
turtles72914343turtles
tutors6912333tu_tors
udons65411463_u_dons
unbuttons1142133unbuttons
unions64216753_unions
uptoss836093_uptoss
uptowns12194343_uptowns
urns46323893_ur__ns
virions1039873virions
wantons103713013wantons
wontons103310533wontons
yupons11398353yu_pons
yurts87216533yurt__s
zircons1854963zircons

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 Limit1340274356.17021722.4
3Display Results4354350.1602718.8
 (SQL Overall)1786914356.48627550.3
 
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.