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 “undemonstrativea” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
undemonstrative2181681undemonstrative_
demonstrative1964213__demonstrative_
demonstratives2063203__demonstratives
demonstratively24172504__demonstratively
remonstrative1874574__remonstrative_
demonstrate14145925__demonstrat__e_
demonstrated16134895__demonstrat__ed
demonstrates15155605__demonstrat__es
demonstrating17104765__demonstrati_ng
demonstration16126285__demonstrati_on
demonstrational1862635__demonstrational
demonstrations1795675__demonstrations
indemonstrable19111845indemonstra_ble_
remonstratively23172505__remonstratively
administrative2072156_ad_ministrative_
deconstructive22124106__deconstructive_
demonstrable1753186__demonstra_ble_
demonstrator1573926__demonstrat__or
demonstrators1673416__demonstrat_ors
indemonstrably22121606indemonstra__bly
remonstrate13146416__remonstrat__e_
remonstrated15145576__remonstrat__ed
remonstrates14146056__remonstrat__es
remonstrating1695556__remonstrati_ng
remonstration15117126__remonstrati_on
remonstrations16116496__remonstrations
unconstrained1662486un__constra_ined
unconstructive21104216un__constructive_
undemocratic1962116undemo__crati__c
concentrative2056217conce__n_trative_
constative15410107____const_ative_
constatives1646937____const_atives
decorative1648927__deco___rative_
degenerative1754967__degen_erative_
democratize2555277__demo__cratize_
democratized2753767__demo__cratized
democratizer2653347__demo__cratizer
democratizes2654317__demo__cratizes
demonstrability2382257__demonstrability
demonstrably2052677__demonstra__bly
denigrative1655487__de__nigrative_
denotative1456727__de__not_ative_
detonative1447137__deton___ative_
devastative1853437__de_vast_ative_
exonerative2155397___exon_erative_
interoperative1974367intero_perative_
neoconservative2371657_neoconservative_
nonconservative2372847_nonconservative_
nonconstructive2293467_nonconstructive_
penetrative1646117__pe__netrative_
reconstructive21124467__reconstructive_
remonstrance1653407__remonstra_nce_
remonstrances1752997__remonstra_nces
remonstrator1474087__remonstrat__or
remonstrators1583567__remonstrat_ors
remunerative1754767__remun_erative_
unconstraint1463567un__constra_i_nt
unconstraints1561917un__constra_ints
uncontrived1753617un__con_tr__ived
uncooperative2083107un__cooperative_
undecorated1545727undeco___rat__ed
underactive1745967unde_____ractive_
undernutrition15192057unde_rnutriti_on
undernutritions16191907unde_rnutritions
understate1148867unde__rst_at__e_
understated1347847unde__rst_at__ed
understates1247707unde__rst_at__es
understating1446547unde__rst_ati_ng
understrapper1861997unde__rstra_pper
uninstructive1862947un___instructive_
unreconstructed2081737unreconstr_ucted
unrestrained1353287unre___stra_ined

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 Filter178691950240.360496363.9
2DLD Change Limit95024728.20311584.1
3Display Results72720.0461565.2
 (SQL Overall)178691728.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.