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

93 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
mummify164333(None) 
mummery13336662mummery
mummied11327102mummied
mummies103812842mummies
mumming114010022mumming
mummy114913622mumm__y
bumming143410783bumming
bumpily1665653bumpily
chummily2042843chummily
cummin1288783cummi_n
cummins1358963cummins
damnify1643453damnify
dulcify1643023dulcify
dummied13346723dummied
dummies123012133dummies
dummy134712783dumm__y
dumpily1566233dumpily
emulsify1642703emulsify
furmity1535183furmity
gemmily1534603gemmily
gummier12349473gummier
gumming133810193gumming
gummite1236133gummite
gummy135413653gumm__y
hammily1736063hammily
humidify2042723humidify
humming153310673humming
jimminy2133373jimminy
jumpily2174983jumpily
justify2034663justify
lumpily1476563lumpily
magnify1634533magnify
mammary1335993mammary
mammey124310893mamm_ey
mammie94313783mammi_e
mammies104314763mammies
mammy115215163mamm__y
metrify1535623metrify
micrify1744693micrify
minify1439253m_inify
modify1537173m_odify
mollify1555503mollify
mommies103912273mommies
mommy114010753momm__y
mortify1536223mortify
muckily18277743muckily
muddily1435963muddily
muggily1435103muggily
mumbly15319463mu_mbly
mumm75718863mumm___
mummed104411553mumm_ed
mummer93614543mumm_er
mummers103712843mummers
mummified1643253mummified
mummifies1543713mummifies
mummifying2042853mummifying
mumms85513153mumm__s
mummying15263723mummying
mumping143411633mumping
murkily16287113murkily
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
mutiny113612683mu_tiny
muzzily2045023muzzily
mystify1843563mystify
nullify1334713nullify
nummary14314653nummary
purify14399153pu_rify
qualify2235473qualify
ramify14268753_ramify
rummier11309563rummier
rummies113212793rummies
rummy124212413rumm__y
russify1334063russify
scummily1743303scummily
summary14297353summary
summery14329413summery
summing122912383summing
summit10311543summi_t
summitry1543323summitry
summits1137983summits
tumefy1434223tu_mefy
tummies113012033tummies
tummy124711993tumm__y
uglify1333913_uglify
unify113611113_u_nify
yummier14306843yummier
yummies14359533yummies
yummy15429153yumm__y
yuppify2042163yuppify
zombify2642253zombify

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 Filter1786911340270.406440125.6
2DLD Change Limit134027936.56320421.6
3Display Results93930.0332818.2
 (SQL Overall)178691937.00225520.0
 
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.