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

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

117 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
constructing174675(None) 
constricting1747021constricting
construction1648082construction
constructions1747712constructions
constructive1957442constructive
construing1347442constru__ing
contracting16610472con_tracting
deconstructing20113902deconstructing
instructing1446292_instructing
obstructing1644572_obstructing
reconstructing1974432reconstructing
conducting1648833con__ducting
conscripting1954023conscripting
consorting13410743consor__ting
consternating1654973consternating
constipating1775393constipating
constituting1554653constituting
constraining1554543constraining
constriction1648263constriction
constrictions1747783constrictions
constrictive1956623constrictive
constringing1653563constringing
construct1358713construct___
constructed1646253construct_ed
constructible19113753constructible
constructional1854763constructional
constructor1576523construct_or
constructors1676473constructors
constructs1457053construct__s
consulting1349083cons__ulting
contacting15610073con_t_acting
contrasting1459353con_trasting
destructing1546113_destructing
menstruating1553863menstruating
abstracting1645184_abstracting
abstricting1654504_abstricting
astricting1357834__astricting
castrating1349774c_astr_ating
codirecting1743644co_directing
coerecting15218784co__erecting
concerting15313894concer__ting
concocting1448414con__cocting
concreting1539874con_cr_eting
conducing1537694con__duc_ing
confecting18310554con__fecting
conflicting1944724con_flicting
confronting1744864con_fronting
confuting1539094con__fu_ting
connecting15310384con__necting
conscribing1853904conscr_ibing
consecrating1747944consecrating
consenting13313214cons__enting
conserving1639754conser__ving
consisting1349524cons__isting
consociating1755574consociating
constellating1653264constellating
constrain1149334constr__ain_
constrains1249724constr__ains
constraint12411134constr__aint
constrict13711624constrict___
constricted1646364constrict_ed
constrictor1596124constrict_or
constrictors1676014constrictors
constricts1477734constrict__s
constringe1345854constr___inge
constructionist1984034constructionist
constructively2463834constructively
constructivism23213684constructivism
constructivist21214194constructivist
consuming1437914cons__u_ming
consummating1953664consummating
contenting13313324con_t_enting
contesting13312214con_t_esting
contorting13410104con_t_orting
contouring1347014con_tou_ring
contractile1547354con_tractile
contraction15411244con_traction
contractions16410404con_tractions
contractive1849524con_tractive
contradicting1954074con_tradicting
contributing1754304con_tributing
contriving1648194con_tr_iving
controlling1445424con_trolling
contusing1239144con_t_u_sing
convecting18310434con__vecting
converting16313134conver__ting
convicting1847584con__victing
convoluting1744204convolu_ting
correcting15199304co__rrecting
corrupting1555584co__rrupting
coscripting1843904co_scripting
costuming1445284co_st_u_ming
counteracting1856284counteracting
deconstruction19134434deconstruction
deconstructions20124364deconstructions
deconstructive22124104deconstructive
distracting1569254_distracting
districting1559004_districting
distrusting1386494_distrusting
entrusting11126184_en_trusting
instruction13137944_instruction
instructions14137814_instructions
instructive1656484_instructive
intrusting11128174_in_trusting
mistrusting1465924_mistrusting
nonsuiting1147274nons__uiting
obstruction15135544_obstruction
obstructions16155524_obstructions
obstructive1854614_obstructive
reconstruction1894774reconstruction
reconstructions19124734reconstructions
reconstructive21124464reconstructive
restricting1449304_restricting
strunting1037874___strunting
strutting1037004___strutting
unconstructive21104214unconstructive
untrusting1186004_un_trusting

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.393454684.5
2DLD Change Limit1247901176.93617991.6
3Display Results1171170.0631857.1
 (SQL Overall)1786911177.39224173.6
 
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.