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

80 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
unconstructive2110421(None) 
constructive1957442__constructive
deconstructive22124102deconstructive
nonconstructive2293462nonconstructive
reconstructive21124462reconstructive
uninstructive1862942un_instructive
constrictive1956623__constrictive
unconstructed1853923unconstruct_ed
constructible19113754__constructible
constructing1746754__constructing
construction1648084__construction
constructively2463834__constructively
contractive1849524__con_tractive
deconstructing20113904deconstructing
deconstruction19134434deconstruction
inconsecutive2062504inconsecu_tive
instructive1656484___instructive
nonconstruction1983274nonconstruction
nondestructive2072744_n_ondestructive
obstructive1854614___obstructive
reconstructible2172374reconstructible
reconstructing1974434reconstructing
reconstruction1894774reconstruction
unconstricted1853364unconstrict_ed
conductive1848145__con__ductive
consecutive1855945__consecu_tive
conservative20106985__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
deconstruct1654145deconstruct___
deconstructed1953705deconstruct_ed
deconstructions20124365deconstructions
deconstructor1863645deconstruct_or
deconstructors1963625deconstructors
deconstructs1753715deconstruct__s
demonstrative1964215demonstr_ative
destructive1755695___destructive
misconstruction2162705misconstruction
nonconductive2164645noncon__ductive
nonconsecutive2173025nonconsecu_tive
nonconservative2372845nonconservative
nondeductive1953765_n_ondeductive
nondirective1854685_n_ondirective
noninductive1854215_n_oninductive
nonrestrictive1972595_n_onrestrictive
nonselective1755415_n_onselective
nonstructured1663445_n_onstructured
obstructives1953915___obstructives
reconstruct1554905reconstruct___
reconstructed1854265reconstruct_ed
reconstructions19124735reconstructions
reconstructor1764095reconstruct_or
reconstructors1863935reconstructors
reconstructs1654245reconstruct__s
remonstrative1874575remonstr_ative
unattractive1752425un__attractive
uncoercive1753005unco__er_c_ive
unconstrained1662485unconstr__ained
unconstraint1463565unconstr__aint
uncontracted17154145uncon_tract_ed
uncontrived1753615uncon_tr___ived
uncooperative2083105uncooper_ative
undemonstrative2181685undemonstr_ative
uninstructed1552755un_instruct_ed
unobstructed1752275un_obstruct_ed
unobtrusive1661445un_o_btru_sive
unreconstructed2081735unreconstruct_ed

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.343520965.0
2DLD Change Limit95024807.20313192.3
3Display Results80800.0461739.1
 (SQL Overall)178691807.59223536.7
 
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.