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

93 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
deconstructing2011390(None) 
reconstructing1974431reconstructing
constructing1746752__constructing
deconstruction19134432deconstruction
deconstructions20124362deconstructions
deconstructive22124102deconstructive
constricting1747023__constricting
deconstruct1654143deconstruct___
deconstructed1953703deconstruct_ed
deconstructor1863643deconstruct_or
deconstructors1963623deconstructors
deconstructs1753713deconstruct__s
demonstrating17104763demonstr_ating
destructing1546113de___structing
reconstruction1894773reconstruction
reconstructions19124733reconstructions
reconstructive21124463reconstructive
construction1648084__construction
constructions1747714__constructions
constructive1957444__constructive
construing1347444__constru__ing
contracting16610474__con_tracting
deconsecrating2053634deconsecrating
decontrolling1761434decon_trolling
instructing1446294___instructing
menstruating1553864me__nstruating
obstructing1644574___obstructing
reconducting1854724recon__ducting
reconstituting1763234reconstituting
reconstruct1554904reconstruct___
reconstructed1854264reconstruct_ed
reconstructible2172374reconstructible
reconstructor1764094reconstruct_or
reconstructors1863934reconstructors
reconstructs1654244reconstruct__s
reconsulting1554214recons__ulting
recontacting1745064recon_t_acting
remonstrating1695554remonstr_ating
unconstructive21104214unconstructive
conducting1648835__con__ducting
conscripting1954025__conscripting
consorting13410745__consor__ting
consternating1654975__consternating
constipating1775395__constipating
constituting1554655__constituting
constraining1554545__constraining
constriction1648265__constriction
constrictions1747785__constrictions
constrictive1956625__constrictive
constringing1653565__constringing
construct1358715__construct___
constructed1646255__construct_ed
constructible19113755__constructible
constructional1854765__constructional
constructor1576525__construct_or
constructors1676475__constructors
constructs1457055__construct__s
consulting1349085__cons__ulting
contacting15610075__con_t_acting
contrasting1459355__con_trasting
decentring1446755decen_tr___ing
decocting1538125deco_____cting
deconcentrating2163085deconcentr_ating
decongesting1753735decon__gesting
decorating14312075deco___r_ating
decorticating1984245deco_rticating
defenestrating19112545defenestr_ating
demonstration16126285demonstr_ation
demonstrations1795675demonstr_ations
demonstrative1964215demonstr_ative
denitrating13128335de__nitr_ating
destruction1446955de___struction
destructions1547255de___structions
destructive1755695de___structive
detracting1438715de____tracting
distracting1569255d___istracting
districting1559005d___istricting
distrusting1386495d___istrusting
entrusting11126185_e__n_trusting
misconstruction2162705misconstruction
misconstruing18111925misconstru__ing
nonconstruction1983275nonconstruction
nonconstructive2293465nonconstructive
preconstructed21102715preconstruct_ed
reconnecting1745355recon__necting
reconsecrating1954195reconsecrating
recontouring1553255recon_tou_ring
reconverting1876405reconver__ting
reconvicting20114625recon__victing
redistricting1753785re_districting
restricting1449305re___stricting
subcontracting2161615subcon_tracting
unconstructed1853925unconstruct_ed

Search took 7 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 Limit95024936.09315595.6
3Display Results93930.0631476.2
 (SQL Overall)178691936.51627423.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.