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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
nonconstructive229346(None) 
nonconstruction1983272nonconstruction
unconstructive21104212_unconstructive
constructive1957443___constructive
deconstructive22124103_deconstructive
nonconductive2164643noncon__ductive
nonconsecutive2173023nonconsecu_tive
nonconservative2372843nonconservative
nondestructive2072743non_destructive
reconstructive21124463_reconstructive
constrictive1956624___constrictive
nonconsumptive2372384noncons_umptive
nonrestrictive1972594non_restrictive
uninstructive1862944_un_instructive
concentrative2056215concen_tr_ative
constructible19113755___constructible
constructing1746755___constructing
construction1648085___construction
constructively2463835___constructively
contractive1849525___con_tractive
deconstructing20113905_deconstructing
deconstruction19134435_deconstruction
inconsecutive2062505_inconsecu_tive
instructive1656485____instructive
misconstruction2162705misconstruction
neoconservative2371655neoconservative
noncoercive1854395nonco__er_c_ive
nonconducting1963585noncon__ducting
nonconduction1884475noncon__duction
nonconservation2063095nonconservation
noncontract1585585noncon_tract___
noncontractual1882145noncon_tractual
noncooperative21113475noncooper_ative
nondisruptive1962205non_dis_ruptive
nondistinctive2071915non_distinctive
noninductive1854215non_in__ductive
noninteractive1973025non_interactive
nonintrusive1562385non_in_tru_sive
nonintuitive1563635non_in_t_uitive
nonnutritive1563145non__nutr_itive
obstructive1854615____obstructive
reconstructible2172375_reconstructible
reconstructing1974435_reconstructing
reconstruction1894775_reconstruction
unconstructed1853925_unconstruct_ed
concoctive1646806conco_____ctive
conductive1848146___con__ductive
consecutive1855946___consecu_tive
conservative20106986___conservative
constative15410106___const__ative
constitutive1754106___constitutive
constricting1747026___constricting
constriction1648266___constriction
construct1358716___construct___
constructed1646256___construct_ed
constructions1747716___constructions
constructivism23213686___constructivism
constructivist21214196___constructivist
constructor1576526___construct_or
constructors1676476___constructors
constructs1457056___construct__s
consultive1546676___cons__ultive
contractile1547356___con_tractile
contrastive1647296___con_trastive
deconstruct1654146_deconstruct___
deconstructed1953706_deconstruct_ed
deconstructions20124366_deconstructions
deconstructor1863646_deconstruct_or
deconstructors1963626_deconstructors
deconstructs1753716_deconstruct__s
demonstrative1964216_demonstr_ative
destructive1755696____destructive
nonabsorptive2061866non_absor_ptive
nonassertive1553466non_asser__tive
noncognitive1863766nonco___gnitive
noncombative2154446nonco___mbative
noncommutative2362636nonco_mmutative
noncompetitive2362786nonco_mpetitive
nonconductor1783566noncon__duct_or
nonconductors1873276noncon__ductors
nonconflicting2261926noncon_flicting
nonconformities2273066nonconformities
nonconnection1784416noncon__nection
nonconstant1355876nonconst_ant___
nonconsuming1753216noncons__u_ming
nonconsumption20112486noncons_umption
noncontact1485946noncon_t_act___
noncontrolling1771746noncon_trolling
nonconvertible21113126nonconver__tible
noncorrosive1762776nonco___rrosive
noncreative1648236nonc____reative
nondeductive1953766__n_ondeductive
nondescriptive2261976non_descriptive
nondirective1854686__n_ondirective
noninfective2054586non_in__fective
nonnarrative1553836non__n_arrative
nonnormative1754866non__n_ormative
nonobjective2663546non_o__bjective
nonoperative1756286non_o_per_ative
nonproductive2193396non__productive
nonreproductive2371716nonreproductive
nonretractile1562406non__retractile
nonretroactive1962036non__retroactive
nonselective1755416__n_onselective
nonsensitive1564956nonsens___itive
nonstructured1663446__n_onstructured
obstructives1953916____obstructives
preconstructed21102716preconstruct_ed
reconstruct1554906_reconstruct___
reconstructed1854266_reconstruct_ed
reconstructions19124736_reconstructions
reconstructor1764096_reconstruct_or
reconstructors1863936_reconstructors
reconstructs1654246_reconstruct__s
remonstrative1874576_remonstr_ative
unconstricted1853366_unconstrict_ed
undemonstrative2181686undemonstr_ative
unreconstructed2081736unreconstruct_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.360496363.9
2DLD Change Limit950241186.62314347.6
3Display Results1181180.0761552.6
 (SQL Overall)1786911187.05925313.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.