Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “medlar” with Change Limit: [1] [2] [3]

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

391 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
medlar	9	30	1046	(None)
medlars	10	25	944	1	medlars
pedlar	9	33	1127	1	pedlar
bedlam	11	4	927	2	bedlam
cedar	8	40	1432	2	ced_ar
cellar	8	45	1498	2	cellar
malar	7	64	2444	2	m_alar
medal	8	62	2133	2	med_al
medals	9	42	1806	2	medals
meddler	11	31	995	2	meddler
media	8	47	2171	2	media_
mediad	10	43	1371	2	mediad
mediae	9	42	1741	2	mediae
medial	9	38	1986	2	medial
median	9	41	1754	2	median
medias	9	36	2078	2	medias
medley	12	9	834	2	medley
medullar	11	4	346	2	medullar
melder	9	39	1581	2	melder
mewler	11	35	1023	2	mewler
modular	10	8	736	2	modular
molar	7	52	2309	2	m_olar
mudlark	14	6	391	2	mudlark
mylar	10	53	1153	2	m_ylar
pedlars	10	32	1021	2	pedlars
pedlary	13	27	754	2	pedlary
pedler	9	36	1462	2	pedler
redear	7	35	1517	2	redear
velar	8	58	1763	2	ve_lar
alar	4	63	4007	3	__alar
alular	6	3	1136	3	alular
areolar	7	7	922	3	areolar
ashlar	9	33	820	3	ashlar
bear	6	68	4464	3	be__ar
bedder	10	42	1579	3	bedder
bedlamp	14	6	451	3	bedlamp
bedlams	12	3	705	3	bedlams
bedpan	11	3	758	3	bedpan
bedward	14	9	747	3	bedward
bedwarf	16	10	646	3	bedwarf
beflag	12	6	588	3	beflag
beggar	10	32	822	3	beggar
beglad	10	13	846	3	beglad
belay	10	50	2152	3	be_lay
beldam	11	4	1011	3	beldam
bezoar	17	3	691	3	bezoar
bolar	7	51	2347	3	_bolar
cedarn	9	40	844	3	ced_arn
cedars	9	33	1283	3	ced_ars
cedary	12	41	960	3	ced_ary
ceder	8	53	2224	3	ced_er
cedula	9	7	764	3	cedula_
cedulas	10	5	850	3	cedulas
ceiler	8	40	1396	3	ceiler
cella	7	54	2031	3	cella_
cellae	8	49	1593	3	cellae
cellars	9	37	1369	3	cellars
cheddar	14	25	473	3	cheddar
collar	8	38	1617	3	collar
dealer	7	41	2214	3	dealer
dear	5	53	4360	3	__dear
debar	8	55	1786	3	de_bar
declare	10	4	1123	3	declare
declaw	12	6	670	3	declaw
dedal	7	57	1902	3	ded_al
delay	9	48	2063	3	de_lay
denar	6	52	2329	3	de_nar
deodar	8	3	771	3	deodar
dewar	9	58	1773	3	de_war
dewlap	12	6	484	3	dewlap
dollar	7	41	1098	3	dollar
ear	3	68	6788	3	_e__ar
eclair	8	3	681	3	_eclair
eclat	7	5	2360	3	_eclat
edger	7	52	1595	3	_edger
eggar	7	45	888	3	_eggar
elan	4	67	3424	3	_e_lan
elder	6	40	2002	3	_elder
embar	9	40	1160	3	_embar
endear	7	41	1001	3	endear
escar	7	40	1199	3	_escar
eskar	9	45	745	3	_eskar
fear	7	53	3779	3	fe__ar
fedora	10	3	859	3	fedora
feeler	9	32	1517	3	feeler
fella	8	49	1865	3	fella_
fellah	12	49	1077	3	fellah
fellas	9	51	1696	3	fellas
feller	9	44	1955	3	feller
feuar	8	3	1024	3	fe_uar
filar	8	48	1929	3	_filar
gear	5	59	3497	3	ge__ar
gelder	8	46	1371	3	gelder
gular	6	3	1483	3	_gular
healer	9	42	2180	3	healer
hear	7	61	4388	3	he__ar
heder	9	56	2364	3	hed_er
hedger	11	49	1265	3	hedger
heeler	9	39	1732	3	heeler
heller	9	33	2251	3	heller
hilar	8	54	1814	3	_hilar
idler	6	50	1566	3	_idler
jetlag	14	3	452	3	jetlag
kebar	11	51	1353	3	ke_bar
keblah	15	4	531	3	keblah
keddah	15	3	427	3	keddah
kegler	11	39	824	3	kegler
ladler	7	43	1493	3	ladler
lamellar	10	9	651	3	lamellar
lar	3	79	6753	3	___lar
lear	4	70	4595	3	le__ar
ledger	8	59	1439	3	ledger
lekvar	13	3	304	3	lekvar
lidar	6	3	1273	3	lid_ar
maar	6	60	2506	3	m__aar
macular	11	30	1195	3	macular
madam	10	3	1622	3	mad_am
madcap	13	3	633	3	madcap
madder	10	35	1559	3	madder
madly	11	52	1813	3	madl_y
madman	11	37	1239	3	madman
madras	9	43	1643	3	madras
mailer	8	47	2418	3	mailer
makar	11	56	1497	3	m_akar
malars	8	50	2068	3	m_alars
mallard	10	3	1027	3	mallard
mar	5	79	6595	3	m___ar
mauler	8	44	1671	3	mauler
mead	7	55	3160	3	me__ad
meager	9	45	1520	3	meager
meal	6	56	4317	3	me__al
mealie	8	25	1981	3	mealie
mealier	9	30	1590	3	mealier
meals	7	59	3338	3	meal_s
mealy	10	44	2218	3	meal_y
mean	6	55	3809	3	me__an
meaner	8	46	1784	3	meaner
meat	6	63	5960	3	me__at
meatal	8	41	1473	3	meatal
mecca	11	3	993	3	mecca_
meccas	12	3	949	3	meccas
med	6	61	4675	3	med___
medaka	13	3	634	3	medaka
medakas	14	3	576	3	medakas
medaled	11	34	1161	3	medaled
meddle	10	33	1276	3	meddle
meddled	12	32	1003	3	meddled
meddlers	12	31	820	3	meddlers
meddles	11	32	1325	3	meddles
medevac	15	5	352	3	medevac
medfly	15	3	522	3	medfly
mediacy	15	3	614	3	mediacy
medials	10	39	1474	3	medials
medians	10	32	1421	3	medians
mediant	10	35	1670	3	mediant
mediate	10	34	1521	3	mediate
mediator	11	3	905	3	mediator
medic	10	46	1965	3	med_ic
medical	12	3	1251	3	medical
medicare	13	4	748	3	medicare
medick	15	40	1013	3	medick
medico	11	37	1116	3	medico
medics	11	41	1535	3	medics
medigap	13	7	462	3	medigap
medii	8	45	1349	3	med_ii
medina	9	41	1409	3	medina
medinas	10	34	1146	3	medinas
medium	11	37	1162	3	medium
medius	9	36	1328	3	medius
medivac	15	5	469	3	medivac
medleys	13	11	533	3	medleys
meds	7	57	3537	3	med__s
medulla	10	4	471	3	medulla
medullae	11	4	320	3	medullae
medullary	15	4	224	3	medullary
medullas	11	4	451	3	medullas
medusa	9	3	629	3	medusa
medusae	10	4	476	3	medusae
medusal	10	3	518	3	medusal
medusan	10	4	471	3	medusan
medusas	10	3	621	3	medusas
meeker	12	35	998	3	meeker
meeter	8	36	1650	3	meeter
mega	7	76	2087	3	me_ga_
megabar	12	4	450	3	megabar
megara	9	3	1009	3	me_gara
mel	5	60	4748	3	me_l__
meld	7	58	3047	3	me_l_d
melded	10	47	1471	3	melded
melders	10	32	1391	3	melders
melds	8	48	2238	3	me_lds
melee	7	37	2910	3	me_lee
melic	9	47	2233	3	me_lic
mell	6	49	3561	3	me_l_l
melled	9	50	2302	3	melled
mellow	11	41	1222	3	mellow
mells	7	50	3133	3	me_lls
melon	7	39	2208	3	me_lon
mels	6	59	4153	3	me_l_s
melt	6	57	5289	3	me_l_t
melter	8	35	2011	3	melter
melts	7	49	3010	3	me_lts
melty	10	49	1836	3	me_lty
member	12	25	885	3	member
memoir	10	3	721	3	memoir
menad	8	59	1898	3	me_nad
mender	9	35	2079	3	mender
menhir	11	3	678	3	menhir
menial	8	42	2303	3	menial
mensa	7	53	1867	3	mensa_
mensae	8	41	1405	3	mensae
mensal	8	46	1566	3	mensal
mensas	8	51	1586	3	mensas
menta	7	44	2442	3	menta_
mental	8	45	2160	3	mental
mentor	8	4	1436	3	mentor
mercer	10	52	1420	3	mercer
merer	7	51	2623	3	me_rer
merger	9	50	1648	3	merger
merl	6	58	3097	3	merl__
merle	7	58	2437	3	merl_e
merles	8	53	2276	3	merles
merlin	8	39	1669	3	merlin
merlon	8	30	1235	3	merlon
merlot	8	32	1761	3	merlot
merls	7	74	2390	3	merl_s
merman	10	5	1387	3	merman
mesa	6	70	2548	3	me_sa_
mesas	7	68	2320	3	me_sas
mescal	10	41	1349	3	mescal
mesial	8	48	1808	3	mesial
mesian	8	43	1550	3	mesian
messan	8	39	1206	3	messan
meta	6	59	3241	3	me_ta_
metal	7	54	2738	3	me_tal
metals	8	45	2089	3	metals
meteor	8	49	1007	3	meteor
meter	7	51	3032	3	me_ter
metier	8	35	1769	3	metier
mewl	9	56	1832	3	mewl__
mewled	12	37	1005	3	mewled
mewlers	12	28	898	3	mewlers
mewls	10	58	1323	3	mewl_s
mezcal	19	36	785	3	mezcal
micellar	12	10	557	3	micellar
midair	9	3	799	3	midair
midcap	13	3	647	3	midcap
midday	13	32	750	3	midday
middler	11	27	1227	3	middler
midland	11	3	661	3	midland
midleg	10	3	855	3	midleg
midway	15	32	715	3	midway
midyear	13	4	334	3	midyear
milder	9	38	1845	3	milder
miler	7	57	3306	3	m_iler
miller	8	46	2541	3	miller
mimbar	12	9	749	3	mimbar
mislay	11	35	1068	3	mislay
modal	8	59	1924	3	mod_al
modals	9	39	1446	3	modals
modeler	10	3	929	3	modeler
modulars	11	6	583	3	modulars
moiler	8	40	1726	3	moiler
mola	6	60	3563	3	m_ola_
molal	7	51	2034	3	m_olal
molars	8	55	1732	3	m_olars
molas	7	51	3209	3	m_olas
molder	9	38	1927	3	molder
mollah	11	31	945	3	mollah
moola	7	51	1703	3	moola_
moolah	11	40	919	3	moolah
moolas	8	36	1559	3	moolas
mortar	8	38	1204	3	mortar
morular	9	7	822	3	morular
mudcap	13	3	513	3	mudcap
mudcat	11	3	1120	3	mudcat
mudder	10	44	1349	3	mudder
muddler	11	34	1162	3	muddler
mudflap	15	4	218	3	mudflap
mudflat	13	6	488	3	mudflat
mudlarks	15	4	288	3	mudlarks
mudra	8	39	1243	3	mudra_
mudras	9	42	1226	3	mudras
muggar	10	31	644	3	muggar
mulla	7	43	1711	3	mulla_
mullah	11	37	1073	3	mullah
mullas	8	42	1593	3	mullas
muller	8	38	2035	3	muller
mutular	9	3	665	3	mutular
mylars	11	43	1044	3	m_ylars
near	4	52	3650	3	ne__ar
nebular	9	5	649	3	nebular
nectar	8	3	885	3	nectar
needler	8	38	889	3	needler
nodular	8	7	670	3	nodular
ocellar	9	3	653	3	ocellar
ocular	8	6	1014	3	ocular
ovular	9	4	683	3	ovular
pear	6	97	4523	3	pe__ar
pedal	8	60	2250	3	ped_al
pedaler	10	34	1069	3	pedaler
pedalo	9	38	1115	3	pedalo
pedals	9	43	1603	3	pedals
peddler	11	32	1049	3	peddler
pedlers	10	30	1327	3	pedlers
pedlery	13	29	708	3	pedlery
peeler	8	35	1738	3	peeler
pendular	11	4	494	3	pendular
pepla	9	3	1286	3	pepla_
phylar	14	43	737	3	phylar
pilar	7	52	2150	3	_pilar
pillar	8	3	1402	3	pillar
polar	7	56	2345	3	_polar
poplar	10	36	1111	3	poplar
radar	6	13	1672	3	rad_ar
radular	8	3	784	3	radular
realer	6	35	2859	3	realer
realgar	8	3	487	3	realgar
rear	4	56	4455	3	re__ar
rebar	7	54	2019	3	re_bar
reclad	9	3	1187	3	reclad
redan	6	61	2501	3	red_an
redbay	12	3	833	3	redbay
redcap	11	5	849	3	redcap
redder	8	39	1814	3	redder
redears	8	28	1445	3	redears
redia	6	55	2448	3	redia_
rediae	7	42	2199	3	rediae
redial	7	49	2311	3	redial
redias	7	45	2361	3	redias
redleg	8	3	927	3	redleg
redly	9	42	1720	3	redl_y
redraw	10	26	985	3	redraw
redware	11	3	936	3	redware
reeler	6	38	2257	3	reeler
reflag	10	9	808	3	reflag
regear	7	35	1274	3	regear
regular	8	3	842	3	regular
rehear	9	37	1322	3	rehear
relax	12	48	1780	3	re_lax
relay	8	44	2467	3	re_lay
replan	8	32	1582	3	replan
replay	11	34	1292	3	replay
retear	6	31	1548	3	retear
rewear	9	30	1200	3	rewear
scalar	8	36	1244	3	scalar
sealer	6	39	2896	3	sealer
sear	4	73	5384	3	se__ar
secpar	10	3	793	3	secpar
secular	9	22	1154	3	secular
sedan	6	56	2042	3	sed_an
seder	6	48	2676	3	sed_er
seggar	8	35	781	3	seggar
selah	8	3	1961	3	se_lah
seller	6	38	2460	3	seller
sewar	8	54	2110	3	se_war
sidler	7	47	1696	3	sidler
smear	7	44	1639	3	sme__ar
smeller	9	42	1279	3	smeller
solar	5	59	2734	3	_solar
stelar	6	40	1386	3	stelar
stellar	7	26	1044	3	stellar
stylar	9	35	811	3	stylar
talar	5	62	2538	3	_talar
tear	4	52	4288	3	te__ar
tedder	8	33	1216	3	tedder
tegular	8	3	660	3	tegular
tela	4	55	3297	3	te_la_
telae	5	43	2329	3	te_lae
teller	6	35	1983	3	teller
templar	11	4	564	3	templar
tesla	5	56	1260	3	tesla_
teslas	6	42	1217	3	teslas
tolar	5	55	2411	3	_tolar
umbellar	12	4	364	3	umbellar
undular	8	3	713	3	undular
uvular	9	5	557	3	uvular
vealer	9	40	1654	3	vealer
veiler	9	38	1435	3	veiler
vela	7	57	2554	3	ve_la_
velars	9	39	1372	3	ve_lars
venular	10	3	768	3	venular
volar	8	69	1741	3	_volar
wear	7	58	3672	3	we__ar
wedder	11	36	1230	3	wedder
welder	10	29	1441	3	welder
weldor	10	31	765	3	weldor
year	7	65	3425	3	ye__ar
yeller	9	42	1451	3	yeller
yodler	10	38	994	3	yodler
zedoary	20	4	321	3	zedoary

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	112716	0.376	475242.0
2	DLD Change Limit	112716	391	5.563	20261.7
3	Display Results	391	391	0.123	3178.9
	(SQL Overall)	178691	391	6.062	29477.2