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

42 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
constringe134585(None) 
constringed1543591constringed
constringes1445041constringes
constringent1593712constringent
construing1347442construing_
astringe938223__astringe
bowstring15165123bowstring_
bowstringed1851303bowstringed
bowstrings16173223bowstrings
censoring1238783censoring_
censuring1237603censuring_
centring112112953cen_tring_
centrings12227603cen_trings
coasting113615513coast_ing_
coastings12357863coast_ings
coastline1196363coastlin_e
coinsuring1345373coinsuring_
conjuring1937913conjuring_
conscribe1545923conscri_be
conserving1639763conserving_
consoling12310873consoling_
consorting13410743consorting_
conspiring1546553conspiring_
constrain1149333constrain__
constrained1445353constrained
constrains1249723constrain_s
constraint12411133constrain_t
constraints1346203constraints
constrict13711623constri_ct
constricted1646363constricted
constricts1477733constricts
constringing1653563constringing
construe1049053constr__ue
consuming1437913consuming_
continue10311123con_t_inue
contrite10318543con_tri_te
contrive13311353con_tri_ve
costing104323023co_st_ing_
monstrance1445233monstrance
tonsuring1046503tonsuring_
unstring9312093_unstring_
unstrings1046013_unstrings

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 Filter1786911406030.440406115.9
2DLD Change Limit140603426.56321423.6
3Display Results42420.0133230.8
 (SQL Overall)178691427.01625469.1
 
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.