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

177 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
neocons93691(None) 
neocon836711neocon_
beacons11410732beacons
deacons10310392deacons
nektons1136392nektons
nelsons738002nelsons
neons55818682ne__ons
neurons7410452neurons
newtons1036812newtons
noons54125282n_o_ons
recons84922992re_cons
aeons57624653ae__ons
alencons1045483alencons
bacons104917583_bacons
beacon10511373beacon_
beckons15279143beckons
belons84119413be_lons
betons84919553be_tons
boocoos1137753boocoos
boons75031913_bo_ons
borons85520543_borons
bosons85016653_bosons
cocoas104915743_cocoas
cocoons11310563_cocoons
cocos95624693_coco_s
codons96119463_codons
cogons96818113_cogons
colons86028683_colons
cons66057693___cons
coons76737283_co_ons
croons85418423cro_ons
crotons93714373crotons
deacon9510423deacon_
decors94017773de_cors
decos85522123de_co_s
decoys123911283de_coys
demons94917723de_mons
devons104512253de_vons
dromons1038193dromons
ebons74316093_e_bons
eikons1038503_eikons
eocene8311613_eocene
eons46638713_e__ons
eosins64419163_eosins
escots84211743_escots
exons125813343_e_xons
falcons1239123falcons
felons93615763fe_lons
flacons1238053flacons
garcons102411643garcons
gascons10289103gascons
gnomons1035753gnomons
goons65326773_go_ons
helicons1337613helicons
herons94820543he_rons
icons76516493__icons
isogons8217613isogons
jetons134512613je_tons
jettons1437273jettons
kelsons1137323kelsons
kroons103711243kro_ons
legions84611783legions
lemons84415053le_mons
leptons91910433leptons
lesions73813873lesions
lessons73811023lessons
leucins938103leucins
leukons1135753leukons
lexicons1743893lexicons
locoes85516583_locoes
locos75822603_loco_s
logons79818173_logons
loons55731723_lo_ons
macons104017243_macons
mascons113411583mascons
melons84117713me_lons
meltons9410923meltons
merlons93311273merlons
mesons83215843me_sons
metopons12107023metopons
moons75331003_mo_ons
morons84919543_morons
narcos86714203narco_s
nasions73112383nasions
nations74720563nations
natrons73215663natrons
neatens73310403neatens
necks115119333ne_c_ks
negatons9299273negatons
negroni846843negroni
negronis947273negronis
nekton1036583nekton_
nelson638423nelson_
neogene847553neogene
neology11238293neology
neomycins1652973neomycins
neon47026423ne__on_
neoteny1045023neoteny
nephrons1346853nephrons
nerols6914893ne_rols
nervous1037143nervous
nestors73614973nestors
netops839223ne_tops
neuron6310373neuron_
neurone739443neurone
neurones839683neurones
neustons836833neustons
neutrons838293neutrons
newborns1343403newborns
newton936983newton_
niacins938543niacins
nicols8810243n_icols
ninons64913773n_inons
niobous936333niobous
nitons64614903n_itons
nocent83217413n_ocent
nocks115121013n_oc_ks
nocuous946583n_ocuous
nodous7711333n_odous
nolos54423353n_olo_s
nomos75919743n_omo_s
noncoms1139203noncoms
nooks95420393n_o_oks
noon47134623n_o_on_
notions74014483notions
nouns56717313n_o_uns
nylons9267973n_ylons
pecans101515833pe_cans
pelotons1038913pelotons
pennons939713pennons
peons75327183pe__ons
pereons92815003pereons
perrons93115483perrons
persons93717013persons
phonons123310253phonons
photons123814433photons
poons75430973_po_ons
protons93118003protons
racons84319343_racons
racoons93912433racoons
reasons72514943reasons
reckons13269653reckons
recoins94019243recoins
recon75624243re_con_
recooks134711233recooks
redons75222183re_dons
regions83613473regions
reopens939373reopens
seasons72614233seasons
seccos1039923secco_s
second9411153se_cond
seconds1038283se_conds
sermons9311783sermons
setons64620173se_tons
sextons143710413sextons
solons65120023_solons
spoons84116023spo_ons
stolons73410243stolons
swoons94511143swo_ons
teflons1036543teflons
telcos8710683telco_s
telsons739223telsons
tendons8311473tendons
tenons62916603te_nons
teopans939203teopans
testons7313563testons
thorons104511913thorons
toons55027533_to_ons
toyons95512133_toyons
trogons83410723trogons
tycoons1235173tycoons
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
xenons132710483xe_nons
zircons1854963zircons
zoons144919693_zo_ons

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.406440125.6
2DLD Change Limit1340271776.00022337.8
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.46927622.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.