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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

98 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
mucluc	12	4	505	(None)
muclucs	13	4	368	1	muclucs
muckluck	17	12	192	2	muckluck
mucous	10	44	1165	2	mucous
mucus	9	40	1574	2	muc_us
mukluk	11	4	350	2	mukluk
aulic	7	44	2024	3	au_lic
bucolic	13	4	559	3	bucolic
club	8	58	1947	3	__club
cluck	13	49	1489	3	__cluck
clue	6	53	2453	3	__clue
cyclic	12	3	803	3	cyclic
fuckup	17	3	396	3	fuckup
fucous	11	39	986	3	fucous
fucus	10	55	1589	3	fuc_us
lulu	4	41	2288	3	lu_lu_
lulus	5	43	1516	3	lu_lus
macle	9	61	2700	3	macl_e
macled	11	67	1811	3	macled
macles	10	70	2322	3	macles
macula	10	30	1367	3	macula
macule	10	41	1527	3	macule
malic	9	45	2566	3	m_alic
mamluk	14	3	474	3	mamluk
melic	9	47	2233	3	m_elic
mesclun	11	4	401	3	mesclun
mockup	16	3	407	3	mockup
mollusc	11	10	309	3	mollusc
much	11	52	2403	3	muc__h
muches	13	47	1899	3	muches
muchly	16	8	620	3	muchly
mucho	12	50	1344	3	muc_ho
mucid	10	41	1525	3	muc_id
mucin	9	31	1682	3	muc_in
mucins	10	27	1251	3	mucins
muck	12	57	2785	3	muc__k
mucked	15	38	1609	3	mucked
mucker	14	38	1639	3	mucker
muckle	14	34	1358	3	muckle
muckles	15	34	1325	3	muckles
mucklucks	18	15	188	3	mucklucks
mucks	13	46	2264	3	muc_ks
mucky	16	50	1525	3	muc_ky
mucoid	11	3	978	3	mucoid
mucor	9	40	1194	3	muc_or
mucors	10	44	1085	3	mucors
mucosa	10	16	627	3	mucosa
mucose	10	14	931	3	mucose
mucro	9	45	1372	3	muc_ro
mudbug	12	4	325	3	mudbug
mugful	12	3	540	3	mugful
muggur	10	32	559	3	muggur
muhly	13	5	852	3	muhl_y
mukluks	12	4	241	3	mukluks
muktuk	11	4	288	3	muktuk
mulch	12	40	1297	3	mu_lch
mulct	9	38	2008	3	mu_lct
mulcts	10	29	871	3	mulcts
mule	6	52	3697	3	mu_l_e
muled	8	58	2443	3	mu_led
mules	7	50	3429	3	mu_les
muley	10	48	1928	3	mu_ley
mull	6	51	2880	3	mu_l_l
mulla	7	43	1711	3	mu_lla
mullah	11	37	1073	3	mullah
mullas	8	42	1593	3	mullas
mulled	9	47	2155	3	mulled
mullen	8	37	1476	3	mullen
muller	8	38	2035	3	muller
mullet	8	41	2682	3	mullet
mulley	11	40	1345	3	mulley
mullock	15	3	571	3	mullock
mulls	7	51	2415	3	mu_lls
mumu	8	60	2206	3	mu_mu_
mumus	9	55	1728	3	mu_mus
muonic	10	4	1018	3	muonic
murmur	10	3	485	3	murmur
muscle	10	3	1097	3	muscl_e
muscled	12	3	778	3	muscled
muscles	11	3	1056	3	muscles
muscly	13	3	745	3	muscl_y
museum	10	3	770	3	museum
music	9	43	1640	3	mu_sic
muslin	8	3	1221	3	muslin
mutule	8	3	1142	3	mutule
muumuu	10	4	237	3	muumuu
nuclei	8	5	772	3	nuclei
nucleus	9	5	657	3	nucleus
oculus	8	17	839	3	oculus
public	12	23	814	3	public
pullup	10	4	589	3	pullup
ruckus	12	40	779	3	ruckus
sulcus	8	4	1049	3	sulcus
sulu	4	51	2842	3	su_lu_
sulus	5	48	2188	3	su_lus
tuchun	11	4	544	3	tuchun
ulu	3	60	2870	3	_u_lu_
ulus	4	56	2256	3	_u_lus

Search took 6 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.373	479064.3
2	DLD Change Limit	112716	98	5.266	21404.5
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	5.669	31520.7