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

76 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
discerning144786(None) 
decerning1337292d_ecerning
discarding1547342discarding
discepting1658472discepting
discerningly1952952discerningly
discording1547662discording
dispersing1449302dispersing
disserting121310852disserting
disserving15117012disserving
concerning1548903concerning
descending1546113descending
descrying1635103desc_rying
deserting11713143des_erting
deserving1497903des_erving
diapering1339033diaper_ing
dickering1737463dicker_ing
differing1746473differ_ing
disarming1338803dis_arming
disbarring1445283disbarring
disbursing1445373disbursing
discanting1449453discanting
discasing1339433disc_asing
discern1038493discer__n_
discerned1347863discern_ed
discerner1246943discern_er
discerners1345703discerners
discernible1653363discernible
discernibly1952733discernibly
discernment16116113discernment
discerns1138163discer__ns
discharging1943943discharging
discing113914593disc___ing
discipling1645873discipling
disclosing1446613disclosing
discoing12511453disc__oing
discounting1547443discounting
discoursing1544853discoursing
discovering1845363discover_ing
discrowning1843803discrowning
discussing1445983discussing
disdaining1345993disdaining
diseasing11310833dis_easing
disgorging1455013disgorging
dishelming1745273dishelming
disheriting1646453disheriting
disjecting2177243disjecting
disjoining1965723disjoining
dislimning1444883dislimning
disowning1446113dis_owning
disparting1438933disparting
dispelling1447613dispelling
dispending1547923dispending
dispensing1448233dispensing
disporting1439823disporting
disseating121111783disseating
dissecting14139473dissecting
disseising1247643disseising
disseizing2147003disseizing
dissenting121310293dissenting
distaining1248903distaining
distending1348333distending
distorting1239583distorting
disturbing1445653disturbing
dithering1499853dither_ing
diverging15226693di_verging
diverting142410333di_verting
dizening19177143di_ze_ning
interning10315253_interning
listening10128953liste_ning
miscoining1597763miscoining
mislearning1443723mislearning
mispenning1545773mispenning
misterming1538603misterming
scorning1169133__scorning
secerning1246203_secerning
sistering101213753sister_ing

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.1561145455.1
2DLD Change Limit140603766.57621381.2
3Display Results76760.0461652.2
 (SQL Overall)178691766.77826363.4
 
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.