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

187 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
midway1532715(None) 
midday13327501midday
midways16386181midways
airway1237692airway
midcap1336472midcap
middays14335662middays
middy124812602mid_dy
mislay113510682mislay
missay114112142missay
oilway1235742oilway
sideway1445672sideway
skidway1843082skidway
tideway1445152tideway
windway1745152windway
aidman92410623aidman
airways1336243airways
alway116113923_alway
anyway1534803anyway
away108024223__away
biddy124612703bid_dy
bikeway1944313bikeway
byway1647533_byway
cogway1566183cogway
day76254113__d_ay
diddly12389573diddly
didy99121523did__y
dismay12229473dismay
diwan95712553di_wan
dray85428093__dray
endways1444443endways
fairway1644333fairway
fiddly14328483fiddly
fishway1943813fishway
flyway18134693flyway
giddap1143413giddap
giddy115810213gid_dy
guideway1642433guideway
headway1745553headway
hideaway1842713hideaway
highway2044263highway
idea59122783_idea_
ideal65716393_ideal
ideas65919013_ideas
idly85617333_id_ly
inlay85214323_inlay
jetway19105273jetway
keyway1943823keyway
kiddy144910293kid_dy
kidnap1334203kidnap
kidney1434773kidney
leeway1255883leeway
lidar6312733lid_ar
lifeway1644273lifeway
logway1335913logway
madam10316223mad_am
madcap1336333madcap
madly115218133mad_ly
madman113712393madman
madras94316433madras
margay12310603margay
may88757633m___ay
mayday1535883mayday
medal86221333med_al
medfly1535223medfly
media84721713media_
mediacy1536143mediacy
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medlar93010463medlar
medley1298343medley
mica86428263mi_ca_
micas96823053mi_cas
mickey174211853mickey
micra96214973micra_
mid67354483mid___
midair937993midair
midden104112853midden
middle103414983middle
midge95016563mid_ge
midges103516483midges
midget103718453midget
midgut103510053midgut
midi75628493mid__i
midis85923423mid_is
midland1136613midland
midleg1038553midleg
midrash1335423midrash
midrib1138243midrib
mids76541803mid__s
midst85922563mid_st
midsts95510053midsts
midwatch1941993midwatch
midweek1743273midweek
midwife16225523midwife
midyear1343343midyear
miffy163910203mi_ffy
mighty154310213mighty
mihrab1335523mihrab
mikra114610313mikra_
mikvah18143473mikvah
milady1236613milady
mildewy16353533mildewy
mildly12318243mildly
milia72719573milia_
miliary1249463miliary
milky144014443mi_lky
milpa92111403milpa_
milpas101710273milpas
milty104720073mi_lty
mimbar1297493mimbar
mina65136933mi_na_
minae75627723mi_nae
minas75434113mi_nas
mincy125817413mi_ncy
mingy115520183mi_ngy
minify1439253minify
minny104518663mi_nny
minty106323903mi_nty
minyan1138173minyan
mirky146315523mi_rky
miry96326763mi__ry
mirza16410443mirza_
mirzas1738183mirzas
misdeal1037663misdeal
misdial1039643misdial
misdraw1345623misdraw
miseat82925713miseat
misery114113543misery
mishap1338873mishap
miskal123710263miskal
mislays12349243mislays
misplay1436383misplay
missal84314903missal
missays124010253missays
missy105617563mi_ssy
misty106120453mi_sty
mitral81314323mitral
mity95528223mi__ty
mizzly19256103mizzly
modal85919243mod_al
modify1537173modify
moray105423793m_oray
mudcap1335133mudcap
mudcat11311203mudcat
muddly13418603muddly
muddy123812233mud_dy
mudra83912433mudra_
mudras94212263mudras
nidal65217113nid_al
nidify1336763nidify
noway111112843_noway
oidia6314963oidia_
oilways1334873oilways
piddly13319143piddly
railway1345313railway
redbay1238333redbay
ridgy104110653rid_gy
ridley10169543ridley
roadway1464613roadway
runway12105973runway
seaway12309993seaway
shipway1844213shipway
sideways1545233sideways
skidways1942823skidways
skyway1933343skyway
slideway1543163slideway
slipway1543873slipway
subway1447073subway
sway107128233__sway
tidal64516453tid_al
tiddly11308783tiddly
tideways1544563tideways
tidily102811393tidily
tidy86822433tid__y
today96416953tod_ay
viewy14518103view_y
way96757663___way
widdy136112193wid_dy
widely133311033widely
widthway2141943widthway
wigwag1443723wigwag
wigwam1544723wigwam
windways1845043windways
wireway1646043wireway

Search took 6 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 Filter1786911127160.420425454.8
2DLD Change Limit1127161874.81323419.1
3Display Results1871870.0603116.7
 (SQL Overall)1786911875.29333759.9
 
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.