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

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
discussants145247(None) 
discussant1353721discussant_
discants112912023disc___ants
discussable1653553discussable
discussers13235193discuss_ers
discusses12268253discuss__es
discussing1445983discussin_g
discussions1444243discussions
dispersants1454363dispersants
disputants1344063dispu_tants
accusants1344284_accu_sants
decussate1243974d_ecussa_te
decussates1343244d_ecussates
depressants1453014depressants
descants112910144desc___ants
descendants1552754descendants
diocesans1242484dioc_esan_s
disbursals1352374disbursa_ls
discant103017254disc___ant_
discontents1447544discontents
discordant1445424discordant_
discounts1287824disc__ounts
discrepant1554244discrepant_
discuses113112864discu_s__es
discuss10357954discu_s___s
discussed13256764discuss__ed
discusser12246184discuss__er
discussible1653384discussible
discussion1344504discuss_ion
disenchants1753184disenchants
disgusts1045654disgu_s__ts
dismissals1352204dismissa_ls
dispersant1346354dispersant_
displants1248074dis__plants
disputant1245744dispu_tant_
disseats93211504dis__sea_ts
dissents93411864di___ssents
incessant1146094_incessant_
miscreants1445084misc_reants
obscurants14173024obscu_rants
pissants1097364pi___ssants
recusants1145104_recu_sants

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 Filter1786911488190.1561145455.1
2DLD Change Limit148819428.15618246.6
3Display Results42420.0162625.0
 (SQL Overall)178691428.32821456.7
 
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.