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

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

337 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
merlot	8	32	1761	(None)
merlon	8	30	1235	1	merlon
merlots	9	27	1012	1	merlots
ergot	6	54	2289	2	_ergot
harlot	9	44	2280	2	harlot
helot	8	53	3268	2	he_lot
heriot	9	4	2234	2	heriot
marmot	10	3	1874	2	marmot
marplot	11	4	967	2	marplot
melilot	9	3	1108	2	melilot
mellow	11	41	1222	2	mellow
melon	7	39	2208	2	me_lon
melt	6	57	5289	2	me_l_t
merest	8	47	2511	2	merest
merit	7	3	3918	2	mer_it
merl	6	58	3097	2	merl__
merle	7	58	2437	2	merl_e
merles	8	53	2276	2	merles
merlin	8	39	1668	2	merlin
merlons	9	33	1127	2	merlons
merls	7	74	2390	2	merl_s
replot	8	38	1859	2	replot
zealot	15	3	1347	2	zealot
aero	4	54	3534	3	aer_o_
allot	5	49	3387	3	_allot
argot	6	77	2865	3	_argot
ballot	8	46	2409	3	ballot
barlow	11	29	1142	3	barlow
beclog	11	3	686	3	beclog
begot	8	46	2595	3	be_got
beknot	12	3	976	3	beknot
bellow	11	42	1335	3	bellow
belon	7	39	2411	3	be_lon
below	10	46	1719	3	be_low
belt	6	57	5403	3	be_l_t
bereft	11	43	1730	3	bereft
beret	7	49	4636	3	ber_et
berlin	8	31	1637	3	berlin
besot	7	64	2971	3	be_sot
blot	6	58	4232	3	__blot
brulot	8	9	1221	3	brulot
burbot	10	8	1565	3	burbot
carrot	8	4	2312	3	carrot
cello	7	49	1958	3	cello_
cellos	8	45	1780	3	cellos
celom	9	5	1569	3	ce_lom
celt	6	56	4671	3	ce_l_t
cermet	10	3	2115	3	cermet
cero	6	63	2945	3	cer_o_
ceros	7	47	2607	3	cer_os
chalot	11	30	2013	3	chalot
cheroot	12	4	1369	3	cheroot
clot	6	65	4242	3	__clot
coplot	10	5	1827	3	coplot
dealt	6	52	3428	3	deal_t
delft	9	56	2332	3	de_lft
delt	5	78	5527	3	de_l_t
deploy	12	3	758	3	deploy
depot	8	57	2792	3	de_pot
derat	6	50	4408	3	der_at
despot	9	34	1329	3	despot
diglot	8	30	1433	3	diglot
drylot	10	3	740	3	drylot
eclat	7	5	2360	3	_eclat
emerod	9	13	921	3	emer_od
employ	13	4	649	3	employ
enroot	6	6	1599	3	enroot
erect	7	41	2933	3	_erect
ergo	5	64	2015	3	_ergo_
ergots	7	45	1237	3	_ergots
eros	4	52	3845	3	_er_os
error	5	37	1223	3	_error
erst	4	74	3643	3	_er_st
eruct	7	40	2235	3	_eruct
erupt	7	42	2006	3	_erupt
escot	7	53	2008	3	_escot
feedlot	11	13	593	3	feedlot
felloe	9	35	1392	3	felloe
fellow	12	37	1274	3	fellow
felon	8	46	1929	3	fe_lon
felt	7	51	4693	3	fe_l_t
ferlie	9	28	1405	3	ferlie
ferly	11	55	1735	3	ferl_y
ferret	9	30	2117	3	ferret
fervor	12	3	564	3	fervor
forgot	10	43	1813	3	forgot
gelt	5	64	4801	3	ge_l_t
gemot	8	40	2423	3	ge_mot
gerent	7	32	2310	3	gerent
giglot	8	40	1313	3	giglot
griot	6	53	2841	3	_griot
grot	5	59	4205	3	_gr_ot
hallot	9	54	2678	3	hallot
harlots	10	34	1329	3	harlots
hello	8	65	2298	3	hello_
hellos	9	53	2168	3	hellos
helo	7	53	3285	3	he_lo_
helos	8	49	2806	3	he_los
helots	9	52	1770	3	he_lots
hereat	9	35	2741	3	hereat
hereof	12	32	1237	3	hereof
hereon	9	39	1436	3	hereon
hereto	9	3	1369	3	hereto
heriots	10	3	1206	3	heriots
herl	7	58	3455	3	herl__
herls	8	52	2643	3	herl_s
hermit	11	5	1944	3	hermit
hero	7	46	3578	3	her_o_
heron	8	50	2550	3	her_on
heros	8	49	3086	3	her_os
jello	12	67	1627	3	jello_
jellos	13	47	1428	3	jellos
jerboa	15	3	563	3	jerboa
kelt	8	53	4319	3	ke_l_t
lirot	5	4	3003	3	lir_ot
lot	3	81	7926	3	___lot
maggot	10	3	1171	3	maggot
magot	8	3	2639	3	m_agot
maillot	9	3	1217	3	maillot
mallet	8	44	3305	3	mallet
mallow	11	40	1474	3	mallow
maloti	8	3	1321	3	m_aloti
malt	6	62	5481	3	m_al_t
market	12	32	2604	3	market
marl	6	63	4162	3	marl__
marled	9	55	2316	3	marled
marlin	8	42	2090	3	marlin
marlite	9	29	1707	3	marlite
marls	7	55	3516	3	marl_s
marly	10	69	2561	3	marl_y
marmots	11	3	1151	3	marmots
maroon	8	31	1820	3	maroon
marplots	12	4	563	3	marplots
marron	8	37	1754	3	marron
marrow	11	28	1260	3	marrow
mart	6	68	6598	3	mar__t
martlet	9	34	1915	3	martlet
mascot	10	40	1607	3	mascot
matelot	9	4	1157	3	matelot
matzot	17	7	1098	3	matzot
meadow	12	3	740	3	meadow
meal	6	56	4317	3	meal__
mealie	8	25	1981	3	mealie
meals	7	59	3338	3	meal_s
mealy	10	44	2218	3	meal_y
meant	7	65	3721	3	me_ant
meat	6	63	5960	3	me__at
medlar	9	30	1046	3	medlar
medley	12	9	834	3	medley
meerkat	13	4	694	3	meerkat
meet	6	53	5055	3	me__et
mel	5	60	4748	3	me_l__
meld	7	58	3047	3	me_l_d
melds	8	48	2238	3	me_lds
melee	7	37	2910	3	me_lee
melic	9	47	2233	3	me_lic
melilots	10	4	655	3	melilots
mell	6	49	3561	3	me_l_l
melled	9	50	2302	3	melled
mellows	12	38	1223	3	mellows
mells	7	50	3133	3	me_lls
melody	12	3	720	3	me_lody
meloid	9	6	1600	3	me_loid
melons	8	41	1771	3	me_lons
mels	6	59	4153	3	me_l_s
melton	8	3	1155	3	melton
melts	7	49	3010	3	me_lts
melty	10	49	1836	3	me_lty
memo	8	59	2479	3	me_mo_
memos	9	57	1911	3	me_mos
meno	6	60	3136	3	me_no_
mentor	8	4	1436	3	mentor
meou	6	53	2586	3	me__ou
meow	9	51	1788	3	me__ow
merc	8	72	2562	3	mer__c
mercer	10	52	1420	3	mercer
merces	10	57	2074	3	merces
merch	12	54	1796	3	mer_ch
mercs	9	60	2045	3	mer_cs
mercy	12	59	1618	3	mer_cy
merde	8	43	2012	3	mer_de
merdes	9	45	1860	3	merdes
mere	6	72	4444	3	mer__e
merely	11	13	1259	3	merely
merer	7	51	2623	3	mer_er
meres	7	51	4357	3	mer_es
merge	8	45	2369	3	mer_ge
merged	10	42	1495	3	merged
mergee	9	40	1814	3	mergee
merger	9	50	1648	3	merger
merges	9	41	2249	3	merges
merino	8	3	1509	3	merino
merinos	9	3	1198	3	merinos
merits	8	3	2087	3	merits
merk	10	60	2794	3	mer__k
merks	11	47	2240	3	mer_ks
merlins	9	30	1581	3	merlins
merman	10	5	1386	3	merman
mermen	10	8	1381	3	mermen
merry	10	47	2149	3	mer_ry
meson	7	41	1831	3	me_son
met	5	60	7243	3	me___t
meteor	8	49	1007	3	meteor
method	12	3	903	3	method
metol	7	59	1781	3	me_tol
metols	8	41	1577	3	metols
metrist	9	3	1706	3	metrist
metro	7	47	1880	3	metro_
metros	8	42	1780	3	metros
mewl	9	56	1832	3	mewl__
mewled	12	37	1005	3	mewled
mewler	11	35	1023	3	mewler
mewls	10	58	1323	3	mewl_s
mezuzot	17	7	283	3	mezuzot
mezzo	15	3	743	3	mezzo_
mezzos	16	3	505	3	mezzos
mikvot	15	5	676	3	mikvot
millet	8	40	3074	3	millet
milo	6	55	3610	3	m_ilo_
milos	7	54	2801	3	m_ilos
milt	6	54	5581	3	m_il_t
mirror	8	4	800	3	mirror
mislit	8	30	1969	3	mislit
molt	6	63	5616	3	m_ol_t
molto	7	56	1960	3	m_olto
moot	6	76	5362	3	m__oot
morion	8	62	1773	3	morion
moron	7	69	2542	3	mor_on
morro	7	32	1695	3	morro_
morros	8	37	1467	3	morros
morrow	11	35	1009	3	morrow
mort	6	67	5883	3	mor__t
mot	5	72	7942	3	m___ot
motmot	10	3	1107	3	motmot
moult	7	47	2872	3	moul_t
mulct	9	38	2008	3	m_ulct
mullet	8	41	2682	3	mullet
nerol	5	10	1781	3	ner_ol
neroli	6	11	1116	3	neroli
nerols	6	9	1489	3	nerols
ocelot	8	8	1338	3	ocelot
omelet	8	3	1707	3	ome_let
orlon	5	4	1500	3	_orlon
orlop	7	4	1090	3	_orlop
overhot	13	4	1122	3	overhot
overlet	10	26	1903	3	overlet
overlit	10	27	1474	3	overlit
overplot	13	3	854	3	overplot
parlor	8	3	1267	3	parlor
parrot	8	3	2066	3	parrot
pellet	8	33	2655	3	pellet
pelon	7	44	2321	3	pe_lon
pelota	8	6	1283	3	pe_lota
pelt	6	76	5108	3	pe_l_t
peplos	10	12	1154	3	peplos
pereon	8	35	1745	3	pereon
peridot	10	5	1424	3	peridot
period	9	3	1498	3	period
perlite	9	3	1732	3	perlite
permit	10	3	2168	3	permit
pernod	9	3	1045	3	pernod
perron	8	32	1662	3	perron
person	8	35	1787	3	person
pert	6	67	5932	3	per__t
pierrot	9	4	883	3	pierrot
pilot	7	74	3506	3	_pilot
plot	6	61	4123	3	__plot
preriot	9	3	1641	3	preriot
reallot	7	3	1213	3	reallot
reboot	8	41	1933	3	reboot
redroot	8	3	1290	3	redroot
reflet	9	40	2423	3	reflet
refloat	10	3	1083	3	refloat
reflow	12	37	965	3	reflow
reglet	7	37	2423	3	reglet
reglow	10	33	940	3	reglow
reknot	10	3	1173	3	reknot
relet	5	47	4982	3	re_let
relit	5	53	4068	3	re_lit
replots	9	34	1263	3	replots
replow	11	42	1034	3	replow
repot	7	51	3262	3	re_pot
rerent	6	38	3245	3	rerent
reroll	6	4	1268	3	reroll
reroof	9	3	1500	3	reroof
reshot	9	35	1963	3	reshot
respot	8	31	1763	3	respot
revolt	9	3	1622	3	revolt
riot	4	59	4721	3	__riot
root	4	56	5592	3	__root
rot	3	72	8295	3	__r_ot
ryot	7	55	2856	3	__ryot
sellout	7	3	1358	3	sellout
serest	6	48	3161	3	serest
sermon	8	4	1355	3	sermon
serow	8	67	2044	3	ser_ow
servo	8	45	1668	3	servo_
servos	9	38	1272	3	servos
sexpot	15	3	954	3	sexpot
sheroot	10	4	1437	3	sheroot
slot	4	60	4983	3	__slot
smelt	7	47	2678	3	sme_l_t
sterlet	7	13	1847	3	sterlet
sublot	8	23	1552	3	sublot
tarot	5	59	4393	3	tar_ot
teapot	8	4	1676	3	teapot
teflon	9	3	745	3	teflon
teloi	5	42	1738	3	te_loi
telos	5	54	2452	3	te_los
tercet	8	36	2491	3	tercet
termor	8	44	1251	3	termor
terret	6	34	2562	3	terret
territ	6	34	2137	3	territ
terror	6	38	1173	3	terror
torot	5	61	3994	3	tor_ot
trot	4	63	5131	3	_tr_ot
turbot	8	9	1426	3	turbot
unroot	6	3	1555	3	unroot
uproot	8	3	1412	3	uproot
varlet	9	4	2350	3	varlet
veldt	9	48	1986	3	ve_ldt
verist	9	38	2389	3	verist
verset	9	43	2732	3	verset
verso	8	53	1463	3	verso_
versos	9	38	1280	3	versos
verst	8	44	2937	3	ver_st
vert	7	72	4937	3	ver__t
vervet	12	46	1906	3	vervet
weblog	12	3	422	3	weblog
welt	7	55	4786	3	we_l_t
wert	7	97	4982	3	wer__t
xerox	11	3	862	3	xer_ox
yellow	12	42	988	3	yellow
zealots	16	3	676	3	zealots
zero	13	48	2247	3	zer_o_
zeros	14	49	1811	3	zer_os
zeroth	18	3	796	3	zer_oth

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.390	458182.1
2	DLD Change Limit	112716	337	5.923	19030.2
3	Display Results	337	337	0.110	3063.6
	(SQL Overall)	178691	337	6.423	27820.5