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

77 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
constructors167647(None) 
constrictors1676011constrictors
constructor1576521constructor_
constrictor1596122constrictor_
constructions1747712constructions
constructs1457052construct__s
contractors1549162con_tractors
deconstructors1963622deconstructors
instructors1355382_instructors
obstructors1564002_obstructors
reconstructors1863932reconstructors
conductors1546973con__ductors
conservators1755973conservators
constrictions1747783constrictions
constricts1477733constrict__s
construct1358713construct___
constructed1646253construct_ed
constructing1746753constructing
construction1648083construction
constructive1957443constructive
construers1245873constru__ers
consultors1286403cons__ultors
contactors1448843con_t_actors
contractor1449073con_tractor_
deconstructor1863643deconstructor_
instructor1255163_instructor_
obstructor1453753_obstructor_
reconstructor1764093reconstructor_
abstractors1554414_abstractors
castrators1247444c_astr_ators
codirectors1653344co_directors
concoctors1346404con__coctors
conductor1447214con__ductor_
connectors1448184con__nectors
consecrators1656054consecrators
conservator1656364conservator_
conservatory2054754conservatory
conspirators1655534conspirators
constrict13711624constrict___
constricted1646364constrict_ed
constricting1747024constricting
constriction1648264constriction
constrictive1956624constrictive
construals1245214constru__als
constructible19113754constructible
constructional1854754constructional
constructionist1984034constructionist
constructivism23213684constructivism
constructivist21214194constructivist
construer1146914constru__er_
construes11410134constru___es
consulters1297214cons__ulters
consultor1176474cons__ultor_
consummators18134024consummators
contactor1348434con_t_actor_
continuators14105624continuators
contractions16410404con_tractions
contracts132212014con_tract__s
contracture1576624con_tracture
contractures1676044con_tractures
contradictors1883634con_tradictors
contraltos1246764con_tralto_s
contributors16153914con_tributors
convectors1768314con__vectors
convertors1549134conver__tors
correctors1447494co__rrectors
corruptors1443894co__rruptors
deconstructions20124364deconstructions
deconstructs1753714deconstruct__s
instructions14137814_instructions
instructs1145794_instruct__s
nonstructural1573674nonstructural
nonstructured1663444nonstructured
obstructions16155524_obstructions
obstructs1344574_obstruct__s
reconstructions19124734reconstructions
reconstructs1654244reconstruct__s

Search took 9 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.1401276364.3
2DLD Change Limit124790777.84315911.0
3Display Results77770.0461673.9
 (SQL Overall)178691778.02922255.7
 
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.