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

90 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
discanting144945(None) 
descanting1446921descanting
decanting132510632d_ecanting
disbanding1545582disbanding
discarding1547342discarding
discasing1339432disca_sing
discepting1658472discepting
discounting1547442discounting
dismantling1543392dismantling
dismasting1446382dismasting
disparting1438932disparting
displanting1546042displanting
disrating11714552disra_ting
dissenting121310292dissenting
distancing1447082distancing
distasting1248022distasting
incanting1289902_incanting
miscasting1557072miscasting
scanting113914762__scanting
canting104725903___canting
desalting1138843des_alting
desanding12207653des_anding
descending1546113descending
dictating1338883di_ctating
dilating102714913di_la_ting
dinting93520553di___nting
disabling1337753dis_abling
disarming1338803dis_arming
disbarring1445283disbarring
discant103017263discant___
discanted1339333discant_ed
discants112912023discant__s
discerning1447863discerning
discharging1943943discharging
discing113914593disc___ing
discipling1645873discipling
disclaiming1744323disclaiming
disclosing1446613disclosing
discoing12511453disc__oing
discontent13410253discontent
discontinue1455243discontinue
discording1547663discording
discussing1445993discussing
disdaining1345993disdaining
diseasing11310833disea_sing
disenchanting20102383disenchanting
disgusting1345973disgusting
disjecting2177243disjecting
disjointing2045293disjointing
dislocating1546733disloca_ting
dismaying1656823disma_ying
dismounting1545083dismounting
disowning1446113disown_ing
dispending1547923dispending
dispensing1448233dispensing
disporting1439823disporting
disputing1337763dis_puting
disrooting1247753disrooting
disrupting1446343disrupting
dissaving1436963dissa_ving
disseating121111783disseating
dissecting14139473dissecting
disserting121310853disserting
distaining1248903distaining
distending1348333distending
distorting1239593distorting
distracting1569263distracting
disuniting1247413disuniting
disvaluing1574433disvaluing
incenting12912063_incenting
islanding1135623_islanding
misacting1439083mis_acting
miscalling1547863miscalling
misciting1439673misc_iting
miscounting1646053miscounting
miscutting1576053miscutting
misdating131010663misda_ting
miseating121215433misea_ting
mismating141211823misma_ting
mispainting1645293mispainting
misparting1538083misparting
misplanting1645633misplanting
misrating121014853misra_ting
recanting122414823_recanting
scanning113310773__scanning
scantling12107233__scantling
scarting113415263__scarting
scatting113311813__scatting
scenting113212813__scenting
slanting94115093__slanting

Search took 7 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.420425454.8
2DLD Change Limit140603906.28322378.3
3Display Results90900.0461956.5
 (SQL Overall)178691906.74926476.7
 
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.