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

49 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
coproduction195474(None) 
coproductions2054491coproductions
production1547892__production
reproduction1765652reproduction
conduction1549963co__nduction
coproducing1953053coproduc_ing
coproduct1664523coproduct___
coproducts1753353coproduct__s
introduction1555783introduction
postproduction2162893postproduction
preproduction2054393preproduction
productions1647533__productions
reproductions1865273reproductions
coeducation1646234co__education
coevolution1654224coevolu_tion
concoction1348234conco__ction
conductions1649664co__nductions
construction1648084construction
contradiction1854564contradiction
convolution1645124convolu_tion
coproduce1643544coproduc___e
coproduced1852944coproduc__ed
coproducer1763074coproduc__er
coproducers1862534coproduc_ers
coproduces1763724coproduc__es
coronation12412074co_ro_nation
corotation12410974co_ro_tation
corporation151210654corpo_ration
correction1448814co_r_rection
corruption1455374co_r_ruption
cotransduction1962024cotransduction
introductions1655134introductions
liposuction1581934lip_osuction
nonconduction1884474nonconduction
nonproductive2193394nonproductive
overproduction2264054overproduction
photoproduction2573064photoproduction
postproductions2272504postproductions
prediction15410304__prediction
preproductions2153944preproductions
proaction13410104__pro_action
productional1794714__productional
productive1845514__productive
projection2158764__projection
protection14511474__protection
reduction1259904___reduction
reproductive20124334reproductive
retrodiction1555654retrodiction
unproductive2073114unproductive

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.406440125.6
2DLD Change Limit124790497.70316200.2
3Display Results49490.0301633.3
 (SQL Overall)178691498.13921954.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.