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

196 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
demonstrating1710476(None) 
remonstrating1695551remonstrating
demonstration16126282demonstration
demonstrations1795672demonstrations
demonstrative1964212demonstrative
deconsecrating2053633deconsecrating
deconstructing20113903deconstructing
defenestrating19112543defenestrating
demonstrate14145923demonstrat__e
demonstrated16134893demonstrat_ed
demonstrates15155603demonstrat_es
demonstrational1862633demonstrational
demonstratives2063203demonstratives
demonstrator1573923demonstrat_or
demonstrators1673413demonstrators
denitrating13128333de__nitrating
remonstration15117123remonstration
remonstrations16116483remonstrations
remonstrative1874573remonstrative
administrating1862134administrating
deconcentrating2163084deconcentrating
decorating14312074deco___rating
degenerating1545664degen_erating
demodulating1753164demo_dulating
demonetizing2554174demonet_izing
demonstrable1753184demonstra_ble
demonstrably2052674demonstra_bly
demonstratively24172504demonstratively
denigrating14146924de__nigrating
detonating1248824deton___ating
devastating1644704de_vast_ating
exonerating1945554_exon_erating
menstruating1553864__menstruating
penetrating1447664pe__netrating
prostrating1449394_pro_strating
reconsecrating1954194reconsecrating
reconstructing1974434reconstructing
reinstating1248114re_inst_ating
remonstrant1364634remonstra__nt
remonstrate13146414remonstrat__e
remonstrated15145574remonstrat_ed
remonstrates14146054remonstrat_es
remonstrator1474084remonstrat_or
remonstrators1583564remonstrators
remunerating1545424remun_erating
sequestrating2352314sequestrating
undemonstrative2181684undemonstrative
ammoniating1644065ammon__iating
castrating1349775___castrating
commiserating2053195commiserating
consecrating1747945__consecrating
consorting13410745__consor_ting
consternating1654975__consternating
constipating1775395__constipating
constrain1149335__constra_in_
constraining1554545__constraining
constrains1249725__constra_ins
constraint12411135__constra_int
constricting1747025__constricting
constructing1746755__constructing
construing1347445__constr_uing
contracting16610475__con_tracting
contrasting1459355__con_trasting
deaerating12311565de___aerating
deaminating1547975deamin___ating
debilitating1654115debilit_ating
decapitating1854955decapit_ating
decelerating1645595de_celerating
decentring1446755decen_tr__ing
decerebrating1953205decerebrating
decollating1545965deco__llating
decongesting1753735decon_gesting
deconsecration1954785deconsecration
deconsecrations2064515deconsecrations
deconstruction19134435deconstruction
deconstructions20124365deconstructions
deconstructive22124105deconstructive
decontrolling1761435decon_trolling
decorticating1984245decorticating
decussating1543195de_cus_sating
defenestration18173545defenestration
defenestrations1993305defenestrations
deflagrating1852665de_flagrating
defoliating1645825defo__liating
dehorting1447215deho___r_ting
dehydrating2043655de__hydrating
delectating1545995de_lect_ating
deliberating1645125de_liberating
delineating1346375delin__eating
demarcating1745205dem__arcating
demasting1338455dem_as___ting
dementing13311045demen____ting
demeriting1448685dem___eriting
demitting13239075dem__it__ting
democratic1755895demo__crati_c
democratize2555275demo__cratize
democratizing2853545demo__cratizing
demonetization2655875demonetization
demonetizations2755715demonetizations
demonising1447565demon___ising
demonization24410945demon_ization
demonizations25410245demon_izations
demonizing2348855demon___izing
demonstrability2382255demonstrability
demoting12311425demo_____ting
demounting1444965demo___unting
demyelinating2051625demyelinating
demystifying2551905dem_ystifying
denervating1645925de__nervating
denominating1645695deno_minating
denudating1345265de__n_udating
depopulating1853735depo_pulating
deporting1369595depo___r_ting
depositing1446935depo_s__iting
depurating1438645de___purating
derating103222285de_____rating
derogating1348635dero___gating
desecrating1548095de__secrating
deserting11713145de___ser_ting
desiderating1544695de_siderating
desolating1239465de___solating
destroying1564905de___stroying
destructing1546115de___structing
deteriorating1553395deteriorating
detoxicating2353865deto_xicating
detracting1438715de____tracting
deuterating1347275de__uterating
disrating11714555d___is_rating
distracting1569255d___istracting
domesticating1953025dom_esticating
dominating1449405domin___ating
donating10311805d__on___ating
elongating1244525_elon__gating
emanating1239005_eman___ating
emancipating1952895_emancipating
emendating1444615_emen__dating
emigrating1467505_em__igrating
entreating11811555_e__n_treating
estating92614995_e___st_ating
estraying1338295_e___straying
estreating11710365_e___streating
eventuating1543255_even_tuating
exenterating2054215_exenterating
frustrating1544265__frustrating
geminating1447765gemin___ating
generating12310385ge__n_erating
gestating11229985ge___st_ating
hemostatic1756665hemo_st_ati_c
hemostatics1854725hemo_st_atics
illustrating1372725_illustrating
impetrating1644645_im_petrating
instating10812215___inst_ating
lustrating1147785___lustrating
misrating121014855__m_is_rating
misstarting14125205__misstarting
misstating13129315__misst_ating
mistracing1569605__m_istracing
mistreating1449285__m_istreating
moderating1448805__mo_derating
monograming1754315__monograming
montaging1346545__mon_t_aging
negotiating1344245nego__tiating
nitrating10312675____nitrating
orchestrating1982845orchestrating
outrating10916405___o_utrating
perorating13313135pero___rating
perpetrating1745205pe_rpetrating
postdating1447165__po_stdating
postmating1548605__po_stmating
preponderating2062585preponderating
reconcentrating2063345reconcentrating
reconstituting1763235reconstituting
reconsulting1554215recons_ulting
recontacting1745065recon_tacting
reconverting1876405reconver_ting
regenerating1446335regen_erating
reinitiating1345765re_initiating
reinserting1256905re_inser_ting
remigrating1547595rem__igrating
remoistening1552745remoist_ening
remonetizing2454565remonet_izing
remonstrance1653405remonstra_nce
remonstrances1752995remonstrances
remonstrantly1862275remonstrantly
remonstrants1473535remonstra_nts
remonstratively23172505remonstratively
remotivating1864335remo_tivating
reoperating1449025re_o_perating
resonating11311265reson___ating
restarting11310665re___starting
restating102319415re___st_ating
sensating1039255se__ns__ating
thermostating1972565thermo_st_ating
unconstraint1463565unconstra_int
unstating10711215___unst_ating
venerating14410055ve__n_erating

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901968.22015181.3
3Display Results1961960.1231593.5
 (SQL Overall)1786911968.73320461.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.