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 “middays” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
middays1433566(None) 
midday13327501midday_
midways16386181midways
maydays1634492maydays
middens11379382middens
middies113116152middies
middles113415302middles
middy124812602midd_y_
midway15327152midway_
mislays12349242mislays
missays124010252missays
airways1336243airways
bendays13327513bendays
bidders114012313bidders
biddies113514493biddies
biddy124612703bidd_y_
days87637133___days
diddles103915073diddles
diddleys14334633diddleys
diddly12389573diddly_
dismays13237433dismays
drays95819773__drays
endways1444443endways
fiddles123212603fiddles
fiddly14328483fiddly_
giddap1143413gidda_p
giddies103713363giddies
giddy115810213gidd_y_
giddyap1541233giddyap
goddams1233983goddams
heydays1734143heydays
ideals75012503_ideals
ideas65919013_idea_s
inlays9389873_inlays
keddahs1642923keddahs
kidders13399173kidders
kiddies133412283kiddies
kiddoes13387063kiddoes
kiddos12416873kidd_os
kiddy144910293kidd_y_
kidnaps1453323kidnaps
kidneys1533423kidneys
lidars7310783li_dars
madams11310943m_adams
madcaps1435243madcaps
maddens11359753maddens
madders113513213madders
madras94316433madra_s
margays1337493margays
mayday1535883mayday_
mays96940033m___ays
medals94218063m_edals
meddles113213253meddles
medials103914743medials
medians103214213medians
medias93620783media_s
medlars10259443medlars
medleys13115333medleys
micas96823053mi_ca_s
mickeys18447943mickeys
midair937993mi_dair
midairs1037203midairs
midcap1336473midca_p
midden104112853midd_en
middle103414983midd_le
middled123311903middled
middler112712273middler
middlers123410193middlers
midges103516483mi_dges
midgets113910253midgets
midguts11296013midguts
midis85923423mi_d_is
midland1136613midland
midlands1245543midlands
midlegs1156323midlegs
midrash1335423midrash
midribs1235513midribs
mids76541803mi_d__s
midsts95510053mi_dsts
midyears1443403midyears
mihrabs1444203mihrabs
mikados1444683mikados
mikvahs19162493mikvahs
miladis1049823miladis
milady1236613milady_
mildens10339933mildens
mildews13365883mildews
mildly12318243mildly_
milds86422063mild__s
milldams1344633milldams
milpas101710273milpa_s
mimbars1397383mimbars
minas75434113mi_na_s
minders103720123minders
minds85427133mind__s
minyans1237263minyans
mirzas1738183mirza_s
misadds1136303misadds
misdate101413963misdate
misdates111113633misdates
misdeals1147233misdeals
misdials1137503misdials
misdoes10312493misdoes
misdraws1445753misdraws
miseats92815793miseats
mishaps1438723mishaps
miskals13369773miskals
mislay113510683mislay_
misplays1555543misplays
missals93914433missals
missay114112143missay_
modals93914463m_odals
morays114613883m_orays
mudcaps1444113mudcaps
mudcats1236223mudcats
mudders113211113mudders
muddies113513953muddies
muddles112914353muddles
muddly13418603muddly_
muddy123812233mudd_y_
mudras94212263mudra_s
oilways1334873oilways
paydays1634433paydays
piddles114314273piddles
piddly13319143piddly_
qindars17267423qindars
redbays1336013redbays
ridders93612493ridders
riddles93215023riddles
ridleys11145783ridleys
siddurs934173siddurs
sideways1545233sideways
sirdars8228213sirdars
skidways1942823skidways
tiddly11308783tiddly_
tideways1544563tideways
todays10458103_todays
widders123512273widders
widdies123514033widdies
widdles123514343widdles
widdy136112193widd_y_
windways1845043windways

Search took 10 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.796224486.2
2DLD Change Limit1340271428.34316064.6
3Display Results1421420.0502840.0
 (SQL Overall)1786911429.18919446.2
 
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.