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

146 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
negaton829914(None) 
megaton10269851megaton
negation92913021negation
negatons9299271negatons
negator83010671negator
negatron9335991negatron
gigaton946342gigaton
legation92412932legation
legato72810952legato_
legator83011132legator
legatos82711182legatos
megaron10248302megaron
megatons11279702megatons
neaten64214542ne_aten
negate72915572negat_e
negated93413232negated
negater83711962negater
negates83215842negates
negating102012832negating
negations102811962negations
negators92411172negators
negatrons10275842negatrons
nekton1036582ne_kton
neuston736082neuston
newton936982ne_wton
abnegation1345413abnegation
abnegator1243593abnegator
aeration8319933aeration
aerator7314843aerator
baton75822423__baton
beacon10511373be_acon
beaten84617063be_aten
began86319573bega__n
begat86629723begat__
betatron1045233betatron
beton76022063be__ton
bevatron1343883bevatron
celadon1036913celadon
ceratin93020163ceratin
craton84517193_craton
deacon9510423de_acon
decagon1135863decagon
delation92318083delation
delator83015033delator
demeton1037683demeton
denegation1249413denegation
eaten55323053_e_aten
elation73620453_elation
enation73419233_enation
etalon648973_etalon
fetation11613143fetation
fugato1036223fugato_
fugatos1135483fugatos
gator64416043__gator
gelatin83514733gelatin
gelation93014433gelation
gelato73812963gelato_
gelatos83111523gelatos
gigatons1046053gigatons
hegemon1345173hegemon
hematin121516023hematin
hexagon1843823hexagon
jeton124815403je__ton
jetton1338033je_tton
keratin113314153keratin
legate72917453legat_e
legated92513983legated
legatee82814633legatee
legates82917683legates
legatine91311403legatine
legating102313113legating
legations102711923legations
legators92811033legators
legion75712983leg_ion
lepton82510803le_pton
levator10298963levator
ligation92313093ligation
megapod1344893megapod
melton8311553me_lton
menazon1846053menazon
natation81513933natation
nation64322803n__ation
natron64116023n__atron
neat46356783ne_at__
neatens73310403ne_atens
neater64424313ne_ater
neath86020283ne_at_h
neatly93812483ne_atly
neats55931903ne_at_s
negaters9349783negaters
negational1147153negational
negative1239083negative
negroni846833neg_roni
nektons1136393ne_ktons
nelson638423ne_lson
nematic111714003nematic
nematode1155163nematode
neocon836713ne_ocon
neon47026423ne___on
nephron1246653nephron
nervation12610243nervation
nestor63713423ne_stor
netop7312343ne__top
neuraxon1542753neuraxon
neuron6310373ne_uron
neustons836833neustons
neutron737763neutron
newtons1036813ne_wtons
nidation9410583nidation
niton55418283n__iton
nonagon847313nonagon
notation81414603notation
novation111710013novation
nugatory1245273nugatory
nutation81513103nutation
organon845913organon
peloton938743peloton
reason62616333re_ason
rebato83714683rebato_
rebatos92913113rebatos
regain74517763rega_in
regatta835963regatta
region74614903reg_ion
relation82619773relation
relator74016373relator
rigatoni944623rigatoni
rogation91612053rogation
sabaton937713sabaton
sacaton938993sacaton
season62714903se_ason
sedation9312453sedation
senator7313073senator
seton55223543se__ton
sexton133610793se_xton
telamon936523telamon
teston6313303te_ston
tevatron1143973tevatron
uneaten7412543une_aten
vegan95114153vega__n
venation11513503venation
vexation1838783vexation
weakon13357623we_akon
weapon11288113we_apon
weason93210823we_ason
zacaton1845633zacaton
zeatin15412823ze_atin

Search took 8 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.403443402.0
2DLD Change Limit1340271466.78319759.3
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.24924650.4
 
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.