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

106 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
neustons83683(None) 
neuston736081neuston_
negatons9299272negatons
nektons1136392ne_ktons
nelsons738002nels_ons
nestors73614972ne_stors
neurons7410442neu_rons
neustonic1144172neustonic
neutrons838292neutrons
newtons1036812ne_wtons
pleustons1144282pleustons
testons7313562te_stons
bestows1248863be_stows
betons84919553be__tons
bostons9312903_bostons
boutons9310783bou_tons
burtons9310853_burtons
buttons9310333_buttons
cessions1039853cessions
cestos84718093ce_sto_s
customs11348263_customs
custos84014313_custo_s
delusions1037053delusions
demetons1137623demetons
elusions82610083elusions
estops84011223_e_stops
felstone1146863felstone
felstones1246963felstones
festoons1136443fe_stoons
fusions1039153_fusions
futons93911513_fu_tons
gemstone1145843gemstone
gemstones1245563gemstones
gluttons944273gluttons
gustoes879873_gustoes
infusions1246143infusions
jetons134512613je__tons
jettons1437273je_ttons
kelsons1137323kels_ons
keystone1545333keystone
keystones1645083keystones
leptons91910433le_ptons
lesions73813873le_sions
lessons73811023le_ssons
leukons1135753leu_kons
megatons11279703megatons
meltons9410923me_ltons
mesons83215843me_s_ons
moutons9410313mou_tons
mutons84314363_mu_tons
muttons949283_muttons
nasions73112383n_asions
nauseous844833nauseous
neatens73310403ne_atens
negations102811963negations
negaton8299143negaton_
negators92411173negators
negatrons10275843negatrons
nekton1036583ne_kton_
nelson638423nels_on_
neocons936913ne_ocons
neons55818683ne___ons
nephrons1346853nephrons
nesters74422793ne_sters
nesting84320443ne_sting
nestles73015463ne_stles
nestor63713423ne_sto_r
nests55728003ne_st__s
netops839213ne__tops
neuraxons1642543neuraxons
neuron6310373neu_ron_
neurone739433neu_rone
neurones839673neu_rones
neustic937943neust_ic
neuters74212273neu_ters
neutron737763neutron_
newsboys1642313newsboys
newton936983ne_wton_
nitons64614903n__itons
nonstops10116883nonstops
nostocs947553n_ostocs
pelotons1038913pelotons
pensions10311693pensions
persons93717013pers_ons
pestos84719083pe_sto_s
pistons93016373_pistons
pleuston1044193pleuston_
plutons938343plu_tons
putons83515153_pu_tons
questions1845523questions
questors17147013questors
reasons72514943reas_ons
rebuttons1143503rebuttons
reunions837273reunions
seasons72614233seas_ons
sessions839723sessions
setons64620173se__tons
sextons143710413se_xtons
telsons739223tels_ons
tensions8310223tensions
teston6313303te_ston_
testoons837323te_stoons
trustors8268913trustors
unbuttons1142133unbuttons
versions11310353versions
weasons102310583weas_ons

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621067.23620199.3
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.70223200.6
 
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.