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
consolidations175474(None) 
consolidation1655151consolidation_
consociations1747512consoci_ations
consolations1449732consol__ations
consolidating1753282consolidati_ng
consolidators1653292consolidat_ors
conciliations1747203concili_ations
consociation1648193consoci_ation_
consolation13410983consol__ation_
consolidates1563863consolidat__es
consolidator1553283consolidat_o_r
conspirations1747723cons_pirations
constipations1747683cons_tipations
consultations1546933consul_tations
podsolizations26164373podsolizations
canalizations24410434can_alizations
canonizations2447244can_onizations
colligations1556834co__lligations
collimations1656874co__llimations
colonisations15216174co_lonisations
colonizations24229424co_lonizations
colorizations241410354co_lorizations
complications2147434co_mplications
conciliation1648234concili_ation_
condonations1548004condo__nations
conflations16411144con_fl__ations
conflictions1945224con_fli_ctions
conformations2046724confo_rmations
congelations1549734congel__ations
conglobations1853944con_globations
connotations1447284conno__tations
conscriptions1955004conscri_ptions
consecrations1749214cons_ecrations
conservations1849094cons_ervations
considerations1764844considerations
consignations16105934cons_ignations
consociating1755574consoci_ati_ng
consociational1853544consoci_ational
consolidate1463784consolidat___e
consolidated1663314consolidat__ed
conspiration1648384cons_piration_
constellations1654404constellations
consternations16116044consternations
constipation1648564cons_tipation_
constitutions1554864cons_titutions
constrictions1747784constri_ctions
consultation1447474consul_tation_
consummations1955154cons_ummations
contaminations1886104contaminations
convocations1947364convo__cations
convolutions1745194convol__utions
creolizations2457884c_reolizations
cuspidations1743344c_us_pidations
fossilizations2654684fossilizations
insolations1149184_insol__ations
invalidations1745624_invalidations
monopolizations2893394monopolizations
nonsolutions1254174nonsol__utions
podsolization25165004podsolization_
podzolizations25153874podzolizations
reconsolidating1962014reconsolidati_ng
aerosolizations2453795aerosolizations
aldolizations2346345_aldolizations
anodizations2276925_an_odizations
associations1445755_associ_ations
autoxidations2153555_autoxidations
canalization23411165can_alization_
cancelations1657095cancel__ations
cancellations1754395cancel_lations
canonization2347925can_onization_
cantillations1545735cantil_lations
carbonizations2774955carbonizations
cartelizations2556555cartelizations
castigations1547205c_as_tigations
centralizations26157785centralizations
cephalizations3087595cephalizations
channelizations2962325channelizations
chlorinations1855535c_hlorinations
ciliations121111005c___ili_ations
civilisations1853645c_ivilisations
civilizations2747275c_ivilizations
coagulations1546515coagul__ations
coalifications2155705coalifications
coalitions1247925co__ali__tions
cocainizations2755435cocainizations
cocultivations2152765cocultivations
codifications21127625co_difications
coevolutions1754085coevol__utions
cogitations1448905c___ogitations
cohabitations2053455co_habitations
collations12312855c___ol_lations
colligation1457445co__lligation_
collimation1557575co__llimation_
collocations1646405co__llocations
colonisation14176765co_lonisation_
colonization232010235co_lonization_
colorations13911895c___olorations
colorization231711195co_lorization_
columniations1764795columni_ations
combinations1897915co__mbinations
commendations2055805co_mmendations
comminations18810485co__mminations
communications22105755communications
communizations29126105communizations
compellations1954805compel_lations
compilations1848675co__mpilations
complexations26134015co_mplexations
complication2048205co_mplication_
compositions1846255composi__tions
conations111318905con_____ations
concatenations1873725concatenations
concelebrations21103165concelebrations
concentrations1877075concentrations
conciliating1775615concili_ati_ng
conciliators1695395concili_at_ors
concoctions1448255conco___ctions
concretizations2854035concretizations
condemnations1845405con_demnations
condensations1646275con_densations
conditions13410105con____ditions
condonation1448855condo__nation_
confabulations2162805confabulations
confederations20104605confederations
configurations2063705configurations
confirmations2055675con_firmations
confiscations2044955con_fiscations
conflagrations2052725conflagrations
conflation15412085con_fl__ation_
confliction1845235con_fli_ction_
conformation1947325confo_rmation_
confrontations1962785confrontations
confutations1767795con__futations
congelation14410345congel__ation_
conglobation1754255con_globation_
conglomerations2062735conglomerations
conglutinations1862545conglutinations
congregations17186415con_gregations
conjugations2245865con__jugations
conjurations2148495con__jurations
connations12312945con____nations
conniptions1546035con__ni_ptions
connotation1347985conno__tation_
conscientious17102255cons_cientious
conscription1855335conscri_ption_
consecration1649785cons_ecration_
consecutions1647045cons__ecutions
conservation1749405cons_ervation_
consideration1655525consideration_
consignation15136315cons_ignation_
consociates1546545consoci_at__es
consolatory1684965consol__at_ory
conspirational1853955cons_pirational
conspirators1655535cons_pirat_ors
constellation1554795constellation_
consternation15106365consternation_
constipating1775395cons_tipati_ng
constitution1455265cons_titution_
constriction1648265constri_ction_
constructions1747715cons_tructions
consummation1855295cons_ummation_
consumptions1845145cons__umptions
contamination1766955contamination_
contemplations2074735contemplations
contestations1547735con_testations
continuations1547145con_tinuations
contortions1348685conto___rtions
contradictions1954145contradictions
contributions1754745con_tributions
contritions13410915con_tri__tions
conurbations1646665con__urbations
conversations1847455con_versations
convictions1848045con__vi_ctions
convocation1847885convo__cation_
convolution1645125convol__ution_
cooperations1659195co__operations
coordinations1684995co_ordinations
copulations151111115co_pul__ations
cornifications2145955cornifications
coronations13410705co_ro__nations
corotations1349765co_ro__tations
corporations16129485corpo__rations
correlations1447865correl__ations
corroborations1882615corroborations
covariations1745985co_vari_ations
creolization2348815c_reolization_
cuspidation1643495c_us_pidation_
cyclizations2845755c__yclizations
defoliations1647595_defoli_ations
denominations16117855den_ominations
densifications2046985densifications
deoxidations2145245__deoxidations
desalinations14410185_desalinations
desolations12310595_desol__ations
despoliations1646395despoli_ations
dieselizations2455915dieselizations
disconsolations1863205disconsol__ations
dissociations1656015dissoci_ations
embolizations2646725_embolizations
epoxidations2243645__epoxidations
exfoliations2244785_exfoli_ations
finalizations2549255fin_alizations
fluoridations1783225_fluoridations
focalizations2748995fo_calizations
foliations1399945___foli_ations
formalizations28146985formalizations
fossilization2565145fossilization_
homologations19102345ho_mologations
idolizations2247465__idolizations
inclinations1448755_in_clinations
insanitations13136475_insanitations
inseminations1546245_inseminations
insolation10410215_insol__ation_
inspirations1447305_ins_pirations
instigations1348245_ins_tigations
instillations1344925_instillations
insulations11310235_insul__ations
intimidations1686665_intimidations
intoxications22135685_intoxications
invalidation1646045_invalidation_
ionizations2049895ion___izations
isolations10310695__isol__ations
localizations2449795lo_calizations
mobilizations2687875mo_bilizations
monetizations2467645mon_etizations
mongrelizations2753705mongrelizations
monopolization2793405monopolization_
moralizations24410815mo_ralizations
motorizations2449125mo_torizations
nasalizations2248705_nasalizations
nidations1039215__n___idations
nominations13410535__n_ominations
noncultivations20182755noncultivations
nonimplications21122885nonimplications
nonsolution1154745nonsol__ution_
normalizations25147545normalizations
novelizations2556365no_velizations
obligations1446145_o__bligations
oscillations1445115_o_scillations
ossifications18176145_ossifications
oxidations1845445____oxidations
ozonizations2045315_o_zonizations
penalizations24511635pen_alizations
photooxidations2872745photooxidations
podzolization24194375podzolization_
pollinations1447235po__llinations
pontifications2187915pontifications
randomizations2653685randomizations
reconciliations1953745reconcili_ations
reconsolidates17122225reconsolidat__es
renominations15108305ren_ominations
reoxidations2046045__reoxidations
revalidations1747115_revalidations
robotizations2446345ro_botizations
salivations1448735___salivations
sensitisations1493625sensitisations
sensitizations23126095sensitizations
sensualizations24286205sensualizations
socializations2548485socializations
solations9814625___sol__ations
solmizations2346635___solmizations
solvations1336835___sol_vations
sonications1349955___sonications
spoliations1347695__spoli_ations
symbolizations3053405symbolizations
unionisations1353205_unionisations
unionizations2255315_unionizations
validations1547245___validations
vandalizations2756315vandalizations
vasodilations1752985_vasodilations
vocalizations2749275vo_calizations

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 Filter178691950240.1101624463.6
2DLD Change Limit950242706.73614106.9
3Display Results2702700.1701588.2
 (SQL Overall)1786912707.01625469.1
 
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.