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

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

223 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
mantes8443078(None) 
antes56334321_antes
manes76648951man_es
manges94628941manges
manses84225511manses
mantas85725361mantas
mantel84317971mantel
mantels94515041mantels
mantis83926031mantis
mantles94820701mantles
mates75251361ma_tes
mattes85624531mattes
montes84226931montes
anes45255932_an_es
antas55432032_antas
ante46538902_ante_
anted66328242_anted
antis55033312_antis
antres65021002_antres
ants47243472_ant_s
ates45047922_a_tes
banes74945582ban_es
banter84825332banter
banters94623112banters
banties94324762banties
bastes85330382bastes
bates75846342ba_tes
canes75350372can_es
canoes84725882canoes
canted94825782canted
canter85230112canter
canters94827722canters
cantles94721412cantles
cantos84826972cantos
cants77036942cant_s
cantus85117762cantus
cartes86239472cartes
castes85631862castes
cates75951872ca_tes
contes84432912contes
dances95120652dances
dates65639152da_tes
emanates10311332emanates
enates64026422enates
fanes84639892fan_es
fates85139232fa_tes
gates65939502ga_tes
gentes75324162gentes
hances115621282hances
hanses95022632hanses
hanted104124312hanted
hantles104117512hantles
hants86335402hant_s
hastes95727072hastes
hates86742572ha_tes
janes124928122jan_es
kanes95529372kan_es
kentes105118642kentes
lances84824102lances
lanes54946792lan_es
lattes65324202lattes
mabes96331532ma_bes
maces97139962ma_ces
maches134827232maches
macles107023222macles
madres93718182madres
maes66948392ma__es
mages85036022ma_ges
magnates11511602magnates
magnets10311142magnets
mahoes11313102mahoes
mailes84329112mailes
maizes175115732maizes
makes115336852ma_kes
malates93522602malates
males75049792ma_les
malted94819852malted
malteds10377602malteds
malts76331752malt_s
mamies104626242mamies
manages103418962manages
manas76240422man_as
manatee9317662manatee
manatees10310422manatees
manats84623462manats
manches143818622manches
mandates11314092mandates
mane65052012man_e_
maned86634092man_ed
maneges103612142maneges
mangas94122922mangas
mange84930182mange_
mangel94017532mangel
mangels103614492mangels
manger94325002manger
mangers103521262mangers
mangey123614522mangey
mangles104021462mangles
mangoes104316132mangoes
mangos94319332mangos
manias84029032manias
manics103919932manics
manitos9314052manitos
manitus9310922manitus
manless93012932manless
mannas85019802mannas
manned94418642manned
manner84020512manner
manners93417832manners
mannites10312612mannites
manors84420882manors
manos74933612man_os
mans66354532man__s
manse75528222manse_
manta75629902mant_a
manteau937862manteau
manteaus1036382manteaus
mantic104120902mantic
mantid93820372mantid
mantids103113622mantids
mantises10317922mantises
mantle84420922mantle
mantled104113392mantled
mantlet93620992mantlet
mantlets104611202mantlets
mantra84116092mantra
mantras93815862mantras
mantua84412022mantua
mantuas93410992mantuas
manures9313352manures
manus75924922man_us
maples104819422maples
mares76457632ma_res
marges94525712marges
marses84827112marses
marted94425212marted
marten84518262marten
martens93714952martens
marts77442232mart_s
mashes115030002mashes
masses85028712masses
masted94025802masted
master84831342master
masters94628922masters
masts77035762mast_s
mate65154212ma_te_
mated85537782ma_ted
mater74438862ma_ter
maters85032382ma_ters
matey107022662ma_tey
mateys115610942ma_teys
maths105624022ma_ths
matres84522232matres
mats65460282ma_t_s
matte75626842matte_
matted94521412matted
matter84325342matter
matters94421752matters
matts76829182ma_tts
mauts75927192maut_s
mauves113811552mauves
mavies114923192mavies
maxes145629532ma_xes
maybes1339242maybes
mazes165632172ma_zes
meanies93620742meanies
menses84222452menses
mentee84121292mentee
mentees93214502mentees
metes74736212m_etes
minces104420802minces
mines75651952min_es
minkes124618782minkes
minted94220582minted
minter84425102minter
minters93822462minters
mints76834042mint_s
minutes93513432minutes
minxes154612982minxes
mites75141802m_ites
mondes94322352mondes
monies83233162monies
monte75829772monte_
months113812932months
motes75944002m_otes
mottes85523692mottes
mutes75033782m_utes
nances83618642nances
nates55238332na_tes
panes76148692pan_es
pannes85522852pannes
panted95024822panted
panties94230932panties
pantos85222742pantos
pants76536922pant_s
pastes85233912pastes
pates76047892pa_tes
pontes83627852pontes
rances84625442rances
ranees64623962ranees
ranges73826922ranges
ranted74324702ranted
ranter63826822ranter
ranters73323642ranters
rants55935342rant_s
rates55352012ra_tes
rentes65431192rentes
sanes55649072san_es
sanies63031952sanies
santos64421832santos
sates54949322sa_tes
sautes63924912sautes
tastes64126422tastes
tates55444982ta_tes
vanes85130972van_es
wanes85040882wan_es
wanted104319722wanted
wanter94423052wanter
wanters104420092wanters
wants87932212want_s
wastes96224882wastes
yentes95517602yentes
zanies153219672zanies

Search took 3 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 Filter178691825510.1401276364.3
2DLD Change Limit825512232.62631436.0
3Display Results2232230.0633539.7
 (SQL Overall)1786912232.82963164.0
 
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.