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

104 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
demonstrators167341(None) 
demonstrator1573921demonstrator_
remonstrators1583561remonstrators
demonstrates15155602demonstrat_es
demonstrations1795672demonstrations
remonstrator1474082remonstrator_
deconstructors1963623deconstructors
demonstrate14145923demonstrat__e
demonstrated16134893demonstrat_ed
demonstrating17104763demonstrating
demonstration16126283demonstration
demonstrative1964213demonstrative
demonstratives2063203demonstratives
remonstrates14146053remonstrat_es
remonstrations16116483remonstrations
administrators1761714administrators
deconstructor1863644deconstructor_
decorators1347874deco___rators
demodulators1652294demo_dulators
demonstrable1753184demonstra_ble
demonstrably2052674demonstra_bly
demonstrational1862634demonstrational
denigrators1344524de__nigrators
detonators1145854deton___ators
devastators1552924de_vast_ators
reconstructors1863934reconstructors
remonstrances1752994remonstrances
remonstrants1473534remonstra_nts
remonstrate13146414remonstrat__e
remonstrated15145574remonstrat_ed
remonstrating1695554remonstrating
remonstration15117124remonstration
remonstrative1874574remonstrative
remunerators1453664remun_erators
administrator1661975administrator_
castrators1247445___castrators
coconspirators2061435coconspirators
consecrators1656055__consecrators
conservators1755975__conservators
conspirators1655535__conspirators
constrictors1676015__constrictors
constructors1676475__constructors
contractors1549165__con_tractors
deaerators11107715de___aerators
decapitators1753265decapit_ators
decelerators1553495de_celerators
deconsecrates1894045deconsecrat_es
deconsecrations2064515deconsecrations
deconstructions20124365deconstructions
deconstructs1753715deconstr_ucts
decontrols1353125decon_tr__ols
decorator1248575deco___rator_
decorticators1862495decorticators
defenestrates1762465defenestrat_es
defenestrations1993305defenestrations
defoliators1543725defo__liators
dehydrators1952855de__hydrators
delineators1253965delin__eators
democrats1446205demo__crat__s
demodulator1552515demo_dulator_
demonetizations2755715demonetizations
demonizations25410245demon_izations
demonstratively24172505demonstratively
denigrator1245225de__nigrator_
denigratory1653515de__nigratory
denitrates1169515de__nitrat_es
denominators1574095deno_minators
depositors1344035depo_s__itors
depurators1346485de___purators
desecrators1445235de__secrators
desolators1146285de___solators
detonator1045985deton___ator_
detractors13147295de____tractors
devastator1453145de_vast_ator_
dominators1397485domin___ators
donators9310405d__on___ators
downstaters1552075d_ownst_aters
emanators1147035_eman___ators
emancipators1852515_emancipators
emendators1344205_emen__dators
generators1147535ge__n_erators
hemostatics1854725hemo_st_atics
hemostats1446395hemo_st_at__s
illustrators1252005_illustrators
moderators1386645__mo_derators
monstrances1545015__monstrances
monstrous1187355__monstr__ous
negotiators1253165nego__tiators
nitrators949215____nitrators
nonstarters1153655__nonstarters
orchestrators1872655orchestrators
perorators1249355pero___rators
perpetrators1653395pe_rpetrators
reconstructor1764095reconstructor_
regenerators1353835regen_erators
remonstrance1653405remonstra_nce
remonstrant1364635remonstra__nt
remonstrantly1862275remonstrantly
remunerator1353875remun_erator_
remuneratory1752905remun_eratory
resonators1045815reson___ators
testators947335te___st_ators
undemonstrative2181685undemonstrative
venerators1347065ve__n_erators

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 Limit1247901049.25013490.8
3Display Results1041040.0631650.8
 (SQL Overall)1786911049.70318416.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.