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

246 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
mayday153587(None) 
maydays1634481maydays
payday1536611payday
gaydar1135502gaydar
heyday1635142heyday
madam10316222ma_dam
madly115218132ma_dly
malady1237862malady
margay12310592margay
maya95824582may_a_
mayan105616902may_an
mayas105924382may_as
mayfly1734402mayfly
mayhap1635232mayhap
midday13327502midday
naysay1234972naysay
paydays1634432paydays
playday1643822playday
waylay1535452waylay
addax1435993_addax
allay85620393_allay
alway116113923_alway
anyway1534803anyway
array86317143_array
assay8710283_assay
audad71511383_audad
away108024223_a_way
ayah108022993_ay_ah
baddy125016023ba_ddy
badly114918763ba_dly
baldly12479833baldly
baldy115518933bald_y
banda85223103banda_
bandas95120543bandas
bandy114824183band_y
bawdry15516463bawdry
bawdy147513283bawd_y
bayman133712703bayman
benday123810813benday
byway1647533_byway
caddy125414023ca_ddy
cadgy125210783ca_dgy
candy115119823cand_y
caudad10157673caudad
caudal91611483caudal
cayman133613213cayman
dada66422443da_da_
dadas75819863da_das
daddy116212563da_ddy
daedal849083daedal
dandy104416703dand_y
day76254113___day
dayfly1633813dayfly
faddy135511623fa_ddy
faraday1445633faraday
flyway18134693flyway
gamay116419103ga_may
garda7316763garda_
gardai839663gardai
gaudy106611463gaud_y
gayal9312713gay_al
gaydars1235803gaydars
gayety13116383gayety
gayly124513093gay_ly
hadal95518123ha_dal
handax1749583handax
handy125520873hand_y
hardly135112833hardly
hardy125622063hard_y
hayey144812533hay_ey
heydays1734143heydays
heydey1634633heydey
holyday1743773holyday
kayak1138363kay_ak
keyway1943823keyway
lady86527153la_d_y
landau7310613landau
lardy96119273lard_y
layaway1643933layaway
layman113511303layman
maar66025053ma__ar
macadam1446853macadam
macaw12311763ma_caw
mad68958703ma_d__
madame1139853ma_dame
madams11310943ma_dams
madcap1336333madcap
madded113513553madded
madden103912523madden
madder103515593madder
made75440233ma_d_e
madman113712383madman
madras94316423madras
madre85720173ma_dre
mads76845363ma_d_s
maenad939413maenad
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magma104513573magma_
magmas115512503magmas
maguey1236833maguey
maid75537643maid__
maiden93512283maiden
maids86327143maid_s
mainly11411493mainly
makar115614973ma_kar
malar76424443ma_lar
malmy124816343ma_lmy
malty106721703ma_lty
mama86231583ma_ma_
mamas95930773ma_mas
mamba116317523mamba_
mambas125716243mambas
mamey125418833ma_mey
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammary1335993mammary
mammas94616403mammas
mammey124310893mammey
mammy115215163ma_mmy
mana65341943ma_na_
manas76240423ma_nas
manat76039983ma_nat
mandala10310203mandala
mandate10315573mandate
manga85026193manga_
mangaby1535353mangaby
mangas94122923mangas
mangey123614523mangey
mangy115021233ma_ngy
mania75634143mania_
maniac103917973maniac
manias84029033manias
manly105022943ma_nly
manna75522533manna_
mannan85413623mannan
mannas85019803mannas
manta75629903manta_
mantas85725363mantas
manual8313463manual
manuary1237773manuary
many95731843ma__ny
mara67444563ma_ra_
maras75443283ma_ras
marbly134111933marbly
margays1337493margays
maria75032883maria_
marka114620793marka_
markas124717003markas
marly106925613ma_rly
marram10313883marram
marry104821693ma_rry
marshy14558333marshy
marvy135014033ma_rvy
masa65034713ma_sa_
masas75630413ma_sas
mashy136016503ma_shy
massa75518923massa_
massas85116463massas
massy104518963ma_ssy
matey107022663ma_tey
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
maud75325393maud__
mauds85519273maud_s
maundy12506783maundy
may88757623m___ay
maybe12311133may_be
maybes1339243maybes
mayed115522403may_ed
mayest114614793mayest
mayhem1644923mayhem
maying124421153maying
mayo96524293may__o
mayor106616623may_or
mayoral1237683mayoral
mayors115714193mayors
mayos105521933may_os
maypop1565143maypop
mays96940023may__s
mayst106622673may_st
mayvin1436523mayvin
mazedly2234433mazedly
mazily20610393mazily
mazy186419693ma__zy
medal86221323m_edal
middays14335663middays
middy124812593m_iddy
midway15327153midway
milady1236613milady
mildly12318243mildly
mislay113510683mislay
missay114112143missay
modal85919233m_odal
moldy115014653mold_y
moody115017493mood_y
moray105423793m_oray
muddly13418603muddly
muddy123812233m_uddy
mylar105311533m_ylar
myna95815293m_yna_
mynah13569563m_ynah
mynas105815233m_ynas
myopy15457353m_yopy
mythy16568673m_ythy
nada58022903na_da_
nadas66320813na_das
naysays1344123naysays
paddy125913593pa_ddy
panda85022613panda_
pandas95521963pandas
pandy115021173pand_y
pardah123412823pardah
pardy115523953pard_y
parlay113713993parlay
playdays1742973playdays
radar61316723ra_dar
randan7315253randan
randy95022083rand_y
raya75224823ray_a_
rayah116013503ray_ah
rayas85922053ray_as
sadly94519123sa_dly
sandal73317283sandal
sandy94221133sand_y
sardar73013173sardar
sashay1238363sashay
satay84718463sa_tay
skyway1933343skyway
tardy94720463tard_y
tawdry13395253tawdry
today96416953_today
vanda94515923vanda_
vandal103713833vandal
vandas103915993vandas
waddly14478723waddly
waddy135312993wa_ddy
wady115324993wa_d_y
washday1743383washday
waylays1634673waylays
whydah1942953whydah
yay96948713__y_ay

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162465.95318934.3
3Display Results2462460.0763236.8
 (SQL Overall)1786912466.15529031.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.