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

214 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
constellations165440(None) 
constellation1554791constellation_
constellating1653262constellati_ng
consternations16116042consternations
cancellations1754393can_cellations
cantillations1545733can_tillations
compellations1954803co_mpellations
congelations1549733con_ge_lations
consecrations1749213cons_ecrations
conservations1849093cons_ervations
consolations1449733cons__olations
constellates14174233constellat__es
constellatory1862593constellat_ory
consternation15106363consternation_
constipations1747683const_ipations
consultations1546933cons_ultations
contemplations2074733con_templations
contestations1547733con_testations
installations1354223_installations
instillations1344923_instillations
cancelations1657094can_ce_lations
cancellation1655014can_cellation_
cantillation1446694can_tillation_
collations12312854co____llations
compellation1855104co_mpellation_
concatenations1873724concate_nations
conciliations1747204con_ciliations
condemnations1845404con_demnations
condensations1646274con_densations
confabulations2162804confabulations
conflations16411144con___flations
congelation14410344con_ge_lation_
congregations17186414congre_gations
consecration1649784cons_ecration_
consecutions1647044cons_e_cutions
conservation1749404cons_ervation_
considerations1764844considerations
consignations16105934cons_ignations
consociations1747514cons_ociations
consolation13410984cons__olation_
consolidations1754744consolidations
conspirations1747724cons_pirations
constellate13114564constellat___e
constellated15113574constellat__ed
consternating1654974consternati_ng
constipation1648564const_ipation_
constitutions1554864const_itutions
constrictions1747784const_rictions
constructions1747714const_ructions
consultation1447474cons_ultation_
consummations1955154cons_ummations
contemplation1985264con_templation_
contentions13412094con_te__ntions
contestation1448664con_testation_
continuations1547144con_tinuations
conversations1847454con_versations
correlations1447864co_rre_lations
crenellations1553574c_renellations
cupellations1643804c__upellations
distillations1446944_distillations
installation1254904_installation_
instillation1245844_instillation_
oscillations1445114_o_scillations
ostentations1246124_o_stentations
postulations14127734po_st_ulations
reinstallations1562154reinstallations
scintillations1662754scin_tillations
tessellations1352614_tessellations
appellations1643535__appellations
blastulations1552265blast_ulations
cancelation1547775can_ce_lation_
cantillating1565045can_tillati_ng
capitulations1754065capit_ulations
cartelizations2556555c_artelizations
caseations1258305c_as_e__ations
castellans1243585c_astella___ns
castigations1547205c_ast_igations
castrations13410055c_ast__rations
catenations1348365c__ate_nations
centillions1353975cen_till__ions
chelations1539075c___he_lations
coacervations2053875co_acervations
coagulations1546515co__agulations
coaptations1547545coapt___ations
cogenerations1655915cogene_rations
cogitations1448905cogit___ations
collation11313995co____llation_
commendations2055805co_mmendations
compensations19136185co_mpensations
compilations1848675co__mpilations
complexations26134015comple_xations
conations111318905con_____ations
concatenation1764095concate_nation_
concelebrations21103165concelebrations
concentrations1877075concentrations
conceptions17410595con_ce__ptions
conciliation1648235con_ciliation_
concretions1549295concre___tions
concretizations2854035concretizations
condemnation1746045con_demnation_
condensation1546785con_densation_
condonations1548005con__donations
confabulation2063305confabulation_
confections18411395con_fe__ctions
confederations20104605confederations
configurations2063705configurations
confirmations2055675con_firmations
confiscations2044955con_fiscations
conflagrations2052725conflagrations
conflation15412085con___flation_
conflictions1945225con__flictions
conformations2046725con_formations
confrontations1962785confrontations
confutations1767795con__futations
congestions1449315con_ge__stions
conglobations1853945con_globations
congratulations1882785congratulations
congregation16226765congre_gation_
conjugations2245865con__jugations
conjurations2148495con__jurations
connations12312945con____nations
connections15410705con_ne__ctions
connotations1447285con__notations
conscriptions1955005cons_criptions
consecrating1747945cons_ecrati_ng
consecrators1656055cons_ecrat_ors
consecution1547305cons_e_cution_
conservational1955335cons_ervational
conservationist2084025cons_ervationist
conservatisms2083535cons_ervatisms
conservatives2195195cons_ervatives
conservatizes27114455cons_ervatizes
conservators1755975cons_ervat_ors
consideration1655525consideration_
consignation15136315cons_ignation_
consociation1648195cons_ociation_
consolidation1655155consolidation_
conspiration1648385cons_piration_
constatives1646935const___atives
consternates1455055consternat__es
constipating1775395const_ipati_ng
constitution1455265const_itution_
constrains1249725const__ra_i_ns
constriction1648265const_riction_
construction1648085const_ruction_
consummation1855295cons_ummation_
consumptions1845145cons__umptions
contagions1346605con_t___agions
contaminations1886105contaminations
contemplating2054125con_templati_ng
contemplatives23122775con_templatives
contemplators1953575con_templat_ors
contention12412225con_te__ntion_
contentious1347015con_te__ntious
continuation1448195con_tinuation_
contortions1348685con_t__ortions
contractions16410405con_t_ractions
contraptions1647645con_t_raptions
contributions1754745con_tributions
contritions13410915con_t__ritions
conurbations1646665con__urbations
convections18411495con_ve__ctions
conventions16410535con_ve__ntions
conversation1747805con_versation_
convocations1947365con__vocations
convolutions1745195con__volutions
cooperations1659195co_ope_rations
copulations151111115co___pulations
corotations1349765corot___ations
correlation1358555co_rre_lation_
cotillions1244785co__till__ions
counteractions1855025counteractions
crenelations1446185c_rene_lations
crenellation1453915c_renellation_
cunctations1576155cunct___ations
cupellation1544145c__upellation_
deconsecrations2064515decons_ecrations
disrelations1348505_disre_lations
distillation1347735_distillation_
fellations1338065____fellations
flagellations1752235_flagellations
gastrulations1463645_gastrulations
inosculations1554425inos_culations
insolations1149185_ins__olations
instaurations13114255_instaurations
instigations1348245_inst_igations
insufflations19112625_insufflations
insulations11310235_ins__ulations
integrations13129475_in_tegrations
intellections1565385_in_tellections
menstruations1585055menst_ruations
monetizations2467645monet_izations
mongrelizations2753705mongrelizations
nonelections1456385non__elections
nonsolutions1254175nons__olutions
observations1785015_obs_ervations
oscillation1345495_o_scillation_
osculations1348375_o_s_culations
ostentation1146965_o_stentation_
ostentatious1252865_o_stentatious
postelection1654545po_stelection_
postillions1354555po_still__ions
postulation13119135po_st_ulation_
pustulations14115625_pust_ulations
reconsecrations1995105recons_ecrations
redistillations1672915redistillations
reinstallation1462435reinstallation_
scintillation1593005scin_tillation_
spallations1356105___spallations
sustentations1354785_sustentations
tessellation1252755_tessellation_
titillations1244445__titillations
unostentatious1461125unostentatious
ventilations1547405ven_t_ilations

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.1231452772.4
2DLD Change Limit950242147.58012536.1
3Display Results2142140.1401528.6
 (SQL Overall)1786912147.84322783.5
 
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.