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

50 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
scumbags154320(None) 
scumbag1443571scumbag_
scubas103710222scu_ba_s
scumbles1447022scumbles
combats13311683_combats
cubage1178273_cu_bage
cubages1237923_cu_bages
cumbers134515413_cumbers
cumbias13338963_cumbias
cymbals16236143_cymbals
humbugs1534243_humbugs
jumbals18106533_jumbals
lumbago1243833_lumbago
lumbagos1343073_lumbagos
lumbars11289763_lumbars
macumbas1653013macumba_s
numbats1137673_numbats
plumbago1542013plumbago
plumbagos1641673plumbagos
rhumbas14305163rhumba_s
rumbas102512013_rumba_s
sambals115213483s_ambals
sambars115113843s_ambars
sambas104219263s_amba_s
sandbags1296373sandbags
scags85520973sc___ags
schmears1584103schmears
scrags95713803sc__rags
scrummage1641873scrummage
scrummages1752053scrummages
scuba94211593scu_ba__
scubaed1236123scu_baed
scumble1337013scumb_le
scumbled1535053scumbled
scumless1254993scumless
scummers14277783scummers
scums95017423scum___s
scuppaugs1651043scuppaugs
scutage1036333scu_tage
scutages1136503scu_tages
seabags1037483s_eabags
slumbers123110273slumbers
stumbles1237493stumbles
stumpage1343303stumpage
stumpages1442803stumpages
subahs114512393s_u_bahs
subas74724083s_u_ba_s
subbass1138043s_ubbass
sumacs105512103s_um_acs
summas104313163s_umma_s

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 Filter1786911461620.436409841.7
2DLD Change Limit146162506.56322270.6
3Display Results50500.0133846.2
 (SQL Overall)178691507.01225483.6
 
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.