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

204 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
constellating165326(None) 
constellation1554802constellation
constellations1654402constellations
consternating1654972consternating
cantillating1565053can_tillating
consecrating1747943cons_ecrating
constellate13114563constellat__e
constellated15113573constellat_ed
constellates14174233constellat_es
constellatory1862593constellatory
constipating1775393const_ipating
contemplating2054123con_templating
collating12312784co____llating
concatenating1853264concate_nating
conciliating1775624con_ciliating
confabulating21102724confabulating
conflating16410004con___flating
congregating1754284congre_gating
consenting13313224cons_e__nting
consociating1755574cons_ociating
consolidating1753284consolidating
consternation15106364consternation
consternations16116044consternations
constituting1554654const_ituting
constricting1747024const_ricting
constructing1746754const_ructing
consulting1349084cons__ul_ting
consummating1953664cons_ummating
contenting13313324con_te__nting
contesting13312214con_te__sting
corelating13511584co__re_lating
correlating1487084co_rre_lating
counselling1444404couns_ell__ing
hostelling1446164ho_stell__ing
oscillating1443984_o_scillating
postulating1447504po_st_ulating
scintillating1662194scin_tillating
tessellating1352184_tessellating
antedating1277555_an_te_dating
cancellation1655025can_cellation
cancellations1754395can_cellations
cancelling1547215can_cell__ing
cannulating1446015can__nulating
cantillation1446695can_tillation
cantillations1545735can_tillations
canulating1349555can___ulating
capitulating1773975capit_ulating
caseating12311745c_as_e__ating
castellan1144355c_astella__n_
castellans1243585c_astella__ns
castellated1443275c_astellat_ed
castigating1546005c_ast_igating
castrating1349775c_ast__rating
catenating1348685c__ate_nating
cellaring1238535c____ellaring
chelating1549365c___he_lating
chiselling1644685chis_ell__ing
coagulating1545075co__agulating
coattesting1443455coatte__sting
cocreating15310295co_cre__ating
coequating2245325co___equating
cogitating1447215cogit___ating
collaging1337935co____llaging
collaring12310565co____llaring
colleting12311065co____lleting
commentating1957045co_mmentating
compellation1855105co_mpellation
compellations1954815co_mpellations
compelling1746555co_mpell__ing
compensating1955005co_mpensating
concealing1549305con_ce__aling
conceiting15311775con_ce__iting
concelebrating2172595concelebrating
concentrating1856435concentrating
concerting15313895con_ce__rting
concreting1539875concre___ting
confecting18310555con_fe__cting
confederating2054015confederating
confiscating2053615con_fiscating
conflicting1944725con__flicting
congealing1447635con_ge__aling
congelation14410345con_ge_lation
congelations1549735con_ge_lations
congesting14410115con_ge__sting
conglobating1853165con_globating
congratulating1862145congratulating
conjugating2244505con__jugating
connecting15310385con_ne__cting
conscripting1954025cons_cripting
consecration1649785cons_ecration
consecrations1749215cons_ecrations
consecrative1957315cons_ecrative
conservation1749405cons_ervation
conservations1849095cons_ervations
conservatism19104955cons_ervatism
conservative20106995cons_ervative
conservatize26125505cons_ervatize
conservatizing2983095cons_ervatizing
conserving1639765cons_e__rving
consisting1349525cons___isting
consolation13410985cons__olation
consolations1449745cons__olations
consoling12310875cons__ol__ing
consorting13410745cons___orting
constative15410105const___ative
consternate1355125consternat__e
consternated1554115consternat_ed
consternates1455055consternat_es
constipation1648565const_ipation
constipations1747685const_ipations
constrain1149335const__ra_in_
constraining1554545const_raining
constrains1249735const__ra_ins
constraint12411135const__ra_int
constringing1653565const_ringing
construing1347445const___ruing
consultation1447475cons_ultation
consultations1546935cons_ultations
consultative1754785cons_ultative
contacting15610075con_t__acting
contaminating1854915contaminating
contemning1577065con_te__mning
contemplation1985265con_templation
contemplations2074735con_templations
contemplative22123705con_templative
contending1449125con_te__nding
contestation1448665con_testation
contestations1547745con_testations
contorting13410105con_t__orting
contracting16610475con_t_racting
contrasting1459355con_t_rasting
contributing1754305con_tributing
controlling1445425con_trol_ling
convecting18310435con_ve__cting
conventing16311545con_ve__nting
converting16313135con_ve__rting
convoluting1744205con__voluting
cooperating1648425co_ope_rating
copulating1549375co___pulating
corbelling1546715co_rbell__ing
cordelling1446385co_rdell__ing
corotating1349325corot___ating
corseting12312175cors_e___ting
cosseting1239545co_sse___ting
counseling1345465couns_e_l__ing
counsellings1552115couns_ell__ings
counteracting1856285counteracting
counterstating1755195counterstating
crenelating1445515c_rene_lating
crystallising1982835crystallising
crystallizing2883205crystallizing
deconsecrating2053635decons_ecrating
fellating1339255____fellating
flagellating1772435_flagellating
foretelling1543595foretell__ing
fosterling1445175fo_sterl__ing
gastrulating1482995_gastrulating
hanselling1445625hans_ell__ing
hosteling1337895ho_ste_l__ing
houselling1445755hous_ell__ing
inosculating1553815inos_culating
insolating1149155_ins__olating
installation1254915_installation
installations1354225_installations
installing1146405_install__ing
instating10812215_inst___ating
instigating1347155_inst_igating
instillation1245855_instillation
instillations1344925_instillations
instilling1145805_instill__ing
insufflating1952005_insufflating
insulating1139265_ins__ulating
integrating1349495_in_tegrating
interlacing1449055_in_terlacing
interlaying1547575_in_terlaying
menstruating1553865menst_ruating
misrelating1447275_misre_lating
morselling1346325mors_ell__ing
nondepleting1652855non_depleting
nonoperating1555415nonope_rating
nonpolluting1552045non_polluting
nonspeaking1853195nonspe__aking
nonyellowing195975non_yellowing
obsecrating1644135_obs_ecrating
osculating1347385_o_s_culating
outbleating1444885_o_utbleating
outeating10814495_o_ute__ating
outfloating1544365_o_utfloating
outselling1188025_outsell__ing
outtelling11107135_outtell__ing
postdating1447165po_st__dating
postediting1554455po_ste_diting
postmating1548605po_st__mating
pustulating1445245_pust_ulating
reconsecrating1954195recons_ecrating
tesselating1243845_tesse_lating
tinselling1145525tins_ell__ing
titillating1243715__titillating
unseating10713205_uns_e__ating
unselling10810335_uns_ell__ing
unshelling1445595_unshell__ing
unstating10711215_unst___ating
unsteeling1145185_unsteel__ing
ventilating1546345ven_t_ilating

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.403443402.0
2DLD Change Limit1247902048.79614187.1
3Display Results2042040.1261619.0
 (SQL Overall)1786912049.32519162.6
 
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.