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

218 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
constellation155479(None) 
constellations1654401constellations
constellating1653262constellating
consternation15106362consternation
cancellation1655013can_cellation
cantillation1446693can_tillation
compellation1855103co_mpellation
congelation14410343con_ge_lation
consecration1649783cons_ecration
conservation1749403cons_ervation
consolation13410983cons__olation
constellate13114563constellat__e
constellated15113573constellat_ed
constellates14174233constellat_es
constellatory1862593constellatory
consternations16116043consternations
constipation1648563const_ipation
consultation1447473cons_ultation
contemplation1985263con_templation
contestation1448663con_testation
installation1254903_installation
instillation1245843_instillation
cancelation1547774can_ce_lation
cancellations1754394can_cellations
cantillations1545734can_tillations
collation11313994co____llation
compellations1954814co_mpellations
concatenation1764094concate_nation
conciliation1648234con_ciliation
condemnation1746044con_demnation
condensation1546784con_densation
confabulation2063304confabulation
conflation15412084con___flation
congelations1549734con_ge_lations
congregation16226764congre_gation
consecrations1749214cons_ecrations
consecution1547304cons_e_cution
conservations1849094cons_ervations
consideration1655524consideration
consignation15136314cons_ignation
consociation1648194cons_ociation
consolations1449744cons__olations
consolidation1655154consolidation
conspiration1648384cons_piration
consternating1654974consternating
constipations1747684const_ipations
constitution1455264const_itution
constriction1648264const_riction
construction1648084const_ruction
consultations1546934cons_ultations
consummation1855294cons_ummation
contemplations2074734con_templations
contention12412224con_te__ntion
contestations1547734con_testations
continuation1448194con_tinuation
conversation1747804con_versation
correlation1358554co_rre_lation
crenellation1453914c_renellation
cupellation1544144c__upellation
distillation1347734_distillation
installations1354224_installations
instillations1344924_instillations
oscillation1345494_o_scillation
ostentation1146964_o_stentation
postelection1654544po_stelection
postulation13119134po_st_ulation
reinstallation1462434reinstallation
scintillation1593004scin_tillation
tessellation1252754_tessellation
appellation1564125__appellation
blastulation1452595blast_ulation
cancelations1657095can_ce_lations
cantillating1565045can_tillating
capitulation1644595capit_ulation
cartelization2456995c_artelization
caseation1199515c_as_e__ation
castellan1144345c_astella___n
castellated1443275c_astellat_ed
castigation1447975c_ast_igation
castration12410805c_ast__ration
catenation1249525c__ate_nation
centillion1254465cen_till__ion
chelation1439965c___he_lation
coacervation1964275co_acervation
coagulation1447275co__agulation
coaptation1448345coapt___ation
cogeneration1546445cogene_ration
cogitation13410085cogit___ation
collations12312855co____llations
commendation1946515co_mmendation
compensation18126505co_mpensation
compilation1749315co__mpilation
complexation25144245comple_xation
conation101420885con_____ation
concatenations1873725concate_nations
concelebration20133565concelebration
concentration1758015concentration
conception16410455con_ce__ption
conciliations1747205con_ciliations
concretion1449295concre___tion
concretization2754375concretization
condemnations1845405con_demnations
condensations1646275con_densations
condonation1448855con__donation
confabulations2162805confabulations
confection17411185con_fe__ction
confederation1995255confederation
configuration1954135configuration
confirmation1946185con_firmation
confiscation1945535con_fiscation
conflagration1953015conflagration
conflations16411145con___flations
confliction1845235con__fliction
conformation1947325con_formation
confrontation1853225confrontation
confutation1668725con__futation
congestion1349045con_ge__stion
conglobation1754255con_globation
congratulation1782825congratulation
congregations17186415congre_gations
conjugation2146625con__jugation
conjuration2049515con__juration
connation11314265con____nation
connection14410535con_ne__ction
connotation1347985con__notation
conscription1855335cons_cription
consecrating1747945cons_ecrating
consecrative1957315cons_ecrative
consecrator1546385cons_ecrat_or
consecutions1647045cons_e_cutions
conservational1955345cons_ervational
conservatism19104955cons_ervatism
conservative20106995cons_ervative
conservatize26125505cons_ervatize
conservator1656375cons_ervat_or
considerations1764845considerations
consignations16105935cons_ignations
consociations1747515cons_ociations
consolidations1754745consolidations
conspirations1747725cons_pirations
constative15410105const___ative
consternate1355125consternat__e
consternated1554115consternat_ed
consternates1455055consternat_es
constipating1775395const_ipating
constitutions1554865const_itutions
constrain1149335const__ra_i_n
constrictions1747785const_rictions
constructions1747715const_ructions
consultative1754785cons_ultative
consummations1955155cons_ummations
consumption1745425cons__umption
contagion1246995con_t___agion
contamination1766955contamination
contemplating2054125con_templating
contemplative22123705con_templative
contemplator1853735con_templat_or
contentions13412095con_te__ntions
continuations1547145con_tinuations
contortion1248665con_t__ortion
contraction15411245con_t_raction
contraption1548105con_t_raption
contribution1655095con_tribution
contrition12411415con_t__rition
conurbation1547465con__urbation
convection17411125con_ve__ction
convention15410565con_ve__ntion
conversations1847455con_versations
convocation1847885con__vocation
convolution1645125con__volution
cooperation15410025co_ope_ration
copulation141111955co___pulation
corotation12410975corot___ation
correlations1447865co_rre_lations
cotillion1145285co__till__ion
counteraction1755385counteraction
crenelation1346855c_rene_lation
crenellations1553575c_renellations
crystallization2962245crystallization
cunctation1476915cunct___ation
cupellations1643805c__upellations
deconsecration1954785decons_ecration
disrelation1248815_disre_lation
distillations1446945_distillations
fellation1238845____fellation
flagellation1652895_flagellation
gastrulation1353835_gastrulation
inosculation1445275inos_culation
insolation10410215_ins__olation
instauration12114835_instauration
instigation1249245_inst_igation
insufflation18112875_insufflation
insulation10311665_ins__ulation
integration121310495_in_tegration
intellection1466165_in_tellection
menstruation1455225menst_ruation
monetization2358125monet_ization
mongrelization2653735mongrelization
nonelection1347205non__election
nonregulation1473905nonregulation
nonsolution1154745nons__olution
observation1665065_obs_ervation
oscillations1445115_o_scillations
osculation1249675_o_s_culation
ostentations1246125_o_stentations
postillion1255635po_still__ion
postisolation1553565po_stisolation
postulations14127735po_st_ulations
pustulation13116625_pust_ulation
reconsecration1885565recons_ecration
redistillation1563035redistillation
reinstallations1562155reinstallations
scintillations1662755scin_tillations
spallation1247025___spallation
sustentation1255025_sustentation
tessellations1352615_tessellations
titillation1145045__titillation
ventilation1448165ven_t_ilation

Search took 10 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 Limit1247902188.65614416.6
3Display Results2182180.1401557.1
 (SQL Overall)1786912189.18619452.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.