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

262 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
newton93698(None) 
nekton1036581nekton
newtons1036811newtons
beton76022062be_ton
jeton124815402je_ton
jetton1338032jetton
lepton82510802lepton
melton8311552melton
neaten64214542neaten
negaton8299142negaton
nektons1136392nektons
nelson638422nelson
neocon836712neocon
neon47026422ne__on
nestor63713422nestor
netop7312342ne_top
neuron6310372neuron
neuston736082neuston
neutron737762neutron
newborn1244282newborn
newmown1542282newmown
newt76933742newt__
newts86015282newt_s
niton55418282n_iton
rewon86920582rew_on
seton55223542se_ton
sexton133610792sexton
teston6313302teston
aeon45634613ae__on
aswoon947013aswoon
baton75822423_baton
beacon10511373beacon
beaten84617063beaten
beckon14309383beckon
belon73924113be_lon
benthon1237693benthon
bento75922953bento_
bentos86218303bentos
bestow1149463bestow
betons84919553be_tons
betony114211583be_tony
bettor83612223bettor
boston8513043boston
bouton8311533bouton
burton8311273burton
button8310273button
canton85722993canton
carton84522663carton
cento76625173cento_
centos85920463centos
cestoi84511953cestoi
cestos84718093cestos
chiton112612393chiton
cotton8312993cotton
craton84517193craton
croton84415453croton
cyton101511463_cyton
dalton7311273dalton
deacon9510423deacon
debtor938333debtor
demeton1037683demeton
demon86520313de_mon
dentin73919573dentin
detox13310953de_tox
devon95113683de_von
dewan95718043dew_an
dewool1047403dewool
eaten55323053_eaten
ebon66821103_e_bon
eikon939463_eikon
enation73419233enation
eon36052083_e__on
estop74312103_estop
exon117116803_e_xon
extol1247893_extol
felon84619293fe_lon
festoon1037673festoon
fetor81214533fe_tor
futon83113773_futon
gentoo7311313gentoo
hector113312653hector
hereon93914363hereon
heron85025503he_ron
hewn106719853hew__n
jeon116821443je__on
jetons134512613je_tons
jettons1437273jettons
kelson1038153kelson
keto86223453ke_to_
ketol95414003ke_tol
ketone105014533ke_tone
kowtow1643463kowtow
lectin82515013lectin
lection92614863lection
lector83514983lector
legion75712983legion
lemon75618183le_mon
lenten6312883lenten
lento57223393lento_
lentos65317403lentos
leptin82512333leptin
leptons91910433leptons
lesion64715063lesion
lesson64412043lesson
leukon1036143leukon
megaton10269853megaton
melon73922083me_lon
meltons9410923meltons
mention9314373mention
mentor8414363mentor
merlon83012353merlon
meson74118313me_son
metol75917813me_tol
mouton8410853mouton
muton73817003_muton
mutton8510453mutton
nasion63914083nasion
nation64322803nation
natron64116023natron
neat46356783neat__
neatens73310403neatens
neater64424313neater
neath86020283neat_h
neatly93812483neatly
neats55931903neat_s
nectar838853nectar
negation92913023negation
negatons9299273negatons
negator83010673negator
negatron9335993negatron
negroni846833negroni
nektonic1445723nektonic
nelsons738003nelsons
neocons936913neocons
neons55818683ne__ons
neoteny1045023neoteny
nephron1246653nephron
nerol51017813ne_rol
nerts55924983nert_s
nertz145117453nert_z
nest45548733nest__
nested74720063nested
nester64124183nester
nesting84320443nesting
nestle63013953nestle
nestors73614973nestors
nests55728003nest_s
net36670293ne_t__
netops839213ne_tops
nets45941533ne_t_s
nett46643233ne_t_t
netted74118713netted
netter63722023netter
netting84018763netting
nettle64514583nettle
nettly9459453nettly
netts55320723ne_tts
netty85816763ne_tty
network1446803network
neurone739433neurone
neurons7410443neurons
neustons836833neustons
neuter63713793neuter
neutrons838293neutrons
new66237093new___
newbie11135413newbie
newborns1343403newborns
newel86114133new_el
newels93710823newels
newer85717463new_er
newest9314213newest
newfound1542223newfound
newie81813483new_ie
newies91014073newies
newish1237903newish
newly114610203new_ly
news76127373new__s
newsboy1542493newsboy
newsie9138213newsie
newsman1245503newsman
newsmen1235893newsmen
newsy11489393new_sy
next116631083next__
ninon55517383n_inon
nitons64614903n_itons
noon47134623n__oon
nostoc868193nostoc
notion64516583notion
nowt78833753nowt__
nowts86915863nowt_s
nylon82910513n_ylon
parton84720993parton
pecten102711103pecten
pectin102615533pectin
pelon74423213pe_lon
peloton938743peloton
pennon8310643pennon
peon65635243pe__on
peptone11310763peptone
pereon83517453pereon
perron83216623perron
person83517873person
pesto75723723pesto_
pestos84719083pestos
petto76021043petto_
pewter114013673pewter
photon1111514833photon
phyton143610253phyton
piston83515923piston
piton76121583_piton
pluton838853pluton
ponton83217643ponton
proton84318893proton
puton73617913_puton
ratton64116123ratton
reason62616333reason
reckon123010543reckon
recon75624243re_con
recto74520803recto_
rector84019753rector
rectos85718783rectos
redon65424883re_don
redtop937973redtop
region74614903region
retorn610923433re_torn
rewan85623663rew_an
rewin85623963rew_in
reworn98122203reworn
rhyton12356113rhyton
season62714903season
section92515663section
sector83415933sector
seitan62613233seitan
sermon8413553sermon
setons64620173se_tons
sewan85921293sew_an
sewn76124333sew__n
sextan13389643sextan
sexto124415453sexto_
sextons143710413sextons
sextos134012163sextos
swoon85014783_swoon
teflon937453teflon
telson6310293telson
tendon7312033tendon
tenon53320513te_non
testons7313563testons
testoon748373testoon
ton310265103___ton
triton63914893triton
uneaten7412543uneaten
unwon84512343unw_on
vector113212063vector
veto76622993ve_to_
wanton94413813wanton
weakon13357623weakon
weapon11288113weapon
weason93210823weason
won66252063__w_on
wonton93410963wonton
xenon122612453xe_non
zeatin15412823zeatin

Search took 6 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.376475242.0
2DLD Change Limit1127162624.86023192.6
3Display Results2622620.0763447.4
 (SQL Overall)1786912625.31233639.1
 
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.