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

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

95 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
constructive195744(None) 
constrictive1956621constrictive
constructible19113762constructible
constructing1746752constructing
construction1648082construction
constructively2463842constructively
contractive1849522con_tractive
deconstructive22124102deconstructive
instructive1656482_instructive
obstructive1854612_obstructive
reconstructive21124462reconstructive
unconstructive21104212unconstructive
conductive1848143con__ductive
consecutive1855953consecu_tive
conservative20106993conservative
constative15410103const__ative
constitutive1754103constitutive
constricting1747023constricting
constriction1648263constriction
construct1358713construct___
constructed1646253construct_ed
constructions1747713constructions
constructivism23213683constructivism
constructivist21214193constructivist
constructor1576523construct_or
constructors1676473constructors
constructs1457053construct__s
consultive1546673cons__ultive
contractile1547353con_tractile
contrastive1647293con_trastive
destructive1755693_destructive
nonconstructive2293463nonconstructive
nondestructive2072743nondestructive
obstructives1953913_obstructives
uninstructive1862943uninstructive
abstractive1854894_abstractive
concoctive1646804con__coctive
conducive1745284con__duc_ive
conflictive2153774con_flictive
conjunctive2554434con_junctive
connective1749254con__nective
consecrative1957314consecrative
conservatives2195194conservatives
conservatize26125504conservatize
constatives1646934const__atives
constrict13711624constrict___
constricted1646364constrict_ed
constrictions1747784constrictions
constrictor1596124constrict_or
constrictors1676014constrictors
constricts1477734constrict__s
construable1554784constru_able
constructional1854764constructional
constructivisms24232814constructivisms
constructivists22223074constructivists
construe1049054constru____e
construing1347444constru__ing
consultative1754784consultative
consummative2164054consummative
consumptive2054224cons_umptive
continuative1755214continuative
contortive1546844con_t_ortive
contraceptive2253004con_traceptive
contractible1854664con_tractible
contracting16610474con_tracting
contraction15411244con_traction
contracture1576624con_tracture
contraoctave1952464con_traoctave
contributive1953584con_tributive
contrive13311354con_tr___ive
contusive1445784con_t_u_sive
convective2049114con__vective
corrective1747444co__rrective
corruptive1754394co__rruptive
counteractive2055954counteractive
deconstructing20113904deconstructing
deconstruction19134434deconstruction
distractive1746774_distractive
instinctive1654374_instinctive
instructing1446294_instructing
instruction13137944_instruction
instructively2164424_instructively
nondeductive1953764nondeductive
nondirective1854684nondirective
noninductive1854214noninductive
nonrestrictive1972594nonrestrictive
nonselective1755414nonselective
nonstructured1663444nonstructured
obstructing1644574_obstructing
obstruction15135544_obstruction
posteruptive1962224po_steruptive
reconstructible2172374reconstructible
reconstructing1974434reconstructing
reconstruction1894774reconstruction
restrictive1646364_restrictive

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 Filter1786911247900.390458182.1
2DLD Change Limit124790956.81318316.5
3Display Results95950.0462065.2
 (SQL Overall)178691957.24924650.4
 
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.