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

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

77 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
deconstructive2212410(None) 
reconstructive21124461reconstructive
constructive1957442__constructive
deconstructing20113902deconstructing
deconstruction19134432deconstruction
unconstructive21104212unconstructive
constrictive1956623__constrictive
deconstruct1654143deconstruct___
deconstructed1953703deconstruct_ed
deconstructions20124363deconstructions
deconstructor1863643deconstruct_or
deconstructors1963623deconstructors
deconstructs1753713deconstruct__s
demonstrative1964213demonstr_ative
destructive1755693de___structive
nonconstructive2293463nonconstructive
reconstructible2172373reconstructible
reconstructing1974433reconstructing
reconstruction1894773reconstruction
constructible19113764__constructible
constructing1746754__constructing
construction1648084__construction
constructively2463844__constructively
contractive1849524__con_tractive
demonstratives2063204demonstr_atives
instructive1656484___instructive
obstructive1854614___obstructive
reconstruct1554904reconstruct___
reconstructed1854264reconstruct_ed
reconstructions19124734reconstructions
reconstructor1764094reconstruct_or
reconstructors1863934reconstructors
reconstructs1654244reconstruct__s
remonstrative1874574remonstr_ative
uninstructive1862944_uninstructive
conductive1848145__con__ductive
consecutive1855955__consecu_tive
conservative20106995__conservative
constative15410105__const__ative
constitutive1754105__constitutive
constricting1747025__constricting
constriction1648265__constriction
construct1358715__construct___
constructed1646255__construct_ed
constructions1747715__constructions
constructivism23213685__constructivism
constructivist21214195__constructivist
constructor1576525__construct_or
constructors1676475__constructors
constructs1457055__construct__s
consultive1546675__cons__ultive
contractile1547355__con_tractile
contrastive1647295__con_trastive
decoctive1745865deco_____ctive
decongestive1952395decon__gestive
decorative1648925deco___r_ative
demonstrate14145925demonstr_at__e
demonstrating17104765demonstr_ating
demonstration16126285demonstr_ation
demonstratively24172505demonstr_atively
destructible1752785de___structible
destructing1546115de___structing
destruction1446955de___struction
destructively2253925de___structively
detractive1647375de____tractive
distractive1746775d___istractive
inconsecutive2062505inconsecu_tive
misconstruction2162705misconstruction
neoconservative2371655neoconservative
nonconstruction1983275nonconstruction
nondestructive2072745nondestructive
obstructives1953915___obstructives
preconstructed21102715preconstruct_ed
restrictive1646365re___strictive
technostructure2281535technostructure
unconstructed1853925unconstruct_ed
undemonstrative2181685undemonstr_ative

Search took 8 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.420425454.8
2DLD Change Limit95024776.94013692.2
3Display Results77770.0461673.9
 (SQL Overall)178691777.40624127.9
 
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.