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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
pronunciations1812278(None) 
pronunciation17113221pronunciation_
pronunciational1971622pronunciational
renunciations1554852_renunciations
annunciations1572653_annunciations
denunciations1653883_denunciations
enunciations1445093__enunciations
renunciation1455313_renunciation_
annunciation1462894_annunciation_
consociations1747514_consociations
denunciation1554534_denunciation_
enunciation1345464__enunciation_
potentiations1555184p_otentiations
premunitions1644984premun_i_tions
procurations1647404procu__rations
productions1647534produ_c__tions
profanations17175254profan__ations
prolongations1673354prolon_gations
promulgations1892834promu_lgations
pronations12314034pro__n__ations
propitiations1756204pro_pitiations
protonations1449074proton__ations
provocations1956874pro_voc_ations
punctations1585354p___unctations
truncations1344764tr__unc_ations
annunciating1552375_annunciati_ng
annunciators1452255_annunciat_ors
brecciations1844285br__ecciations
brominations1646755bromin__ations
cofunctions1845015_cofunc__tions
columniations1764795_columniations
communications22105755communications
conciliations1747205_conciliations
conjunctions2345385_conjunc__tions
connations12312945_con_n__ations
conniptions1546035_con_n_iptions
connotations1447285_con_notations
consecrations1749215_consecrations
consociation1648195_consociation_
conurbations1646665_conu_rbations
convocations1947365_convoc_ations
cornifications2145955cornifications
coruscations1645245_corusc_ations
crenulations1446495crenu__lations
cunctations1576155___cunctations
enunciating1444375__enunciati_ng
enunciators13114135__enunciat_ors
eroticizations25115785ero_ticizations
eructations1347235er__u_ctations
excruciations24112995excru_ciations
exponentiations2461735exponentiations
fornications1755395forn_ic_ations
foundations1543435_fo_un_dations
granulations1345785granu__lations
inunctions1246755__inunc__tions
inundations12125535__inun_dations
nunnations1095905___nun_nations
officiations2053505__officiations
perennations1447255peren_n__ations
phonations1538315pho__n__ations
pinnations1236885p_in_n__ations
pontifications2187925p_ontifications
populations15148715p_opu__lations
potentiation1455975p_otentiation_
preconceptions2253885preconceptions
preconditions1854895precondi_tions
preconvictions2353355preconvictions
predications17411185pr_edic_ations
preignitions1554005preign_i_tions
premonitions1646855premon_i_tions
premunition1545575premun_i_tion_
prenominations18105765prenominations
prepublications2372665prepublications
presentations1548135presen_tations
prevarications2154745prevarications
proactions1449345pro__ac__tions
probations14311085pro____bations
proclamations1952695pro_clamations
procreations1647275pro__creations
procuration1548295procu__ration_
production1547895produ_c__tion_
profanation16186105profan__ation_
profundities1852625profundi_ti_es
prohibitions1953835pro_hibi_tions
projections2258475pro_jec__tions
proliferations1952705proliferations
prolongation1563715prolon_gation_
promulgation17123245promu_lgation_
pronation11415705pro__n__ation_
pronunciamento2091015pronunciamento
pronunciamentos218795pronunciamentos
propagations1745555pro__pagations
propitiation1656915pro_pitiation_
propositions16108315pro_posi_tions
prorations12314465pro____rations
prorogations1556725pro__rogations
proscriptions19114165pro_scriptions
prosecutions1645615pro_sec_utions
prostrations1449765pro__strations
protections15510705pro_tec__tions
protestations1555815pro_testations
protonation13510435proton__ation_
protractions1646645protrac__tions
provincialisms23102225provincialisms
provincialists21122315provincialists
provincializes3062035provincializes
provocation1847355pro_voc_ation_
punctation1486055p___unctation_
punctuations1643185p___unctuations
punitions1137925p___un_i_tions
reluctations1446755_relu_ctations
remunerations1556205_remunerations
renunciative17103415_renunciati_ve
renunciatory1752635_renunciat_ory
repudiations1597035_repu_diations
repunctuations1852265_repunctuations
resuscitations1673785_resuscitations
romanizations2459295_romanizations
sonications1349955_son_ic_ations
trifurcations1852865trifurc_ations
truncation1245455tr__unc_ation_

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.360496363.9
2DLD Change Limit950241215.73316574.9
3Display Results1211210.0761592.1
 (SQL Overall)1786911216.16928966.0
 
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.