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

52 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
succusses134442(None) 
successes1345641successes
succussed1443391succussed
schusses1334212s_chusses
succubuses1652002succubuses
succuss1134992succu_s_s
accesses1287493_accesses
accuses114112193_accu_ses
caucusses1343043caucusses
concusses1346343concusses
cuscuses1235863cuscu_ses
cusses84522773___cusses
discusses12268253discusses
duchesses1544133duchesses
focusses13155223_focusses
fucuses12158353fu_cu_ses
hocusses13155303_hocusses
mucuses11148513mu_cu_ses
outcurses1145803outcurses
percusses1346503percusses
ruckuses1444913rucku_ses
saccules1237033saccu_les
schussed1443053s_chussed
schusser1342973s_chusser
schussers1442553s_chussers
scouses93313243s_cou_ses
sourpusses1242453sourpusses
subbasses1345223subbasses
subcastes1387493subcastes
subcauses1346213subcauses
subclasses1444743subclasses
subcutes1238583subcu_tes
subcutises1444633subcutises
success1146403succ_es_s
successor1343063successor
successors1453013successors
succories1347183succories
succubae1443083succubae_
succubas1443853succu_bas
succubus1443033succu_bus
succumbed1842073succumbed
succumbs1642423succu_mbs
succussing1543013succussing
suchnesses1536673suchnesses
sucrases10310253su_crases
sucroses1039943su_croses
suffuses1435833suffu_ses
surceases1157473surceases
surpasses1145533surpasses
surplusses1242843surplusses
susses64221053s___usses
unsuccesses1551743unsuccesses

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 Filter1786911486410.423422437.4
2DLD Change Limit148641526.43623095.2
3Display Results52520.0301733.3
 (SQL Overall)178691526.88925938.6
 
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.