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

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

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

298 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
melt	6	57	5289	(None)
belt	6	57	5403	1	belt
celt	6	56	4671	1	celt
delt	5	78	5527	1	delt
felt	7	51	4693	1	felt
gelt	5	64	4801	1	gelt
kelt	8	53	4319	1	kelt
malt	6	62	5481	1	malt
meat	6	63	5960	1	meat
meet	6	53	5055	1	meet
mel	5	60	4748	1	mel_
meld	7	58	3047	1	meld
mell	6	49	3561	1	mell
mels	6	59	4153	1	mels
melts	7	49	3010	1	melts
melty	10	49	1836	1	melty
met	5	60	7243	1	me_t
milt	6	54	5581	1	milt
molt	6	63	5616	1	molt
pelt	6	76	5108	1	pelt
smelt	7	47	2678	1	smelt
welt	7	55	4786	1	welt
alt	3	64	6796	2	_alt
ament	7	60	3654	2	ament
beat	6	61	6830	2	beat
beet	6	64	5754	2	beet
bel	5	71	4846	2	bel_
bell	6	62	3718	2	bell
bels	6	61	4249	2	bels
belts	7	59	3116	2	belts
bent	6	77	5991	2	bent
best	6	63	5532	2	best
bet	5	83	7667	2	be_t
blet	6	62	4767	2	blet
bolt	6	62	5417	2	bolt
cel	5	60	4055	2	cel_
cell	6	50	3172	2	cell
cels	6	55	3497	2	cels
celts	7	53	2578	2	celts
cent	6	74	5101	2	cent
colt	6	71	5824	2	colt
cult	6	65	4115	2	cult
dealt	6	52	3428	2	dealt
debt	7	71	3902	2	debt
deet	5	73	5658	2	deet
deft	8	55	4022	2	deft
del	4	67	5275	2	del_
dele	5	68	4308	2	dele
delf	8	54	3657	2	delf
delft	9	56	2332	2	delft
deli	5	56	3129	2	deli
dell	5	69	3820	2	dell
dels	5	67	4547	2	dels
delta	6	61	1777	2	delta
delts	6	57	3179	2	delts
dent	5	71	5841	2	dent
dolt	5	66	4942	2	dolt
dwelt	9	43	1652	2	dwelt
eat	3	69	8905	2	_eat
eel	3	79	4684	2	eel_
eels	4	65	3674	2	eels
eely	7	77	2521	2	eely
eft	6	60	3882	2	_eft
el	2	67	4529	2	_el_
eld	4	67	3379	2	_eld
elf	6	61	3852	2	_elf
elk	7	67	2612	2	_elk
ell	3	67	3568	2	_ell
elm	5	75	3174	2	_elm
els	3	76	4572	2	_els
emit	6	54	3842	2	emit
et	2	69	6419	2	_e_t
feat	7	64	5822	2	feat
feet	7	53	5221	2	feet
fell	7	68	3307	2	fell
felts	8	53	2454	2	felts
fest	7	49	4944	2	fest
fet	6	64	7163	2	fe_t
gel	4	56	4243	2	gel_
geld	6	58	2843	2	geld
gels	5	68	3610	2	gels
gelts	6	59	2461	2	gelts
gent	5	69	5439	2	gent
gest	5	61	4913	2	gest
get	4	74	6746	2	ge_t
gilt	5	63	4854	2	gilt
halt	7	60	5630	2	halt
heat	7	70	6142	2	heat
heft	10	67	3629	2	heft
held	8	53	3040	2	held
hell	7	56	3789	2	hell
helm	9	55	3002	2	helm
helo	7	53	3285	2	helo
helot	8	53	3268	2	helot
help	9	53	2892	2	help
hent	7	66	5638	2	hent
hest	7	59	5077	2	hest
het	6	76	7431	2	he_t
hilt	7	58	5071	2	hilt
holt	7	78	5258	2	holt
jell	11	71	2587	2	jell
jest	11	67	3850	2	jest
jet	10	67	5482	2	je_t
jilt	11	58	3942	2	jilt
jolt	11	66	3912	2	jolt
keet	8	53	4734	2	keet
kelp	10	53	2280	2	kelp
kelts	9	52	2263	2	kelts
kent	8	68	4696	2	kent
kept	10	62	3294	2	kept
kilt	8	61	4442	2	kilt
knelt	9	46	1768	2	knelt
leet	4	59	5790	2	leet
left	7	63	4048	2	left
lent	4	63	6053	2	lent
lept	6	64	4088	2	lept
lest	4	69	5632	2	lest
let	3	64	8147	2	le_t
lilt	4	63	4994	2	lilt
male	6	60	5230	2	male
mall	6	46	3937	2	mall
malm	8	51	2998	2	malm
malts	7	63	3175	2	malts
malty	10	67	2170	2	malty
mart	6	68	6598	2	mart
mast	6	59	5996	2	mast
mat	5	80	8394	2	m_at
matt	6	57	5266	2	matt
maut	6	54	4845	2	maut
me	4	77	4833	2	me__
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
meals	7	59	3337	2	meals
mealy	10	44	2218	2	mealy
mean	6	55	3809	2	mean
meant	7	65	3721	2	meant
meats	7	50	3405	2	meats
meaty	10	70	2131	2	meaty
med	6	61	4674	2	me_d
meds	7	57	3536	2	meds
meed	7	49	3470	2	meed
meek	10	56	2483	2	meek
meets	7	42	2461	2	meets
meg	6	60	4095	2	me_g
mega	7	76	2087	2	mega
megs	7	55	3063	2	megs
melds	8	48	2238	2	melds
melee	7	37	2910	2	melee
melic	9	47	2233	2	melic
mells	7	50	3133	2	mells
melon	7	39	2208	2	melon
melted	9	42	1906	2	melted
melter	8	35	2011	2	melter
melton	8	3	1155	2	melton
mem	7	79	4347	2	me_m
meme	8	53	3055	2	meme
memo	8	59	2479	2	memo
mems	8	59	3150	2	mems
men	5	92	5285	2	me_n
mend	7	53	3403	2	mend
meno	6	60	3136	2	meno
menta	7	44	2442	2	menta
menu	6	51	3023	2	menu
meou	6	53	2586	2	meou
meow	9	51	1788	2	meow
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merit	7	3	3918	2	merit
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
merle	7	58	2437	2	merle
merlot	8	32	1760	2	merlot
merls	7	74	2390	2	merls
mesa	6	70	2548	2	mesa
mesh	9	68	2300	2	mesh
mess	6	59	3243	2	mess
meta	6	59	3241	2	meta
mete	6	44	3813	2	mete
meth	9	58	2784	2	meth
mew	8	61	3773	2	me_w
mewl	9	56	1832	2	mewl
mewls	10	58	1323	2	mewls
mews	9	66	2933	2	mews
meze	15	44	2090	2	meze
mil	5	57	5211	2	mil_
mild	7	53	3085	2	mild
mile	6	63	5257	2	mile
milk	10	50	2847	2	milk
mill	6	65	4148	2	mill
milo	6	55	3610	2	milo
mils	6	60	4533	2	mils
milts	7	54	3071	2	milts
milty	10	47	2007	2	milty
mint	6	67	5806	2	mint
mist	6	61	5453	2	mist
mitt	6	61	4549	2	mitt
mixt	13	68	3192	2	mixt
moat	6	63	5203	2	moat
mol	5	66	5459	2	mol_
mola	6	60	3563	2	mola
mold	7	60	3433	2	mold
mole	6	62	5183	2	mole
moll	6	67	3570	2	moll
mols	6	59	4857	2	mols
molto	7	56	1960	2	molto
molts	7	60	3209	2	molts
moly	9	60	3191	2	moly
moot	6	76	5362	2	moot
mort	6	67	5883	2	mort
most	6	65	5420	2	most
mot	5	72	7942	2	m_ot
mott	6	66	4844	2	mott
moult	7	47	2872	2	moult
mulct	9	38	2008	2	mulct
mule	6	52	3697	2	mule
mull	6	51	2880	2	mull
must	6	51	4544	2	must
mut	5	83	5718	2	m_ut
mutt	6	57	3940	2	mutt
neat	4	63	5678	2	neat
nest	4	55	4873	2	nest
net	3	66	7029	2	ne_t
nett	4	66	4323	2	nett
newt	7	69	3374	2	newt
next	11	66	3108	2	next
omelet	8	3	1707	2	omelet
peat	6	59	6793	2	peat
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelts	7	61	2881	2	pelts
pent	6	65	5907	2	pent
pert	6	67	5932	2	pert
pest	6	55	5529	2	pest
pet	5	64	7730	2	pe_t
reft	7	51	4127	2	reft
relet	5	47	4982	2	relet
relit	5	53	4068	2	relit
rely	7	54	2895	2	rely
remelt	8	51	2312	2	remelt
rent	4	66	6124	2	rent
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
salt	4	57	5852	2	salt
seat	4	75	7556	2	seat
sect	6	74	4362	2	sect
sel	3	82	5332	2	sel_
self	7	51	3829	2	self
sell	4	58	4061	2	sell
sels	4	63	4598	2	sels
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
set	3	66	8125	2	se_t
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
silt	4	65	5819	2	silt
smalt	7	47	2933	2	smalt
smell	7	49	1623	2	smell
smelts	8	54	1277	2	smelts
smolt	7	48	2416	2	smolt
spelt	7	54	3019	2	spelt
teat	4	59	6363	2	teat
tel	3	56	4790	2	tel_
tela	4	55	3297	2	tela
tele	4	50	4087	2	tele
tell	4	49	3470	2	tell
tels	4	68	4169	2	tels
tent	4	61	5986	2	tent
test	4	86	5162	2	test
tet	3	92	7499	2	te_t
text	11	60	3393	2	text
tilt	4	62	5242	2	tilt
vela	7	57	2554	2	vela
veld	8	53	2320	2	veld
veldt	9	48	1986	2	veldt
vent	7	60	4905	2	vent
vert	7	72	4937	2	vert
vest	7	57	4360	2	vest
vet	6	59	5852	2	ve_t
vext	14	69	2776	2	vext
volt	7	64	3953	2	volt
weet	7	52	5415	2	weet
weft	10	54	3501	2	weft
weld	8	47	2773	2	weld
well	7	58	3204	2	well
welts	8	52	2519	2	welts
went	7	60	5187	2	went
wept	9	56	3505	2	wept
wert	7	97	4982	2	wert
west	7	57	4808	2	west
wet	6	59	6662	2	we_t
wilt	7	62	4629	2	wilt
yeld	8	114	2387	2	yeld
yelk	11	53	2000	2	yelk
yell	7	60	2832	2	yell
yelp	9	56	2135	2	yelp
yet	6	69	6069	2	ye_t
yett	7	64	3449	2	yett
zest	13	60	3570	2	zest

Search took 2 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	29872	0.263	679433.5
2	DLD Change Limit	29872	298	0.800	37340.0
3	Display Results	298	298	0.060	4966.7
	(SQL Overall)	178691	298	1.123	159119.3