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

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

104 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
reconstructing197443(None) 
deconstructing20113901deconstructing
constructing1746752__constructing
reconstruction1894772reconstruction
reconstructions19124732reconstructions
reconstructive21124462reconstructive
constricting1747023__constricting
deconstruction19134433deconstruction
deconstructions20124363deconstructions
deconstructive22124103deconstructive
reconducting1854723recon__ducting
reconstituting1763233reconstituting
reconstruct1554903reconstruct___
reconstructed1854263reconstruct_ed
reconstructible2172373reconstructible
reconstructor1764093reconstruct_or
reconstructors1863933reconstructors
reconstructs1654243reconstruct__s
reconsulting1554213recons__ulting
recontacting1745063recon_t_acting
remonstrating1695553remonstr_ating
construction1648084__construction
constructions1747714__constructions
constructive1957444__constructive
construing1347444__constru__ing
contracting16610474__con_tracting
deconstruct1654144deconstruct___
deconstructed1953704deconstruct_ed
deconstructor1863644deconstruct_or
deconstructors1963624deconstructors
deconstructs1753714deconstruct__s
demonstrating17104764demonstr_ating
destructing1546114de___structing
instructing1446294___instructing
menstruating1553864me__nstruating
obstructing1644574___obstructing
preconstructed21102714preconstruct_ed
reconnecting1745354recon__necting
reconsecrating1954194reconsecrating
recontouring1553254recon_tou_ring
reconverting1876404reconver__ting
reconvicting20114624recon__victing
redistricting1753784re_districting
restricting1449304re___stricting
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
deconsecrating2053635deconsecrating
decontrolling1761435decon_trolling
entrusting11126185_e__n_trusting
misconstruction2162705misconstruction
misconstruing18111925misconstru__ing
nonconstruction1983275nonconstruction
nonconstructive2293465nonconstructive
preconcerting2084415preconcer__ting
recensoring1444675recensor___ing
recollecting1764085reco__llecting
recomputing1844345reco__mpu_ting
reconcentrating2063345reconcentr_ating
reconferring1853725reconfer__ring
reconfiguring2061635reconfigu_ring
reconfirming2053085reconfir__ming
reconquering2452995recon__quering
reconsidering1752325recons_idering
reconsigning1653445recons__igning
reconsolidating1962015reconsolidating
reconsoling1444485recons___oling
reconstitution1663565reconstitution
reconstitutions1763275reconstitutions
reconvincing2053165recon_vinc_ing
recounting1339195reco____unting
recruiting1347905rec____ruiting
reinducting1544385re_in__ducting
reinserting1256905re_inser__ting
reinspecting1763205re_ins_pecting
reinstating1248115re_inst__ating
reinstituting1453075re_instituting
remonstration15117125remonstr_ation
remonstrations16116485remonstr_ations
remonstrative1874575remonstr_ative
restructuring1672795re___structuring
retracting13311935re____tracting
subcontracting2161615subcon_tracting
unconstructed1853925unconstruct_ed
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.703254183.5
2DLD Change Limit950241047.17313247.5
3Display Results1041040.0601733.3
 (SQL Overall)1786911047.93622516.5
 
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.