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 “denunciations” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
denunciations165388(None) 
denunciation1554531denunciation_
enunciations1445091_enunciations
renunciations1554851renunciations
annunciations1572652annunciations
enunciation1345462_enunciation_
renunciation1455312renunciation_
annunciation1462893annunciation_
deglaciations1753913deglaciations
denudations1346343denu__dations
denunciative18112793denunciati_ve
denunciatory1852313denunciat_ory
depreciations1846573depreciations
enunciating1444373_enunciati_ng
enunciators13114133_enunciat_ors
pronunciations18122783pronunciations
annunciating1552374annunciati_ng
annunciators1452254annunciat_ors
beneficiations21182214beneficiations
consociations1747514consociations
cunctations1576154__cunctations
decantations1547944decan_tations
decimations16410164de___cimations
deconditions1645284decondi_tions
decussations1543674decu_ssations
dedications15310874de_dic_ations
deductions1467134dedu_c__tions
defalcations1845194defalc_ations
defecations1779004de_fec_ations
definitions1545604defin_i_tions
defoliations1647594de_foliations
degenerations1546354degenerations
deglaciation1654304deglaciation_
degustations1444834degu_stations
deifications18410654deific_ations
deionizations2349214deionizations
delectations1547454de_lectations
delineations1346764delin_eations
demarcations1746124demarc_ations
demonizations25410244demonizations
denaturations1444954denaturations
denegations1348544de__negations
denervations1657094den_ervations
denigrations1447354den_igrations
denominations16117854denominations
denotations1239854de__notations
densifications2046984densifications
dentations11413634de__n_tations
denticulations1753914denticulations
dentitions1148854de__nti_tions
denudation1247304denu__dation_
deprecations1748564deprec_ations
depreciation1747074depreciation_
deputations1448344depu__tations
deputizations2546744deputizations
deracinations1647834de_racinations
desecrations1559214de_secrations
desiccations1755654de_siccations
despoliations1646394despoliations
detonations1239374deton__ations
detoxications2355654detoxications
deuterations1348084de_uterations
deviations14311164de___viations
dissociations1656014dissociations
educations1339234_edu_c_ations
elucidations1544514_elu_cidations
elutriations1246024_elutriations
eluviations14115794_elu_viations
emaciations1548164_e_maciations
emancipations1953744_emancipations
enucleations1444104_enucleations
enumerations14135514_enumerations
enunciates1245134_enunciat__es
enunciator12114254_enunciat_o_r
eructations1347234_eru_ctations
exuviations2195694_exu_viations
fecundations1842964fecun_dations
herniations1447404he_rn_iations
inunctions1246754_inunc__tions
inundations12125534_inun_dations
nunnations1095904__nun_nations
pronunciation17113224pronunciation_
punctations1585354__punctations
reluctations1446754relu_ctations
remunerations1556204remunerations
renunciative17103414renunciati_ve
renunciatory1752634renunciat_ory
repudiations1597034repu_diations
repunctuations1852264repunctuations
resuscitations1673784resuscitations
truncations1344764_trunc_ations

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 Filter178691950240.390458182.1
2DLD Change Limit95024915.55017121.4
3Display Results91910.0461978.3
 (SQL Overall)178691915.98629851.5
 
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.