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

66 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
dumdums134304(None) 
dumdum1244521dumdum_
cundums1235182cundums
dirdums1134382dirdums
durums948152du_rums
humdrums1642702humdrums
aurums849383au_rums
bunkums1544053bunkums
crumbums1642733crumbums
cundum1136513cundum_
cuprums1334453cuprums
curiums1138503curiums
datums936353d_atums
degums10438623d_egums
demurs939773dem_urs
diadems1135393diadems
dictums1235553dictums
dimouts1037893dimouts
dinkums1433673dinkums
dirdum1036033dirdum_
dogdoms1295423dogdoms
doldrums1243053doldrums
doums85417643d__oums
drums85415873d__rums
duads76515343duad__s
dubniums1343153dubniums
dudes75424373du_d_es
duds65530143du_d__s
dufus94010813du_fu_s
dugouts935043dugouts
dukedoms1642393dukedoms
dumas85420433dum__as
dumbos114111083dum_bos
dumbs105915753dum__bs
dummies123012133dummies
dummy134712783dum__my
dumpers123412663dumpers
dumps105220103dum__ps
dunams937833du_nams
duodenums1351463duodenums
durum8513203du_rum_
dustups1033913dustups
fundus10429173fundu_s
humbugs1534243humbugs
humdrum1543523humdrum_
hummus1336243hummu_s
humours1286433humours
humus106215073hum_u_s
imaums10106303_imaums
jugums16104673ju_gums
kudus104910803ku_du_s
mumms85513153mum__ms
mums85732773__m_ums
mumus95517283mum_u_s
museums1134563museums
osmiums1134143osmiums
plumbums1642943plumbums
quorums1843893quorums
rumours976373rumours
rumpus10458893rumpu_s
sedums93910483_sedums
slumgums1342093slumgums
subdues1099893subdues
subgums1235893subgums
tumours976753tumours
wampums16314213wampums

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 Filter1786911340270.406440125.6
2DLD Change Limit134027666.18621666.2
3Display Results66660.0332000.0
 (SQL Overall)178691666.62526972.2
 
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.