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

145 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
adnoun75703(None) 
adnouns835451adnouns
adjoin14107272adjoin
adjourn1563422adjourn
adorn64917092ad_orn
adown95611662ad_own
anon46134852a_no_n
noun45724182__noun
aboon74918703a_boon
abound9239863a_bound
about75229083a_bout
account11109043account
acinous9310923acinous
acnode938193acnode
acorn75616623a_corn
adenoid959243adenoid
adenoma1045403adenoma
adieu6417423adieu_
adieus739633adieus
adieux1444283adieux
adios65822863adio_s
adipous1037183adipous
adjoins1585983adjoins
adjoint15108283adjoint
adjourns1662853adjourns
adman84517903ad_man
admen84516183ad_men
adnate72913483adnate
adnexa1433673adnexa
ado49146873ad_o__
adobe84814703ad_obe
adobo84711593ad_obo
adonis7314063adonis
adopt81219743ad_opt
adore65723663ad_ore
adorns74212613ad_orns
ados57633513ad_o_s
adoze155713833ad_oze
adroit7518783adroit
adsorb946943adsorb
adunc837433ad__unc
aduncous1143153aduncous
adwoman1345433adwoman
adwomen1345683adwomen
adytum1243733adytum
aeneous739893aeneous
aeneus61111143aeneus
aeon45634613a_eo_n
afoul8510193a_foul
agnomen1036763agnomen
agon56531883a_go_n
aground9216183aground
aloin55227413a_loin
aloud65018063a_loud
amnion84812053amnion
amount8414483a_mount
amour75014853a_mour
ancon75718233a_ncon
anion55028813a_nion
ankus91410683a_nkus
annona648873annona
announce1044323announce
annoy869713anno_y
annoys967523annoys
annul55813383a_nnul
anoa45634473a_no_a
anoas57226493a_noas
anode65021033a_node
anoint6423633a_noint
anole55330373a_nole
anomy105113393a_nomy
anus47131113a_n_us
anyon85615223a_nyon
apnoea867093apnoea
apron7318833apro_n
arbour84211323arbour
ardour74110893ardour
arduous837603arduous
arenous7314183arenous
argon65520593argo_n
armour84411853armour
around72712413a_round
arson55118833arso_n
astound845503astound
aswoon947013aswoon
attorn6310793attorn
aurous64119263aurous
avion84218343avio_n
awmous1157713awmous
axion1211316913axio_n
axon115524303a_xo_n
azlon144312873azlo_n
azon135725053a_zo_n
candour104210233candour
cannon84514443canno_n
canon74725303cano_n
dahoon1039053dahoon
don46757653_d_o_n
donut6324513_donut
doum76226673_d_oum
dour56330433_d_our
doux125817983_d_oux
down86427493_d_own
drouk1039433_drouk
drown95515823_drown
dun46545583_d__un
fadeout11410193fadeout
fanon84619013fano_n
gadroon938173gadroon
hadron102913753hadro_n
handgun1244623handgun
handout11314103handout
honour94710863honour
inrun52911373_inrun
knout95018263_knout
known12568343_known
ladron73413323ladro_n
madzoon1996063madzoon
midnoon1044683midnoon
ninon55517383nino_n
noon47134623__noon
nouns56717313__nouns
nous46136983__nous
nun35537743__n_un
odeon6411483odeo_n
odious749933odious
odour64710473od_our
padouk1336683pad_ouk
pandour10408213pandour
pinon76024533pino_n
pronoun939033pronoun
radon64620503rad_o_n
rainout7314393rainout
renown9369983renown
runout6414873runout
snout54530633_snout
swoun84811493_swoun
tenon53320513teno_n
tenour62610733tenour
udon56017743ud_o_n
venous93713193venous
vinous93914173vinous
vodoun1036233vodoun
wangun1037103wangun
xenon122612453xeno_n

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161456.09318499.3
3Display Results1451450.0463152.2
 (SQL Overall)1786911456.28228444.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.