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

132 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
adnouns83545(None) 
adnoun757031adnoun_
adjoins1585982adjoins
adjourns1662862adjourns
adorns74212612ad_orns
nouns56717312__nouns
abound9239863a_bound
abounds10217083a_bounds
account11109043account
accounts1285843accounts
acinous9310933acinou_s
acnodes1037823acnodes
acorns85013013a_corns
adenoids1056863adenoids
adenomas1144813adenomas
adenoses947903adenoses
adenosis946343adenosis
adieus739633adieu_s
adios65822863adio__s
adipous1037183adipou_s
adjoin14107293adjoin_
adjoint15108283adjoint
adjoints16103873adjoints
adjourn1563433adjourn
adobes94411533ad_obes
adobos9438453ad_obos
adonis7314063ad_onis
adopts998083ad_opts
adores74420723ad_ores
adorn64917093ad_orn_
ados57633513ad_o__s
adown95611663ad_own_
adsorbs1044713adsorbs
adunc837433ad__unc
aduncous1143163aduncou_s
aeneous739893aeneou_s
aeneus61111143aeneu_s
aeons57624653a_eo_ns
agnomens1144893agnomens
agons66423783a_go_ns
aground9216183aground
aloins65022203a_loins
amnions93710913amnions
amount8414483a_mount
amounts937043a_mounts
amours83512663a_mours
anions64123033a_nions
ankus91410683a_nku_s
annona648873anno_na
annonas738793annonas
announce1044323announce
announces1144483announces
annoys967523anno_ys
annuls64711733a_nnuls
anoas57226493a_no_as
anodes74418753a_nodes
anoint6423633a_noint
anoints7311063a_noints
anoles64827423a_noles
anon46134853a_no_n_
anus47131113a_n_u_s
anyons94513503a_nyons
apnoeas946353apnoeas
aprons8316993apro_ns
arbours93910043arbours
ardours8368883ardours
arduous837613arduou_s
arenous7314183arenou_s
argons75018203argo_ns
armours9389853armours
around72712413a_round
arsons63917213arso_ns
astound845503astound
astounds964233astounds
attorns738443attorns
aurous64119263aurou_s
avions94114393avio_ns
awmous1157713awmou_s
axions134713483axio_ns
axons125517933a_xo_ns
azlons154110423azlo_ns
azons146518253a_zo_ns
candours11408643candours
cannons94412883canno_ns
canons85522063cano_ns
dahoons1137753dahoons
dons56048703_d_o_ns
donuts7410583_donuts
doums85417643_d_oums
downs94918573_d_owns
drouks1137123_drouks
drowns105612333_drowns
duns55140433_d__uns
fadeouts1245693fadeouts
fanons96115213fano_ns
gadroons1037013gadroons
hadrons113314303hadro_ns
handguns1344363handguns
handouts1238233handouts
honours10339373honours
inruns6359513_inruns
knouts10438313_knouts
knowns13426443_knowns
ladrons83813193ladro_ns
madzoons20124773madzoons
midnoons1144403midnoons
ninons64913773nino_ns
noons54125283__noons
noun45724183__noun_
nous46136983__nou_s
nuns45228233__n_uns
odeons739023odeo_ns
odious749933odiou_s
odours7418253od_ours
padouks1434873pad_ouks
pandours11317993pandours
pinons86019943pino_ns
pronouns1047203pronouns
radons74118533rad_o_ns
rainouts846913rainouts
renowns10277833renowns
runouts737353runouts
snouts64915873_snouts
swouns9358243_swouns
tenons62916603teno_ns
tenours72610073tenours
udons65411463ud_o_ns
venous93713193venou_s
vinous93914173vinou_s
vodouns1134763vodouns
wanguns1135023wanguns
xenons132710483xeno_ns

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.1561145455.1
2DLD Change Limit1340271326.06022116.7
3Display Results1321320.0502640.0
 (SQL Overall)1786911326.26628517.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.