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

224 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
newtons103681(None) 
nektons1136391nektons
newton936981newton_
betons84919552be_tons
jetons134512612je_tons
jettons1437272jettons
leptons91910432leptons
meltons9410922meltons
neatens73310402neatens
negatons9299272negatons
nekton1036582nekton_
nelsons738002nelsons
neocons936912neocons
neons55818682ne__ons
nestors73614972nestors
netops839212ne_tops
neurons7410442neurons
neustons836832neustons
neutrons838292neutrons
newborns1343402newborns
newts86015282newt__s
nitons64614902n_itons
setons64620172se_tons
sextons143710412sextons
testons7313562testons
aeons57624653ae__ons
batons85519423_batons
beacons11410733beacons
beckons15279143beckons
belons84119413be_lons
benthons1337973benthons
bentos86218303bento_s
bestows1248863bestows
beton76022063be_ton_
betony114211583be_tony
bettors93312473bettors
bostons9312903bostons
boutons9310783boutons
burtons9310853burtons
buttons9310333buttons
cantons95221203cantons
cartons94122473cartons
centones10313663centones
centos85920463cento_s
cestos84718093cesto_s
chitons122611913chitons
cottons9312193cottons
cratons94316033cratons
crotons93714373crotons
cytons111710183_cytons
daltons8310403daltons
deacons10310393deacons
debtors1038533debtors
demetons1137623demetons
demons94917723de_mons
dentins83419223dentins
devons104512253de_vons
dewans105215143dew_ans
dewools1145593dewools
ebons74316093_e_bons
eikons1038503_eikons
enations83316903enations
eons46638713_e__ons
estops84011223_estops
exons125813343_e_xons
extols1337683_extols
felons93615763fe_lons
festoons1136443festoons
fetors91014473fe_tors
futons93911513_futons
gentoos838633gentoos
hectors123513263hectors
herons94820543he_rons
jeton124815403je_ton_
jetton1338033jetton_
kelsons1137323kelsons
ketols104210763ke_tols
ketone105014533ke_tone
ketones115014503ke_tones
kowtows1742763kowtows
lectins92515003lectins
lections102413843lections
lectors93415763lectors
legions84611783legions
lemons84415053le_mons
lentos65317403lento_s
leptins92412693leptins
lepton82510803lepton_
lesions73813873lesions
lessons73811023lessons
leukons1135753leukons
megatons11279703megatons
melons84117713me_lons
melton8311553melton_
mentions10312893mentions
mentors9314993mentors
merlons93311273merlons
mesons83215843me_sons
metols84115773me_tols
moutons9410313moutons
mutons84314363_mutons
muttons949283muttons
nasions73112383nasions
nations74720563nations
natrons73215663natrons
neaten64214543neaten_
neats55931903neat__s
nectars938463nectars
negations102811963negations
negaton8299143negaton_
negators92411173negators
negatrons10275843negatrons
negroni846833negroni
negronis947263negronis
nektonic1445723nektonic
nelson638423nelson_
neocon836713neocon_
neon47026423ne__on_
neoteny1045023neoteny
nephrons1346853nephrons
nerols6914883ne_rols
nerts55924983nert__s
nervous1037143nervous
nesters74422793nesters
nesting84320443nesting
nestles73015463nestles
nestor63713423nesto_r
nests55728003nest__s
netop7312343ne_to_p
nets45941533ne_t__s
netters73618583netters
netting84018763netting
nettings9288103nettings
nettles73214083nettles
netts55320723ne_t_ts
network1446793network
networks1546143networks
neuron6310373neuron_
neurone739433neurone
neurones839673neurones
neuston736083neuston_
neuters74212273neuters
neutron737763neutron_
newbies12147423newbies
newborn1244273newborn
newels93710823new_els
newfound1542223newfound
newies91014073new_ies
newmown1542283newmown
newness1035703newness
news76127373new___s
newsboys1642313newsboys
newsies101310383newsies
newt76933743newt___
ninons64913773n_inons
niton55418283n_iton_
noons54125283n__oons
nostocs947553nostocs
notions74014483notions
nowts86915863nowt__s
nylons9267973n_ylons
partons94620513partons
pectens11189203pectens
pectins112315233pectins
pelotons1038913pelotons
pennons939713pennons
peons75327183pe__ons
peptone11310763peptone
peptones12311033peptones
pereons92815003pereons
perrons93115483perrons
persons93717013persons
pestos84719083pesto_s
pewters124113353pewters
photons123814433photons
phytons15319063phytons
pistons93016373pistons
pitons85319043_pitons
plutons938343plutons
pontons93315553pontons
protons93118003protons
putons83515153_putons
rattons73815323rattons
reasons72514943reasons
reckons13269653reckons
recons84922993re_cons
rectors93520513rectors
rectos85718783recto_s
redons75222183re_dons
redtops1037373redtops
regions83613473regions
rewins95020823rew_ins
rewon86920573rew_on_
rhytons13295883rhytons
seasons72614233seasons
sections102714703sections
sectors93116443sectors
seitans73312303seitans
sermons9311783sermons
seton55223543se_ton_
setous64917373se_tous
sewans95215903sew_ans
sextans14349263sextans
sexton133610793sexton_
sextos134012163sexto_s
swoons94511143_swoons
teflons1036543teflons
telsons739223telsons
tendons8311473tendons
tenons62916603te_nons
teston6313303teston_
testoons837323testoons
tons46553053___tons
tritons73814883tritons
vectors123212593vectors
vetoes92914083ve_toes
wantons103713013wantons
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
wons74942043__w_ons
wontons103310533wontons
xenons132710483xe_nons
zeatins16311733zeatins

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 Filter1786911340270.296603685.8
2DLD Change Limit1340272248.79615237.3
3Display Results2242240.0762947.4
 (SQL Overall)1786912249.16819490.7
 
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.