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

305 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
consternations1611604(None) 
consternation15106361consternation_
conservations1849092cons_ervations
constellations1654402constellations
consternating1654972consternati_ng
concatenations1873723concate_nations
condemnations1845403con_demnations
consecrations1749213cons_ecrations
conservation1749403cons_ervation_
considerations1764843consider_ations
consignations16105933cons_ignations
conspirations1747723conspir_ations
constellation1554803constellation_
consternates1455053consternat__es
constipations1747683const_ipations
constrictions1747783const_rictions
constructions1747713const_ructions
contentions13412093con_te_n_tions
contestations1547743con_testations
conversations1847453con_versations
alternations1246774__alternations
castrations13410064c_ast_r_ations
catenations1348364c__ate_nations
coacervations2053874co_acervations
cogenerations1655914cogener_ations
concatenation1764094concate_nation_
condemnation1746044con_demnation_
condensations1646274con_densations
condonations1548004con__donations
confederations20104604confeder_ations
confirmations2055674con_firmations
conformations2046724con_formations
congelations1549734con_ge_lations
congregations17186414congre_gations
conjurations2148494con_jur_ations
connations12312944con____nations
conscriptions1955004cons_criptions
consecration1649784cons_ecration_
consecutions1647054cons_e_cutions
conservational1955344cons_ervational
conservationist2084024cons_ervationist
conservatisms2083534cons_ervatisms
conservatives2195194cons_ervatives
conservatizes27114454cons_ervatizes
conservators1755974cons_ervat_ors
consideration1655524consider_ation_
consignation15136314cons_ignation_
consociations1747514cons_ociations
consolations1449744cons__olations
consolidations1754744consolidations
conspiration1648384conspir_ation_
constellating1653264constellati_ng
consternate1355124consternat___e
consternated1554114consternat__ed
constipation1648564const_ipation_
constitutions1554864const_itutions
constrains1249734const_r_a_i_ns
constriction1648264const_riction_
construction1648084const_ruction_
consultations1546934cons_ultations
consummations1955154cons_ummations
contaminations1886104contaminations
contemplations2074734con_templations
contention12412224con_te_n_tion_
contentious1347014con_te_n_tious
contestation1448664con_testation_
continuations1547154con_tinuations
contortions1348694con_tor__tions
contractions16410404con_t_ractions
contraptions1647644con_t_raptions
contritions13410914con_t_r_itions
conurbations1646664con__urbations
conventions16410534con_ve_n_tions
conversation1747804con_versation_
cooperations1659194co_oper_ations
counteractions1855024counteractions
cybernations1943604c__ybernations
menstruations1585054menst_ruations
observations1785014_obs_ervations
ostentations1246124_o_stentations
abstentions1364375_abste_n_tions
adulterations1453175adulter_ations
alliterations1384555alliter_ations
alterations11511665__alter_ations
altercations1446375__altercations
alternation1147625__alternation_
botherations1754195bo_ther_ations
cancelations1657095can_ce_lations
cancellations1754395can_cellations
cantillations1545735can_tillations
carnations12311355c____arnations
caseations1258305c_as_e__ations
castigations1547205c_ast_igations
castration12410805c_ast_r_ation_
catenation1249525c__ate_nation_
cauterizations25197155c_auterizations
centenarians1453745cen_te_narians
coacervation1964275co_acervation_
coaptations1547545coapt___ations
codetermination2062125codetermination_
cogeneration1546445cogener_ation_
cogitations1448905cogit___ations
cognations1339595co____gnations
colorations13911895co__lor_ations
combinations1897925co__mbinations
commendations2055805co_mmendations
comminations18810485co__mminations
commiserations2053455commiser_ations
compellations1954815co_mpellations
compensations19136185co_mpensations
complexations26134015comple_xations
compurgations20123895co_mpurgations
conations111318905co_____nations
concatenating1853265concate_nati_ng
concelebrations21103165concelebrations
concentrations1877075concentrations
conceptions17410595con_ce__ptions
concertinos15158125con_cer__tinos
conciliations1747205con_ciliations
concretions1549295con__cr_etions
concretizations2854035concretizations
condensation1546785con_densation_
condonation1448855con__donation_
confabulations2162805confabulations
confections18411395con_fe__ctions
confederation1995255confeder_ation_
configurations2063705configurations
confirmation1946185con_firmation_
confiscations2044955con_fiscations
conflagrations2052725conflagrations
conflations16411145con___flations
conformation1947325con_formation_
confrontations1962785confrontations
confutations1767795con__futations
congelation14410345con_ge_lation_
congestions1449315con_ge__stions
conglobations1853945con_globations
conglomerations2062735conglomer_ations
conglutinations1862545conglutinations
congregation16226765congre_gation_
conjugations2245865con__jugations
conjunctions2345385con__junctions
conjuration2049515con_jur_ation_
connation11314265con____nation_
connections15410705con_ne__ctions
connotations1447285con__notations
conscientious17102265conscien_tious
conscription1855335cons_cription_
consecrating1747945cons_ecrati_ng
consecrators1656055cons_ecrat_ors
consecution1547315cons_e_cution_
consenting13313225cons_e_n_ti_ng
conservatism19104955cons_ervati_sm
conservative20106995cons_ervati_ve
conservatize26125505cons_ervati_ze
conservatized28113605cons_ervatized
conservatizing2983095cons_ervatizing
conservatoire1862765cons_ervatoire
conservatoires1962185cons_ervatoires
conservator1656375cons_ervat_o_r
conservatory2054755cons_ervat_ory
consociation1648195cons_ociation_
consolation13410985cons__olation_
consolidation1655155consolidation_
conspirational1853965conspir_ational
conspirators1655535conspir_at_ors
constantans1353435const_an_t_ans
constatives1646935const___atives
constellates14174235constellat__es
constellatory1862595constellat_ory
constipating1775395const_ipati_ng
constitution1455265const_itution_
constrain1149335const_r_a_i_n_
constraint12411135const_r_a_i_nt
constraints1346205const_r_a_ints
constricting1747025const_ricti_ng
constrictors1676015const_rict_ors
constructing1746755const_ructi_ng
constructional1854765const_ructional
constructionist1984035const_ructionist
constructors1676475const_ruct_ors
consultation1447475cons_ultation_
consummation1855295cons_ummation_
consumptions1845145cons__umptions
contagions1346605con_t___agions
contamination1766955contamination_
contemplation1985265con_templation_
contenting13313325con_te_n_ti_ng
continuation1448195con_tinuation_
contortion1248665con_tor__tion_
contraction15411245con_t_raction_
contraption1548105con_t_raption_
contrarians1346355con_t_r_arians
contrarious1354735con_t_r_arious
contributions1754745con_tributions
contrition12411415con_t_r_ition_
conurbation1547465con__urbation_
convections18411495con_ve__ctions
convention15410565con_ve_n_tion_
conversational1954165con_versational
conversazione2761915con_versazione
conversaziones2861665con_versaziones
conversazioni2761655con_versazioni
conversions1648275con_ver__sions
convocations1947365con__vocations
cooperation15410025co_oper_ation_
coordinations1684995co_ordinations
coronations13410705co___ronations
corotations1349775corot___ations
corporations16129485co_rpor_ations
correlations1447865co_rre_lations
counteraction1755385counteraction_
counterions1349835counter___ions
counterstains15156625counterstai_ns
covariations1745985co__variations
crenations12511695c___re_nations
cunctations1576155cunct___ations
cybernation1843915c__ybernation_
deconsecrations2064515decons_ecrations
deconstructions20124365deconst_ructions
demonstrations1795675demonst_r_ations
denaturations1444955denatur_ations
denervations1657095den__ervations
desperations1559525_desper_ations
destinations13412665_dest_inations
deuterations1348085_deuter_ations
dissertations1465905_dissertations
distentions12178855_diste_n_tions
enervations1478575_en__ervations
enumerations14135515_enumer_ations
eviscerations1882705eviscer_ations
exasperations2253695exasper_ations
exenterations2054485exenter_ations
exonerations1947015exon__er_ations
fenestrations1695405fenest_r_ations
frustrations1544535frust_r_ations
generations12311425gen__er_ations
hibernations1744055__hibernations
incarnations1446665_in_carnations
innervations1546925_in_nervations
inseminations1546245_inseminations
insertions10410345_ins_er__tions
inspirations1447305_inspir_ations
installations1354225_installations
instaurations13114255_instaurations
instigations1348245_inst_igations
instillations1344925_instillations
instructions14137825_inst_ructions
integrations13129475_in_tegrations
intentions10411405_in_te_n_tions
interactions14410465_in_teractions
international1357675_in_ternational
internationals1454245_in_ternationals
intonations1149525_in_t_onations
iterations10413825___iter_ations
literations11610585__liter_ations
lustrations1147625_lust_r_ations
masturbations1753425_masturbations
menstruation1455225menst_ruation_
mensurations1445715mens_ur_ations
ministrations1555455minist_r_ations
moderations1448275mo__der_ations
monetizations2467645monet_izations
nervations1359485__n__ervations
nitrations10312035__nit_r_ations
nonsegregations17162695nonsegregations
numerations13127295__numer_ations
obliterations1553455obliter_ations
obscurations1644025_obscur_ations
observation1665065_obs_ervation_
obstructions16155525_obst_ructions
obturations13116425_o_btur_ations
operations12312955_o__per_ations
ostentation1146965_o_stentation_
ostentatious1252865_o_stentatious
oxygenations2352695_oxyge_nations
penetrations1448855penet_r_ations
postulations14127735po_st_ulations
preservations1895545pres_ervations
prostrations1449775prost_r_ations
reconsecrations1995105recons_ecrations
reconstructions19124745reconst_ructions
reiterations12410875_reiter_ations
remonstrations16116495remonst_r_ations
renaturations1355965renatur_ations
reservations1588585_res_ervations
restorations12410965_restor_ations
scatterations1552545scatter_ations
seriations10316685___s_eriations
serrations10313105___s_errations
stagnations1244905___stagnations
starvations1445055___starvations
sternutations1353755___sternutations
striations10312795___st_riations
supernations14410875__supernations
sustentations1354785_sustentations
tarnations1038905____tarnations
tolerations1158135to__ler_ations
unostentatious1461125unostentatious
venerations14411315ven__er_ations
vernations13310335____vernations
vociferations2153115vocifer_ations
westernisations18172435_westernisations
westernizations27154135_westernizations
winterizations26157505win_terizations

Search took 9 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.343520965.0
2DLD Change Limit950243057.53012619.4
3Display Results3053050.2031502.5
 (SQL Overall)1786913058.07622126.2
 
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.