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

Here are the results of your fuzzy-string dictionary search for “medlars” 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.

309 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
medlars	10	25	944	(None)
medlar	9	30	1046	1	medlar_
pedlars	10	32	1021	1	pedlars
bedlams	12	3	705	2	bedlams
cedars	9	33	1283	2	ced_ars
cellars	9	37	1369	2	cellars
malars	8	50	2068	2	m_alars
medals	9	42	1805	2	med_als
meddlers	12	31	820	2	meddlers
medials	10	39	1473	2	medials
medians	10	32	1421	2	medians
medias	9	36	2078	2	media_s
medleys	13	11	533	2	medleys
melders	10	32	1391	2	melders
mewlers	12	28	898	2	mewlers
modulars	11	6	583	2	modulars
molars	8	55	1732	2	m_olars
mudlark	14	6	391	2	mudlark
mudlarks	15	4	288	2	mudlarks
mylars	11	43	1044	2	m_ylars
pedlar	9	33	1127	2	pedlar_
pedlary	13	27	754	2	pedlary
pedlers	10	30	1327	2	pedlers
redears	8	28	1445	2	redears
velars	9	39	1372	2	ve_lars
ashlars	10	29	706	3	ashlars
bears	7	57	3904	3	be__ars
bedders	11	35	1338	3	bedders
bedlam	11	4	927	3	bedla_m
bedlamp	14	6	451	3	bedlamp
bedlamps	15	4	366	3	bedlamps
bedless	10	3	970	3	bedless
bedpans	12	3	717	3	bedpans
bedward	14	9	747	3	bedward
bedwards	15	9	639	3	bedwards
bedwarf	16	10	646	3	bedwarf
bedwarfs	17	11	358	3	bedwarfs
beflags	13	5	549	3	beflags
beggars	11	37	822	3	beggars
beglads	11	12	726	3	beglads
belays	11	43	1385	3	be_lays
beldams	12	3	705	3	beldams
bezoars	18	3	679	3	bezoars
cedar	8	40	1432	3	ced_ar_
cedarn	9	40	844	3	ced_arn
cedary	12	41	960	3	ced_ary
ceders	9	38	1767	3	ced_ers
cedulas	10	5	850	3	cedula_s
ceilers	9	39	1253	3	ceilers
cellar	8	45	1498	3	cellar_
cheddars	15	23	438	3	cheddars
collars	9	38	1657	3	collars
dealers	8	41	1861	3	dealers
dears	6	57	3688	3	__dears
debars	9	42	1804	3	de_bars
declare	10	4	1122	3	declare
declares	11	6	1131	3	declares
declass	10	3	873	3	declass
declaws	13	3	625	3	declaws
dedans	8	59	1507	3	ded_ans
delays	10	40	1405	3	de_lays
denars	7	46	2143	3	de_nars
deodars	9	3	762	3	deodars
dewars	10	51	1707	3	de_wars
dewlaps	13	3	466	3	dewlaps
dollars	8	33	1102	3	dollars
ears	4	63	5659	3	_e__ars
eclairs	9	3	596	3	_eclairs
eclats	8	3	1303	3	_eclats
edgers	8	44	1392	3	_edgers
eggars	8	39	897	3	_eggars
elans	5	55	2775	3	_e_lans
elders	7	48	1730	3	_elders
embars	10	38	1288	3	_embars
endears	8	37	1005	3	endears
escars	8	39	1313	3	_escars
eskars	10	35	759	3	_eskars
fears	8	48	2939	3	fe__ars
fedoras	11	3	792	3	fedoras
feelers	10	38	1474	3	feelers
fellahs	13	42	839	3	fellahs
fellas	9	51	1696	3	fella_s
fellers	10	41	1754	3	fellers
feuars	9	3	865	3	fe_uars
gears	6	46	2869	3	ge__ars
gelders	9	38	1257	3	gelders
healers	10	43	1946	3	healers
hears	8	67	3737	3	he__ars
heders	10	41	1976	3	hed_ers
hedgers	12	43	1026	3	hedgers
heelers	10	38	1562	3	heelers
hellers	10	36	1983	3	hellers
idlers	7	40	1281	3	_idlers
jetlags	15	3	386	3	jetlags
kebars	12	41	1249	3	ke_bars
keblahs	16	3	456	3	keblahs
keddahs	16	4	292	3	keddahs
keglers	12	27	777	3	keglers
ladlers	8	46	1357	3	ladlers
lars	4	69	5657	3	___lars
lears	5	59	3873	3	le__ars
ledgers	9	49	1218	3	ledgers
lekvars	14	3	269	3	lekvars
lidars	7	3	1078	3	lid_ars
maars	7	46	2163	3	m__aars
madams	11	3	1094	3	mad_ams
madcaps	14	3	524	3	madcaps
madders	11	35	1321	3	madders
madras	9	43	1643	3	madra_s
mailers	9	44	2033	3	mailers
makars	12	46	1263	3	m_akars
malar	7	64	2444	3	m_alar_
mallard	10	3	1027	3	mallard
mallards	11	3	832	3	mallards
mars	6	62	6187	3	m___ars
maulers	9	42	1330	3	maulers
meads	8	54	2532	3	me__ads
mealies	9	28	2193	3	mealies
meals	7	59	3337	3	me__als
meaners	9	44	1524	3	meaners
means	7	58	3123	3	me__ans
meats	7	50	3405	3	me__ats
meccas	12	3	949	3	mecca_s
medaka	13	3	634	3	med_aka
medakas	14	3	576	3	medakas
medal	8	62	2133	3	med_a_l
medaled	11	34	1161	3	medaled
medalist	11	4	1421	3	medalist
meddler	11	31	995	3	meddler_
meddles	11	32	1325	3	meddles
medevacs	16	4	337	3	medevacs
medflies	14	3	555	3	medflies
media	8	47	2171	3	media__
mediacy	15	3	614	3	mediacy
mediad	10	43	1371	3	media_d
mediae	9	42	1741	3	media_e
medial	9	38	1986	3	media_l
median	9	41	1754	3	media_n
mediant	10	35	1670	3	mediant
mediants	11	29	949	3	mediants
mediate	10	34	1521	3	mediate
mediates	11	28	1406	3	mediates
mediators	12	4	892	3	mediators
medicals	13	4	936	3	medicals
medicare	13	4	748	3	medicare
medicares	14	4	687	3	medicares
medicks	16	36	841	3	medicks
medicos	12	33	983	3	medicos
medics	11	41	1535	3	med_ics
medigaps	14	6	388	3	medigaps
medinas	10	34	1146	3	medinas
mediums	12	30	872	3	mediums
medius	9	36	1328	3	med_ius
medivacs	16	4	400	3	medivacs
medley	12	9	834	3	medl_ey
meds	7	57	3536	3	med___s
medullar	11	4	346	3	medullar_
medullary	15	4	224	3	medullary
medullas	11	4	451	3	medullas
medusans	11	4	414	3	medusans
medusas	10	3	621	3	medusas
meeters	9	47	1454	3	meeters
megabars	13	4	440	3	megabars
megara	9	3	1009	3	me_gara
megass	9	21	944	3	me_gass
melder	9	39	1581	3	melder_
melds	8	48	2238	3	me_l_ds
melees	8	36	1808	3	me_lees
mellows	12	38	1223	3	mellows
mells	7	50	3133	3	me_l_ls
melons	8	41	1771	3	me_lons
mels	6	59	4153	3	me_l__s
melters	9	39	1831	3	melters
melts	7	49	3010	3	me_l_ts
members	13	25	860	3	members
memoirs	11	3	680	3	memoirs
menads	9	55	1438	3	me_nads
menders	10	38	1880	3	menders
menhirs	12	3	591	3	menhirs
menials	9	40	1568	3	menials
mensas	8	51	1585	3	mensa_s
mentors	9	3	1499	3	mentors
mercers	11	44	1277	3	mercers
mergers	10	38	1342	3	mergers
merles	8	53	2276	3	merl_es
merlins	9	30	1581	3	merlins
merlons	9	33	1127	3	merlons
merlots	9	27	1012	3	merlots
merls	7	74	2390	3	merl__s
mesas	7	68	2320	3	me_sa_s
mescals	11	29	1155	3	mescals
messans	9	27	1046	3	messans
metals	8	45	2088	3	me_tals
meteors	9	46	1001	3	meteors
meters	8	56	2583	3	me_ters
metiers	9	33	1284	3	metiers
mewler	11	35	1023	3	mewler_
mewls	10	58	1323	3	mewl__s
mezcals	20	24	653	3	mezcals
midairs	10	3	720	3	midairs
middays	14	33	566	3	middays
middlers	12	34	1019	3	middlers
midland	11	3	661	3	midland
midlands	12	4	554	3	midlands
midlegs	11	5	632	3	midlegs
midways	16	38	618	3	midways
midyears	14	4	340	3	midyears
milers	8	46	2516	3	m_ilers
millers	9	36	2134	3	millers
mimbars	13	9	738	3	mimbars
mislays	12	34	924	3	mislays
modals	9	39	1445	3	mod_als
modelers	11	3	846	3	modelers
modular	10	8	736	3	modular_
moilers	9	36	1520	3	moilers
molar	7	52	2309	3	m_olar_
molas	7	51	3209	3	m_ola_s
molders	10	33	1555	3	molders
mollahs	12	32	828	3	mollahs
moolahs	12	34	738	3	moolahs
moolas	8	36	1559	3	moola_s
mortars	9	34	1152	3	mortars
mudcaps	14	4	410	3	mudcaps
mudcats	12	3	622	3	mudcats
mudders	11	32	1111	3	mudders
muddlers	12	42	881	3	muddlers
mudflaps	16	4	180	3	mudflaps
mudflats	14	4	298	3	mudflats
mudras	9	42	1226	3	mudra_s
muggars	11	31	664	3	muggars
mullahs	12	38	873	3	mullahs
mullas	8	42	1593	3	mulla_s
mullers	9	32	1730	3	mullers
mylar	10	53	1153	3	m_ylar_
nears	5	55	2942	3	ne__ars
nectars	9	3	846	3	nectars
needlers	9	28	742	3	needlers
oculars	9	4	836	3	oculars
pears	7	51	3861	3	pe__ars
pedalers	11	23	939	3	pedalers
pedalos	10	32	970	3	pedalos
pedals	9	43	1603	3	ped_als
peddlers	12	29	853	3	peddlers
pedlaries	12	10	878	3	pedlaries
pedler	9	36	1462	3	pedler_
pedlery	13	29	708	3	pedlery
peelers	9	36	1559	3	peelers
pillars	9	3	1349	3	pillars
polars	8	44	1935	3	_polars
poplars	11	39	1033	3	poplars
radars	7	13	1467	3	rad_ars
realgars	9	3	453	3	realgars
rears	5	47	3965	3	re__ars
rebars	8	40	1983	3	re_bars
reclads	10	4	999	3	reclads
redans	7	54	2102	3	red_ans
redbays	13	3	601	3	redbays
redcaps	12	4	707	3	redcaps
redders	9	36	1534	3	redders
redear	7	35	1517	3	redear_
redials	8	44	1688	3	redials
redias	7	45	2360	3	redia_s
redlegs	9	3	682	3	redlegs
redraws	11	21	847	3	redraws
redware	11	3	936	3	redware
redwares	12	3	905	3	redwares
reelers	7	35	2027	3	reelers
reflags	11	5	695	3	reflags
regears	8	30	1246	3	regears
regulars	9	3	625	3	regulars
rehears	10	33	1277	3	rehears
relays	9	43	1675	3	re_lays
replans	9	28	1494	3	replans
replays	12	39	976	3	replays
retears	7	28	1492	3	retears
rewears	10	29	1104	3	rewears
scalars	9	37	1190	3	scalars
sealers	7	43	2355	3	sealers
sears	5	47	4491	3	se__ars
secpars	11	3	841	3	secpars
seculars	10	21	939	3	seculars
sedans	7	48	1609	3	sed_ans
seders	7	44	2028	3	sed_ers
seggars	9	37	778	3	seggars
selahs	9	3	1321	3	se_lahs
sellers	7	37	2131	3	sellers
sewars	9	40	1863	3	se_wars
sidlers	8	34	1423	3	sidlers
smears	8	47	1443	3	sme__ars
smellers	10	32	976	3	smellers
talars	6	60	2168	3	_talars
tears	5	54	3646	3	te__ars
tedders	9	40	1023	3	tedders
tellers	7	37	1759	3	tellers
templars	12	5	526	3	templars
teslas	6	42	1217	3	tesla_s
tolars	6	48	1794	3	_tolars
uvulars	10	4	441	3	uvulars
vealers	10	32	1429	3	vealers
veilers	10	39	1182	3	veilers
velar	8	58	1763	3	ve_lar_
wears	8	60	3030	3	we__ars
wedders	12	36	1072	3	wedders
welders	11	33	1341	3	welders
weldors	11	23	800	3	weldors
years	8	45	2767	3	ye__ars
yellers	10	39	1295	3	yellers
yodlers	11	29	892	3	yodlers
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	134027	0.390	458182.1
2	DLD Change Limit	134027	309	5.813	23056.4
3	Display Results	309	309	0.110	2809.1
	(SQL Overall)	178691	309	6.313	28305.2