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

270 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
consolidations175473(None) 
consolidation1655151consolidation_
consociations1747502consoci_ations
consolations1449722consol__ations
consolidating1753272consolidati_ng
consolidators1653282consolidat_ors
conciliations1747193concili_ations
consociation1648193consoci_ation_
consolation13410983consol__ation_
consolidates1563863consolidat__es
consolidator1553273consolidat_o_r
conspirations1747713cons_pirations
constipations1747673cons_tipations
consultations1546933consul_tations
podsolizations26164373podsolizations
canalizations24410434can_alizations
canonizations2447244can_onizations
colligations1556834co__lligations
collimations1656874co__llimations
colonisations15216174co_lonisations
colonizations24229414co_lonizations
colorizations241410324co_lorizations
complications2147424co_mplications
conciliation1648234concili_ation_
condonations1547994condo__nations
conflations16411134con_fl__ations
conflictions1945224con_fli_ctions
conformations2046714confo_rmations
congelations1549724congel__ations
conglobations1853934con_globations
connotations1447274conno__tations
conscriptions1954984conscri_ptions
consecrations1749184cons_ecrations
conservations1849084cons_ervations
considerations1764824considerations
consignations16105934cons_ignations
consociating1755564consoci_ati_ng
consociational1853534consoci_ational
consolidate1463784consolidat___e
consolidated1663314consolidat__ed
conspiration1648374cons_piration_
constellations1654404constellations
consternations16116034consternations
constipation1648564cons_tipation_
constitutions1554864cons_titutions
constrictions1747774constri_ctions
consultation1447474consul_tation_
consummations1955154cons_ummations
contaminations1886104contaminations
convocations1947344convo__cations
convolutions1745194convol__utions
creolizations2457884c_reolizations
cuspidations1743344c_us_pidations
fossilizations2654684fossilizations
insolations1149184_insol__ations
invalidations1745614_invalidations
monopolizations2893384monopolizations
nonsolutions1254154nonsol__utions
podsolization25165004podsolization_
podzolizations25153874podzolizations
reconsolidating1962004reconsolidati_ng
aerosolizations2453795aerosolizations
aldolizations2346335_aldolizations
anodizations2276925_an_odizations
associations1445745_associ_ations
autoxidations2153555_autoxidations
canalization23411165can_alization_
cancelations1657085cancel__ations
cancellations1754395cancel_lations
canonization2347925can_onization_
cantillations1545735cantil_lations
carbonizations2774955carbonizations
cartelizations2556545cartelizations
castigations1547205c_as_tigations
centralizations26157775centralizations
cephalizations3087595cephalizations
channelizations2962325channelizations
chlorinations1855505c_hlorinations
ciliations121110995c___ili_ations
civilisations1853645c_ivilisations
civilizations2747275c_ivilizations
coagulations1546505coagul__ations
coalifications2155705coalifications
coalitions1247915co__ali__tions
cocainizations2755435cocainizations
cocultivations2152765cocultivations
codifications21127625co_difications
coevolutions1754085coevol__utions
cogitations1448885c___ogitations
cohabitations2053455co_habitations
collations12312845c___ol_lations
colligation1457445co__lligation_
collimation1557575co__llimation_
collocations1646395co__llocations
colonisation14176765co_lonisation_
colonization232010225co_lonization_
colorations13911865c___olorations
colorization231711185co_lorization_
columniations1764785columni_ations
combinations1897915co__mbinations
commendations2055785co_mmendations
comminations18810465co__mminations
communications22105735communications
communizations29126085communizations
compellations1954795compel_lations
compilations1848665co__mpilations
complexations26134005co_mplexations
complication2048195co_mplication_
compositions1846245composi__tions
conations111318895con_____ations
concatenations1873715concatenations
concelebrations21103155concelebrations
concentrations1877045concentrations
conciliating1775605concili_ati_ng
conciliators1695385concili_at_ors
concoctions1448235conco___ctions
concretizations2854025concretizations
condemnations1845405con_demnations
condensations1646265con_densations
conditions13410095con____ditions
condonation1448855condo__nation_
confabulations2162805confabulations
confederations20104585confederations
configurations2063695configurations
confirmations2055675con_firmations
confiscations2044955con_fiscations
conflagrations2052715conflagrations
conflation15412085con_fl__ation_
confliction1845235con_fli_ction_
conformation1947325confo_rmation_
confrontations1962765confrontations
confutations1767785con__futations
congelation14410345congel__ation_
conglobation1754255con_globation_
conglomerations2062715conglomerations
conglutinations1862545conglutinations
congregations17186395con_gregations
conjugations2245855con__jugations
conjurations2148475con__jurations
connations12312935con____nations
conniptions1546025con__ni_ptions
connotation1347985conno__tation_
conscientious17102255cons_cientious
conscription1855325conscri_ption_
consecration1649785cons_ecration_
consecutions1647035cons__ecutions
conservation1749405cons_ervation_
consideration1655505consideration_
consignation15136315cons_ignation_
consociates1546545consoci_at__es
consolatory1684955consol__at_ory
conspirational1853935cons_pirational
conspirators1655525cons_pirat_ors
constellation1554795constellation_
consternation15106355consternation_
constipating1775385cons_tipati_ng
constitution1455265cons_titution_
constriction1648255constri_ction_
constructions1747695cons_tructions
consummation1855295cons_ummation_
consumptions1845135cons__umptions
contamination1766955contamination_
contemplations2074725contemplations
contestations1547725con_testations
continuations1547145con_tinuations
contortions1348655conto___rtions
contradictions1954145contradictions
contributions1754745con_tributions
contritions13410895con_tri__tions
conurbations1646655con__urbations
conversations1847445con_versations
convictions1848035con__vi_ctions
convocation1847875convo__cation_
convolution1645125convol__ution_
cooperations1659175co__operations
coordinations1684975co_ordinations
copulations151111095co_pul__ations
cornifications2145955cornifications
coronations13410675co_ro__nations
corotations1349735co_ro__tations
corporations16129445corpo__rations
correlations1447825correl__ations
corroborations1882595corroborations
covariations1745975co_vari_ations
creolization2348815c_reolization_
cuspidation1643495c_us_pidation_
cyclizations2845755c__yclizations
defoliations1647585_defoli_ations
denominations16117845den_ominations
densifications2046985densifications
deoxidations2145235__deoxidations
desalinations14410175_desalinations
desolations12310575_desol__ations
despoliations1646385despoli_ations
dieselizations2455895dieselizations
disconsolations1863195disconsol__ations
dissociations1656005dissoci_ations
embolizations2646725_embolizations
epoxidations2243645__epoxidations
exfoliations2244785_exfoli_ations
finalizations2549255fin_alizations
fluoridations1783205_fluoridations
focalizations2748995fo_calizations
foliations1399945___foli_ations
formalizations28146975formalizations
fossilization2565145fossilization_
homologations19102335ho_mologations
idolizations2247445__idolizations
inclinations1448745_in_clinations
insanitations13136465_insanitations
inseminations1546225_inseminations
insolation10410215_insol__ation_
inspirations1447295_ins_pirations
instigations1348245_ins_tigations
instillations1344925_instillations
insulations11310235_insul__ations
intimidations1686665_intimidations
intoxications22135675_intoxications
invalidation1646035_invalidation_
ionizations2049875ion___izations
isolations10310685__isol__ations
localizations2449785lo_calizations
mobilizations2687875mo_bilizations
monetizations2467625mon_etizations
mongrelizations2753695mongrelizations
monopolization2793405monopolization_
moralizations24410815mo_ralizations
motorizations2449085mo_torizations
nasalizations2248695_nasalizations
nidations1039215__n___idations
nominations13410525__n_ominations
noncultivations20182745noncultivations
nonimplications21122875nonimplications
nonsolution1154735nonsol__ution_
normalizations25147535normalizations
novelizations2556355no_velizations
obligations1446145_o__bligations
oscillations1445115_o_scillations
ossifications18176145_ossifications
oxidations1845445____oxidations
ozonizations2045305_o_zonizations
penalizations24511625pen_alizations
photooxidations2872715photooxidations
podzolization24194375podzolization_
pollinations1447225po__llinations
pontifications2187905pontifications
randomizations2653675randomizations
reconciliations1953735reconcili_ations
reconsolidates17122225reconsolidat__es
renominations15108295ren_ominations
reoxidations2046045__reoxidations
revalidations1747115_revalidations
robotizations2446345ro_botizations
salivations1448735___salivations
sensitisations1493625sensitisations
sensitizations23126085sensitizations
sensualizations24286195sensualizations
socializations2548475socializations
solations9814625___sol__ations
solmizations2346615___solmizations
solvations1336835___sol_vations
sonications1349945___sonications
spoliations1347695__spoli_ations
symbolizations3053395symbolizations
unionisations1353205_unionisations
unionizations2255305_unionizations
validations1547245___validations
vandalizations2756315vandalizations
vasodilations1752965_vasodilations
vocalizations2749275vo_calizations

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.1261418182.5
2DLD Change Limit950242708.00011878.0
3Display Results2702700.1861451.6
 (SQL Overall)1786912708.31221498.0
 
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.