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

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

244 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
declarations154680(None) 
declamations1745301declamations
declaration1447831declaration_
decelerations1646422decelerations
declamation1646102declamation_
declinations15410222declinations
decorations14312882dec_orations
deflagrations1883022deflagrations
deflorations1646062deflorations
reclamations1645712reclamations
acclamations18164043acclamations
clavations1546183__clavations
deaerations12311673de_aerations
dealations11311373de__alations
debarkations1943653de_barkations
decantations1547943decantations
deceleration1547173deceleration_
decimations16410163dec_imations
declarative1754323declarati_ve
declaratory1752853declarat_ory
declination14411873declination_
decollations1547363decollations
decoration13314423dec_oration_
decussations1543673decussations
defalcations1845193defalcations
defamations1745893de_famations
deflagration1773473deflagration_
deflations1439713defl__ations
defloration1547263defloration_
deglaciations1753913deglaciations
degradations1544553degradations
dehydrations2043403dehydrations
delations102616593de_l__ations
delegations1348033de_legations
demarcations1746123de_marcations
denigrations1447353denigrations
depravations1885373depravations
desecrations1559213desecrations
desperations1559523desperations
deuterations1348083deuterations
devaluations1646353devaluations
dilatations1246413d_ilatations
disclamations1853723disclamations
exclamations23104103exclamations
reclamation1546353reclamation_
relaxations1845643re_laxations
reparations13611663re_parations
separations1369273se_parations
accelerations1754194accelerations
acclamation17144754acclamation_
acclimations18146294acclimations
aerations9317904ae___rations
carnations12311354__c_arnations
celebrations1645744celebrations
cerebrations1646964cerebrations
clarions10310494__clar__ions
clavation1447004__clavation_
colorations13911894_colorations
cyclizations2845754cyclizations
darnations1138414d___arnations
deactivations19175064deactivations
deaeration11313014de_aeration_
dealation10313004de__alation_
deaminations151010134deaminations
debarkation1844244de_barkation_
debilitations1647134debilitations
decantation1448944decantation_
decapitations1847664decapitations
decarbonations19123154dec_arbonations
decelerating1645594decelerati_ng
decelerators1553494decelerat_ors
deceptions1547864dec__eptions
decerebrations1993744decerebrations
dechlorinations2153114dechlorinations
decimation15411624dec_imation_
declamatory1952564declamat_ory
declarant1246034declara___nt
declarants1343604declara__nts
declaratively2262184declaratively
declaring1339574declar__i_ng
declensions1443334decl_ensions
declinational1652924declinational
decoctions1547144dec__octions
decollation1448194decollation_
decolorizations27136104decolorizations
deconditions1645284deconditions
decorating14312074dec_orati_ng
decorators1347874dec_orat_ors
decryptions1943614dec_ryptions
decurions1246024dec_ur__ions
decussation1444304decussation_
dedications15310874de_dications
defalcation1746224defalcation_
defamation1646844de_famation_
defecations1779004de_fecations
deflagrating1852664deflagrati_ng
deflation13310654defl__ation_
deflections17187324defl_ections
defoliations1647594defoliations
deformations1846844deformations
degenerations1546354degenerations
deglaciation1654304deglaciation_
deglutitions1452154deglutitions
degradation1445384degradation_
degustations1444834degustations
dehydration1954064dehydration_
deifications18410654deifications
delaminations1647944de_laminations
delation92318084de_l__ation_
delectations1547454delectations
delegation1238884de_legation_
deletions102610934de_l__etions
deliberations1645534deliberations
delineations1346764delineations
demarcation1647024de_marcation_
denaturations1444954denaturations
denegations1348544de_negations
denervations1657094denervations
denigration1348464denigration_
denotations1239854de_notations
dentations11413634de__ntations
denudations1346344de_nudations
deoxidations2145244deoxidations
depilations14310904de_pilations
depletions1355744depl__etions
depolarizations27146334depolarizations
deportations1548464deportations
depravation1785694depravation_
deprecations1748564deprecations
depredations1646734depredations
deprivations1897924deprivations
deputations1448344de_putations
derivations15611494de_rivations
dermabrasions186844dermabrasions
derogations1349394de_rogations
desalinations14410184desalinations
desecration14410074desecration_
desertions1139884de_ser_tions
desiccations1755654desiccations
desiderations1545674desiderations
designations1456944designations
desolations12310594de_solations
desorptions1445994de_sorptions
desperation14510114desperation_
desquamations2581754desquamations
destinations13412664destinations
detestations1347584detestations
detonations1239374de_tonations
detractions14118274detra_ctions
detritions1148954de__tritions
deuteration1249104deuteration_
devaluation1547074devaluation_
devastations1645824devastations
deviations14311164de__viations
dictations1389704dic__tations
dilatation1147394d_ilatation_
dilations102614454d_il__ations
disclamation1754244disclamation_
discolorations17104304discolorations
dislocations15136984dislocations
divagations16103834d_ivagations
duplications1746284duplications
durations10311464d___urations
elaborations1444924_e_laborations
elations83719124_e_l__ations
elevations1338634_e_levations
emanations1289594_e_manations
embarkations2062254_embarkations
emigrations14187154_emigrations
escalations1347664_escalations
evaluations1457324_evaluations
exaltations1847294_exaltations
excavations2345084_excavations
exclamation22104634exclamation_
execrations2048924_execrations
exhalations2146024_exhalations
exhilarations2352414exhilarations
expirations2069584_expirations
explanations2144624explanations
explorations2185614explorations
fecundations1842964fecundations
federations1548884fe_derations
fellations1338064fe_l_lations
filtrations1445624_filtrations
gelations102513094ge_l__ations
generations12311424ge_nerations
idealizations2379454idealizations
incarnations1446664inc_arnations
inclinations1448754inclinations
lacerations1348334lac_erations
lavations1238974___lavations
laxations1637624___laxations
lucubrations1652544lucubrations
macerations1548474mac_erations
meliorations1466754meliorations
mensurations1445714mensurations
mercurations1646564mercurations
methanations1743974methanations
nucleations1345314nucl_eations
pectinations1649254pectinations
peculations15310284pec_ulations
peltations12311554pe_l_tations
penetrations1448854penetrations
perforations1747874perforations
perorations13314064pe_rorations
placations1438584__placations
planations1238724__planations
preparations1648314preparations
proclamations1952694proclamations
realizations21415534realizations
recalibrations1853694recalibrations
recantations1448874recantations
recautions1247814rec_a_utions
recitations13314204rec_itations
recordations1548644recordations
recreations13412254rec_reations
recuperations1746084recuperations
redecorations1645084redec_orations
reflations13311234refl__ations
rehydrations1943984rehydrations
reiterations12410874reiterations
relations92418334re_l__ations
relaxation1746454re_laxation_
relegations1248974re_legations
relocations13311144re_locations
remigrations15227794remigrations
reoperations14410064reoperations
reparation12612724re_paration_
replantations1544864replantations
replications16811054replications
respirations14410304respirations
restorations12410964restorations
retaliations12511404retaliations
retardations1396514re_tardations
revaluations1557634revaluations
scalations1239784_sc_alations
secretions12117854sec__retions
secularizations2675384secularizations
separation12510434se_paration_
serrations10313104se__rrations
tolerations1158134_tolerations
ulcerations1346364ulc_erations
velarizations2549274ve_larizations
venerations14411314ve_nerations

Search took 8 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 Filter1786911247900.390458182.1
2DLD Change Limit1247902447.39316879.5
3Display Results2442440.1561564.1
 (SQL Overall)1786912447.93922508.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.