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

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

46 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
constricted164636(None) 
constructed1646251constructed
conscripted1853432conscripted
constrict13711622constrict__
constrictor1596122constrictor
constricts1477732constrict_s
constringed1543592constringed
contracted1549822con_tracted
unconstricted1853362unconstricted
abstricted1544093_abstricted
astricted1247443__astricted
conflicted1844053con_flicted
conscribed1743963conscri_bed
consisted1238503cons__isted
consociated1645213consociated
consorted1239773consor__ted
consternated1554113consternated
constipated1645463constipated
constituted1475053constituted
constrained1445353constrained
constricting1747023constricting
constriction1648263constriction
constrictive1956623constrictive
constrictors1676013constrictors
constringe1345853constringe_
constringes1445043constringes
construct1358713construct__
constructor1576523constructor
constructs1457053construct_s
construed1247313constr__ued
contacted14139093con_t_acted
contradicted1853553con_tradicted
contrasted1348573con_trasted
contributed1654263con_tributed
contrite10318543con_tri_te_
contrived1547993con_tri_ved
convicted1746313con__victed
coscripted1752923co_scripted
deconstructed1953703deconstructed
districted1448223_districted
instructed1345633_instructed
nonrestricted1662693nonrestricted
obstructed1544233_obstructed
reconstructed1854263reconstructed
restricted1348303_restricted
unconstructed1853923unconstructed

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633465.26623097.8
3Display Results46460.0301533.3
 (SQL Overall)178691465.68631426.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.