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

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

38 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
cotransduction196202(None) 
cotransductions2061991cotransductions
transduction1584452__transduction
cotransducing1961573cotransduc_ing
transductions1664293__transductions
conduction1549964co___n_duction
contradiction1854564contra__diction
coproduction1954744copr__oduction
cotransduce1661584cotransduc___e
cotransduced1861434cotransduc__ed
cotransduces1761784cotransduc__es
transaction1346304__trans_action
transductional1782514__transductional
transection1357374__trans_ection
transfection1765394__transfection
transudation1355324__transudation
conductions1649665co___n_ductions
consecution1547315co___nsecution
construction1648085co___nstruction
contraction15411245contra____ction
contradictions1954145contra__dictions
coproductions2054495copr__oductions
cotransporting1991795cotransporting
introduction1555785intr__oduction
nonconduction1884475noncon_duction
photoinduction22103005photoin_duction
retranslation1354685retrans_lation
transactions1445885__trans_actions
transducing1554355__transduc_ing
transductant1573575__transductant
transections1446765__trans_ections
transfections1854855__transfections
transfusion1454235__transfu_sion
transition1049705__trans__ition
translation1149485__trans_lation
translocation1554685__translocation
transmutation1554405__transmutation
transudations1454835__transudations

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 Filter178691950240.343520965.0
2DLD Change Limit95024386.90613759.6
3Display Results38380.0162375.0
 (SQL Overall)178691387.26524596.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.