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

276 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
method123902(None) 
methods1338881methods
ephod1139122_ephod
ethos85514192_ethos
menthol1236722menthol
meshed124415932meshed
meted85424432met_ed
meteor84910072meteor
meth95827842meth__
methodic1656912methodic
methoxy2243942methoxy
meths105320232meth_s
methyl1436402methyl
metol75917812met_ol
metred95315142metred
metro74718802metro_
metros84217802metros
mythoi14417132mythoi
mythos14398462mythos
reshod103012232reshod
aether94213673aether
altho86312603altho_
anethol1045383anethol
anthoid11313313anthoid
author939763author
bathed125518743bathed
bathos116215633bathos
behold1247343be_hold
benthon1237693benthon
benthos1238373benthos
berthed13259123berthed
beth96629233beth__
bethel1169643bethel
bethorn1238643bethorn
beths105519223beth_s
beton76022063bet_on
betook12439603betook
betted94721163betted
bettor83612223bettor
cathode1338993cathode
detox13310953det_ox
eched116919223_eched
echo96615953_echo_
echoed125211153_echoed
echos105216463_echos
emerod9139213emerod
ephods1238363_ephods
ephor10310013_ephor
etched123613703_etched
eth66630983_eth__
ether84518773_ether
ethic101511223_ethic
ethion938813_ethion
ethmoid1345803_ethmoid
ethnos947053_ethnos
ethoxy1933923_ethoxy
eths76619523_eth_s
ethyl1136513_ethyl
fathom1437473fathom
feod815523003fe__od
fetched163710473fetched
feted94420933fet_ed
fetid93715983fet_id
fetor81214533fet_or
fetted104817893fetted
heth107028023heth__
heths116317783heth_s
hod76852463___hod
hotrod1048803hotrod
jehad1637683je_had
jeton124815403jet_on
jetsom15126143jetsom
jetted143915083jetted
jetton1338033jetton
kathode1545733kathode
keto86223453ket_o_
ketol95414003ket_ol
kithed144613013kithed
kythed17407313kythed
lathed104718453lathed
leched123716003leched
letched133912053letched
lethal939803lethal
lethe85717303leth_e
lethes94818083lethes
letted74118543letted
litho86513783litho_
lithoed1137833lithoed
lithoid1148773lithoid
lithos94212553lithos
macho126120153macho_
machos135217493machos
mahoe10315573m_ahoe
manhood1338993manhood
mashed125325043mashed
matched153513963matched
mated85537783mat_ed
math95437453math__
maths105624023math_s
matron83918313matron
matted94521413matted
mattoid1079283mattoid
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
mead75531603me__ad
meadow1237403meadow
meated94222403meated
meathead1436793meathead
med66146743me___d
mediad104313713mediad
meed74934703me__ed
megapod1344893megapod
megohm14124193megohm
mehndi1233153me_hndi
meld75830473me__ld
melded104714713melded
melled95023023melled
mellow114112223mellow
melody1237203me_lody
meloid9616003meloid
melon73922083me_lon
melted94219063melted
melton8311553melton
memo85924793me_mo_
memos95719113me_mos
menad85918983me_nad
mend75334033me__nd
mended104418683mended
menhir1136783menhir
meno66031363me_no_
mensed93916543mensed
menthols1347033menthols
mention9314373mention
mentor8414363mentor
menudo945793menudo
meou65325863me__ou
meoued9118533meoued
meow95117883me__ow
meowed12148003meowed
merged104214943merged
merlon83012353merlon
merlot83217603merlot
mesh96823003mesh__
meshes115019443meshes
meshy135612783mesh_y
meson74118313me_son
messed95018183messed
met56072433met___
meta65932413met__a
metage93114453metage
metal75427383met_al
metaled102913883metaled
metals84520883metals
metaphor1544913metaphor
metate82720533metate
metazoa1845543metazoa
mete64438133met__e
meteors94610013meteors
metepa1066013metepa
meter75130323met_er
metered103514013metered
meters85625833meters
metes74736213met_es
methadon1444523methadon
methane123211793methane
methanol1344643methanol
methodise1545513methodise
methodism1745233methodism
methodist1547013methodist
methodize2445713methodize
methoxide2244173methoxide
methoxyl2342733methoxyl
methyls1535453methyls
metier83517693metier
meting94320593meting
metis75025903met_is
metols84115773metols
metope10611123metope
metopon11137073metopon
metre74821303met_re
metres85121563metres
metric10314673metric
mettle83815723mettle
mettled103510543mettled
metump1235713metump
mewed115218013me_wed
mewled123710053mewled
mezzo1537433mezzo_
mezzos1635053mezzos
mho86624623m__ho_
mhos95517773m__hos
miched143913393miched
misshod1335873misshod
mither114218563mither
mitred94414343mitred
mod69054403m___od
mood76332063m__ood
moshed124517493moshed
moth96731333moth__
mother113718643mother
moths106021553moth_s
mothy136214553moth_y
motion85217553motion
motmot10311073motmot
motor75317293mot_or
motto76119513motto_
mottos84615243mottos
mouthed133811043mouthed
mucho125013443mucho_
mushed124420843mushed
muted85023383mut_ed
muton73817003mut_on
mutton8510453mutton
myth126715433myth__
mythic1637273mythic
myths135911603myth_s
mythy16568673myth_y
nether94014163nether
netop7312343net_op
netted74118713netted
ortho8312293ortho_
pathos115516693pathos
peched144915343peched
period9314983period
pernod9310453pernod
petard95013803petard
petrol82714063petrol
petted94121523petted
petto76021043petto_
pithed124615613pithed
pothos114214693pothos
python1447143python
reshoe92816483reshoe
reshoed112212153reshoed
reshot93519633reshot
reshow123111433reshow
resod64720053re_sod
retard75018933retard
retched133814273retched
retied75924983retied
retold73013753retold
retook104313443retook
retool63914483retool
retro55020953retro_
retros63820193retros
retted74826313retted
seethed113410193seethed
senhor93010803senhor
seton55223543set_on
shod86225063__shod
stood65517713_stood
teched124014433teched
teethed11318623teethed
tetched133010773tetched
teth76327893teth__
tether93716103tether
teths85418513teth_s
tetrad73612053tetrad
tetrode839343tetrode
tho67433963__tho_
thou76722213__thou
thud85613913__thud
tithed104115593tithed
tod49457073__t_od
trod57627953__trod
tythed13457503tythed
unshod1067603unshod
untrod769853untrod
veto76622993vet_o_
vetoed10359823vetoed
vetted104316323vetted
wether123315393wether
wetted103717023wetted
withed134416233withed

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.1401276364.3
2DLD Change Limit1127162765.43620735.1
3Display Results2762760.0962875.0
 (SQL Overall)1786912765.67231504.1
 
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.