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

304 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
margays133749(None) 
margay12310591margay_
argals75517712_argals
arrays95311682_arrays
mangas94122922manga_s
maras75443282mar_a_s
marges94525712marg_es
margins103815192margins
markas124717002marka_s
marrams11310122marrams
maydays1634492maydays
morays114613882mor_ays
morgans10310122morgans
parlays123910452parlays
agars66120643_a_gars
agas55938843_a_ga_s
airways1336243airways
algas65624933_alga_s
allays94313743_allays
always12409133_always
amalgams1343203amalgams
amigas95912173amiga_s
angas65827983_anga_s
araks94820883_ar_aks
areas55935773_area_s
argal65023393_arga_l
argala74712673_argala
argalas84011093_argalas
argali75013753_argali
argalis84214193_argalis
argils75213623_argils
argles75218483_argles
argols74514613_argols
argons75018203_argons
argosy1036423_argosy
argots74116023_argots
argues74516413_argues
argus66716543_arg_us
arhats9312973_arhats
arias55438023_aria_s
arras55626133_arra_s
array86317143_array_
assays977903_assays
avgas96912133_avga_s
bagass938933ba_gass
barcas101016603barca_s
bargain1079063bargain
bargains1178643bargains
bargees105415873bargees
barges94528253barg_es
barleys125011843barleys
barneys12569563barneys
brays106723113_br_ays
carats85929023car_ats
caraways1636943caraways
carboys144711783carboys
carcass11310513carcass
cargoes104415223cargoes
cargos94619183carg_os
carneys124310543carneys
carpals113414623carpals
daggas937973dagga_s
darbars10510093darbars
darkeys15356533darkeys
derays105514253der_ays
drays95819773_dr_ays
earlaps936393earlaps
fairways1743873fairways
fangas105017193fanga_s
faradays1544273faradays
farads104713273far_ads
farfals13268503farfals
forays124813003for_ays
frays116920103_fr_ays
gamays126310913ga_mays
gangways1643733gangways
garages9314113garages
garganeys1442613garganeys
gargets94614573gargets
gargles94214893gargles
garveys14124463garveys
gays87338023___gays
grays95621333_gr_ays
hangars114313493hangars
harass9313943har_ass
hardass1139753hardass
hartals10313023hartals
hearsays1444513hearsays
hurrays13386153hurrays
jagras1438463jagra_s
jargons1558203jargons
jarrahs1735453jarrahs
jarveys20123413jarveys
karats106420493kar_ats
karmas123013733karma_s
kurgans12145653kurgans
lagans75717783la_gans
laogais845813laogais
larges74824233larg_es
largess8408913largess
largos74815063larg_os
lariats7615053lariats
larvas9310233larva_s
maars74621633ma__ars
macaws1337023ma_caws
madams11310943ma_dams
madcaps1435243madcaps
madras94316433madra_s
madrigals13856233madrigals
maenads1037373maenads
mafias113913573mafia_s
mages85036023ma_g_es
maggots1136553maggots
magians10310753magians
magics115311613ma_gics
magmas115512503ma_gmas
magots9312363ma_gots
mags75444523ma_g__s
magueys1333943magueys
magus85318753ma_g_us
makars124612633ma_kars
malars85020683ma_lars
mamas95930773ma_ma_s
mambas125716243mamba_s
mameys13449523ma_meys
mammals10389273mammals
mammas94616403mamma_s
mammeys13376723mammeys
manages103418963manages
manas76240423ma_na_s
manats84623463ma_nats
manga85026193manga__
mangabeys1742033mangabeys
mangaby1535353mangaby
mangels103614493mangels
mangers103521263mangers
manges94628943mang_es
mangey123614523mangey_
mangles104021463mangles
mangoes104316133mangoes
mangos94319333mang_os
mangy115021233mang_y_
maniacs114313063maniacs
manias84029033mania_s
mannans93611523mannans
mannas85019803manna_s
mantas85725363manta_s
manuals9311213manuals
mara67444563mar_a__
maraca10314153mar_aca
maracas11313773maracas
maraud938943mar_aud
marauds1037553marauds
marbles114516653marbles
marbly134111933marbly_
marcato1139743marcato
marcatos1249163marcatos
marcels113212373marcels
marches143921173marches
marcs95726623mar__cs
mares76457633mar__es
margaric1346063margaric
margarin1148073margarin
margarins1248293margarins
marge85328333marg__e
margent10316693margent
margents11410133margents
margin94016843marg_in
marginals1246003marginals
margrave1444793margrave
margraves1544833margraves
maria75032883maria__
marinas93519383marinas
marines93928013marines
marka114620793marka__
markers133516103markers
markets133314033markets
markkas12356083markkas
marks115933483mar__ks
markups1534963markups
marlins93420473marlins
marls75535163mar__ls
marly106925613mar_ly_
marmots11311513marmots
maroons92615553maroons
marques182610863marques
marquis18247063marquis
marram10313883marra_m
marrano939423marrano
marranos1038413marranos
marrers93414313marrers
marries93825283marries
marrons93216973marrons
marrows122911813marrows
marry104821693mar_ry_
mars66261863mar___s
marsala939583marsala
marsalas1038253marsalas
marses84827113mar_ses
marshals1337783marshals
marshes123615373marshes
marshy14558333marshy_
martens93714953martens
martians103111613martians
martins93322063martins
marts77442233mar__ts
martyr1135693mar_tyr
martyrs1234893martyrs
marvels123810093marvels
marvy135014033mar_vy_
masas75630413ma_sa_s
massas85116463massa_s
mateys115610943ma_teys
matrass939403matrass
matsahs1236563matsahs
matzahs2134483matzahs
matzas1749703matza_s
mayas105924383ma_ya_s
mayday1535883mayday_
mays96940023m___ays
megass9219443m_egass
mergees104411233mergees
mergers103813423mergers
merges94122483merg_es
middays14335663middays
midways16386183midways
mirages102213533mirages
mirzas1738183mirza_s
mislays12349243mislays
missays124010253missays
morals85324633mor_als
moras76438773mor_a_s
morass84614493mor_ass
moray105423793mor_ay_
morgan9311373morga_n
morgens10310463morgens
morgues1038273morgues
mortals93914003mortals
mortars93411523mortars
muggars11316643muggars
murals84016753mur_als
muras75329563mur_a_s
murras84916003murra_s
murreys12367323murreys
myriads1334353myriads
narwals1036983narwals
naysays1344123naysays
nongays11176533nongays
organs7912913_organs
pagans95717923pa_gans
pangas99921103panga_s
paras76143043par_a_s
pardahs13289673pardahs
parges94529543parg_es
pargets105215193pargets
pargos95719043parg_os
pariahs123812343pariahs
parians93519733parians
parkas125018023parka_s
parkways2043973parkways
parlay113713993parlay_
parleys125212373parleys
parrals94414573parrals
partans94418283partans
paydays1634433paydays
prays105022433_pr_ays
ragas65326063ra_ga_s
rays77642353__r_ays
sagas66025883sa_ga_s
saggars93610683saggars
saigas74114293saiga_s
sangars83116253sangars
sangas75222653sanga_s
sarans64224433sar_ans
sardars83112903sardars
sargasso942253sargasso
sarges75128593sarg_es
sargos74318273sarg_os
sarsars73512143sarsars
sashays1336333sashays
satays94411683sa_tays
smaragds1243303smaragds
smartass1044273smartass
sprays115913643spr_ays
strays96417933str_ays
tagrags936123tagrags
taigas73712563taiga_s
targes74524593targ_es
targets84314223targets
tarmacs1138323tarmacs
tarpans92513533tarpans
tarsals72512603tarsals
tartans72615823tartans
tartars73313403tartars
tarzans16329923tarzans
teargas837013tearga_s
trays85623433_tr_ays
varas86028193var_a_s
varias95019903varia_s
varnas94212823varna_s
virgas1048883virga_s
wangans1149503wangans
warsaws1335763warsaws
waylays1634673waylays

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.1561145455.1
2DLD Change Limit1340273047.53017799.1
3Display Results3043040.1102763.6
 (SQL Overall)1786913047.79622920.9
 
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.