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

38 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
macumbas165301(None) 
macumba1573041macumba_
maculas113114022macu_las
mambas125716242ma__mbas
marimbas1444362marimbas
mazumas2034622mazum_as
acumens1136953_acumens
aucubas1145173_aucubas
cabombas1643813cabombas
cumbias13338963__cumbias
dicambas1553793dicambas
gambas115817513ga__mbas
kalimbas1642323kalimbas
lacunas9138173lacu_nas
maccabaw1942003maccabaw
maccabaws2051513maccabaws
macula103013673macu_la_
maculae113412863macu_lae
macular113011943macu_lar
macules114015133macu_les
magmas115512503ma_gm_as
mamas95930773ma__m_as
mamba116317523ma__mba_
mambos125414493ma__mbos
mammas94616403ma__mmas
manumits1246003manumits
maquilas1944033maquilas
marimba1354983marimba_
mastabas1246803mastabas
maumets11369693ma_umets
mazuma1935603mazum_a_
mazurkas2372383mazurkas
rhumbas14305163_rhumbas
rumbas102512013__rumbas
sambas104219263sa__mbas
scubas103710223_scu_bas
scumbag1443573_scumbag
scumbags1543203_scumbags

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 Limit146162387.48319532.5
3Display Results38380.0162375.0
 (SQL Overall)178691387.93522519.3
 
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.