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

273 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
mameyes1437698(None) 
mameys13449521mamey_s
gametes10312252gametes
mamboes135011822mamboes
mamey125418832mamey__
mamies104626242mam_ies
mammees104411142mammees
mammeys13376722mammey_s
mammies104314762mammies
maneges103612142maneges
mateys115610942matey_s
mimeses1139072mimeses
ramees84620892rame_es
abeles84719393_abeles
abyes105518533_a_byes
aedes64625153_a_edes
agametes1147293agametes
agenes74720253_agenes
akees96119243_ake_es
akenes104817343_akenes
amazes175613473_amazes
ambles105121863_ambles
amebas10311453_amebas
ameer75618983_ame_er
ameers84015573_ameers
amends94713283_amends
amens75624843_ame_ns
aments85219803_aments
amerces1149853_amerces
amices105018013_amices
amides95722663_amides
amies76837693_am_ies
amines84727983_amines
ammeter1148393ammeter
ammeters1237693ammeters
ammines11312673ammines
amoles84122193_amoles
amperes11313983amperes
amuses85117943_amuses
amyls104512693_am_yls
aneles64626293_aneles
apexes1539133_apexes
arenes64928393_arenes
aretes64425353_aretes
ayes76543513_a__yes
bareges105212033bareges
baryes116218503ba_ryes
bigeyes1335653bigeyes
bugeyes1335513bugeyes
camases114216343camases
camels105217083came_ls
cameoed1238383cameoed
cameos105818003came_os
cameras11313363cameras
cames97047313cam__es
camises114218463camises
cammies134016483cammies
cymenes1477413cymenes
damages11511283damages
dames85435853dam__es
deadeyes1344563deadeyes
emeses86114963_emeses
eyes75837883___eyes
faeces114713123fa_eces
fameless13259203fameless
fames105735923fam__es
famines123216263famines
galeres83514343galeres
gamays126310913gamay_s
gambes116318313gam_bes
gambles124016203gambles
gameness112810693gameness
gamers94420833game_rs
games86238553gam__es
gamete9313593gamete_
gamey115320553gamey__
gamines103618463gamines
haeres94017033ha_eres
hamates122917683hamates
hames106138703ham__es
homeys145012873homey_s
imamates1237663imamates
jambes175914053jam_bes
jammies183611293jammies
kames115024693kam__es
lambies113015113lambies
lamedhs13444703lamedhs
lameds94812033lame_ds
lameness102612673lameness
laments94314853laments
lames75445543lam__es
larees65323113lare_es
latexes1438313latexes
limeys11429273limey_s
mabes96331533ma__bes
macers105321273mace_rs
maces97139963ma__ces
maches134827233ma_ches
machetes1539633machetes
mackles154415753mackles
macles107023223ma_cles
macules114015133macules
madames12310063madames
madres93718183ma_dres
maes66948403ma___es
mages85036023ma__ges
magpies12310363magpies
magueys1333943maguey_s
mahoes11313103ma_hoes
mailes84329113ma_iles
maimers113813043maime_rs
maizes175115733ma_izes
makers123921733make_rs
makes115336853ma__kes
makeups1533603makeups
malates93522613malates
maleates103316343maleates
maleness10312313maleness
males75049793ma__les
malices114316623malices
malines93625603malines
mallees93315973mallees
malmseys1541903malmsey_s
mamas95930773mam__as
mambas125716243mam_bas
mamboed14417623mamboed
mambos125414493mam_bos
mamelukes1741903mamelukes
mamie95826003mam_ie_
mamluks1543313mamluks
mammae94613213mammae_
mammals10389273mammals
mammas94616403mam_mas
mammee94417853mam_mee
mammer94218863mam_mer
mammered12237653mammered
mammers104615693mammers
mammet94319253mam_met
mammets103911113mammets
mammey124310893mam_mey
mammie94313783mammie_
mammons1048513mammons
mammy115215163mammy__
mamzer19459833mam_zer
mamzers20409163mamzers
manages103418963manages
manches143818623manches
manege94113203manege_
maneless102812343maneless
manes76648963ma__nes
manges94628943ma_nges
mangles104021463mangles
mangoes104316133mangoes
manses84225513ma_nses
mantes84430783ma_ntes
mantles94820703mantles
manures9313353manures
maples104819423ma_ples
marbles114516653marbles
marches143921173marches
mares76457633ma__res
marges94525713ma_rges
marines93928013marines
marmites122212793marmites
marques182610863marques
marries93825283marries
marses84827113ma_rses
marshes123615373marshes
martyrs1234893martyrs
masers84623453mase_rs
mashes115030003ma_shes
mashies12318253mashies
masques18239363masques
masses85028713ma_sses
matches143219783matches
mateless102711293mateless
maters85032393mate_rs
mates75251363ma__tes
matey107022663matey__
mateyness1444473mateyness
matres84522233ma_tres
mattes85624533ma_ttes
matures9314313matures
maumets11369693maume_ts
mauves113811553ma_uves
mavens114312973mave_ns
mavies114923193ma_vies
mavises122812993mavises
maxes145629533ma__xes
maxixes1535253maxixes
mayas105924383ma__yas
maybes1339243ma_ybes
mayed115522403ma__yed
mayest114614793ma__yest
mayos105521933ma__yos
mays96940033ma__y_s
mazers173917093maze_rs
mazes165632173ma__zes
melees83618083mele_es
memes94927703__memes
meres75143573__meres
metameres1347453metameres
metes74736213__metes
mezes167719263__mezes
mimeoed1235193mimeoed
mimeos104511543mime_os
mimers105520183mime_rs
mimes95732023mim__es
mimesis1137323mimesis
mirexes1636993mirexes
moments113113123moments
momes95134473mom__es
mommies103912273mommies
momuses1159263momuses
moneyed1337493moneyed
moneyer1237903moneyer
moneyers1337423moneyers
moneys115513623money_s
mooneyes1396113mooneyes
moseyed1336133moseyed
moseys114711703mosey_s
muleys11409643muley_s
mumbles133014433mumbles
mummies103812843mummies
murexes1636973murexes
myceles1435213myceles
nameless10248373nameless
namers84517333name_rs
names74833363nam__es
nemeses948663nemeses
oxeyes1635893_oxeyes
pareses94718883pareses
payees114812903paye_es
racemes1139093racemes
ragees74618663rage_es
rakees104516973rake_es
rallyes10348553rallyes
rambles113118313rambles
ramee74633853rame_e_
ramets83517393rame_ts
ramies84630463ram_ies
ranees64623963rane_es
razees154314763raze_es
redeyes112910973redeyes
samechs14285353samechs
samekhs16303923samekhs
sameks12409323same_ks
sameness102712683sameness
samites93118713samites
samoyed1335893samoyed
samoyeds1442663samoyeds
samples112815453samples
sarees65329943sare_es
sememes11109203sememes
siameses1036403siameses
tagmemes1342833tagmemes
tamales93216153tamales
tameins9311423tameins
tameless10259903tameless
tameness102411253tameness
tamers84224033tame_rs
tames75242013tam__es
tamises92715973tamises
tammies113814683tammies
taxemes1635853taxemes
tmeses85712243_tmeses
vamoses1239143vamoses
walleyes1435603walleyes
wambles143714023wambles
wames106432803wam__es
wamuses1237023wamuses
waveys15597013wavey_s
yamens114010823yame_ns

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.423422437.4
2DLD Change Limit1340272738.65615483.7
3Display Results2732730.0932935.5
 (SQL Overall)1786912739.17219482.2
 
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.