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

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

110 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
murky	14	52	1668	(None)
mirky	14	63	1552	1	mirky
mucky	16	50	1525	1	mucky
murk	10	55	2725	1	murk_
murkly	15	36	830	1	murkly
murks	11	48	2173	1	murks
murry	10	51	2023	1	murry
musky	14	47	1529	1	musky
barky	14	57	2161	2	barky
bulky	14	62	1557	2	bulky
burka	11	46	1769	2	burka
burke	11	51	2276	2	burke
burly	10	49	2283	2	burly
burry	10	52	2156	2	burry
bury	9	56	3359	2	bur_y
corky	14	52	2115	2	corky
curdy	11	59	1652	2	curdy
curly	10	53	2123	2	curly
curry	10	59	2034	2	curry
curvy	13	60	1337	2	curvy
darky	13	60	1883	2	darky
dorky	13	55	1874	2	dorky
ducky	15	42	1611	2	ducky
dumky	15	45	1134	2	dumky
dusky	13	52	1304	2	dusky
euroky	13	3	482	2	euroky
forky	15	61	1964	2	forky
funky	15	43	1513	2	funky
furry	11	67	1928	2	furry
fury	10	77	2797	2	fur_y
furzy	20	101	1606	2	furzy
gunky	13	55	1411	2	gunky
gurry	9	45	1541	2	gurry
hulky	15	53	1247	2	hulky
hunky	15	54	1773	2	hunky
hurly	11	58	1929	2	hurly
hurry	11	49	1718	2	hurry
husky	15	61	1256	2	husky
jerky	19	67	1242	2	jerky
junky	19	45	1323	2	junky
jury	14	67	1959	2	jur_y
larky	12	52	1887	2	larky
lucky	14	55	1501	2	lucky
lurk	8	66	2416	2	lurk_
lurks	9	52	1874	2	lurks
mark	10	51	3806	2	mark_
marka	11	46	2080	2	marka
marks	11	59	3348	2	marks
marly	10	69	2561	2	marly
marry	10	48	2169	2	marry
marvy	13	50	1403	2	marvy
mercy	12	59	1618	2	mercy
merk	10	60	2794	2	merk_
merks	11	47	2240	2	merks
merry	10	47	2149	2	merry
milky	14	40	1444	2	milky
mirk	10	67	2951	2	mirk_
mirks	11	51	2214	2	mirks
miry	9	63	2676	2	mir_y
moray	10	54	2379	2	moray
muck	12	57	2785	2	muck_
mucks	13	46	2264	2	mucks
muddy	12	38	1223	2	muddy
muggy	12	56	1237	2	muggy
muhly	13	5	852	2	muhly
muley	10	48	1928	2	muley
mummy	11	49	1362	2	mummy
mura	6	56	3330	2	mur_a
mural	7	52	2511	2	mural
muras	7	53	2958	2	muras
mure	6	59	4133	2	mur_e
mured	8	57	2670	2	mured
mures	7	59	3722	2	mures
murex	14	55	1717	2	murex
murid	8	45	2058	2	murid
murker	12	37	1524	2	murker
murkily	16	28	711	2	murkily
murphy	16	5	434	2	murphy
murr	6	52	2513	2	mur_r
murra	7	45	1908	2	murra
murre	7	48	2107	2	murre
murrey	11	43	1226	2	murrey
murrs	7	55	2130	2	murrs
mushy	13	53	1663	2	mushy
musk	10	45	2619	2	musk_
musks	11	61	1964	2	musks
mussy	10	41	1764	2	mussy
musty	10	56	2095	2	musty
muzzy	18	84	1060	2	muzzy
narky	12	60	1780	2	narky
perky	14	53	1948	2	perky
porky	14	50	1933	2	porky
punky	14	44	1939	2	punky
pursy	10	50	1641	2	pursy
purty	10	50	1940	2	purty
quaky	21	43	1074	2	quaky
quirky	22	43	553	2	quirky
sarky	12	55	2178	2	sarky
smirky	15	40	694	2	smirky
sucky	14	44	1550	2	sucky
sulky	12	47	1536	2	sulky
surfy	11	53	1947	2	surfy
surgy	9	51	1852	2	surgy
surly	8	51	2443	2	surly
turfy	11	43	1540	2	turfy
turk	8	61	2586	2	turk_
turkey	13	3	776	2	turkey
turks	9	53	2082	2	turks
yucky	17	54	1169	2	yucky
yukky	14	42	521	2	yukky

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	53800	0.313	570897.8
2	DLD Change Limit	53800	110	1.406	38264.6
3	Display Results	110	110	0.016	6875.0
	(SQL Overall)	178691	110	1.735	102991.9