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

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

104 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
murder	9	36	1378	(None)
mudder	10	44	1349	1	mudder
murders	10	33	1136	1	murders
murker	12	37	1524	1	murker
aulder	7	5	1145	2	aulder
birder	9	49	1549	2	birder
border	9	44	1997	2	border
budder	10	43	1481	2	budder
burden	9	4	1247	2	burden
burger	9	40	2079	2	burger
burier	8	43	2465	2	burier
burker	12	52	2117	2	burker
burler	8	47	2383	2	burler
burner	8	38	1920	2	burner
burrer	8	37	1847	2	burrer
carder	9	45	2418	2	carder
corder	9	43	2288	2	corder
cruder	9	56	1238	2	cruder
curber	10	45	1705	2	curber
curded	10	42	1716	2	curded
curdier	10	33	1262	2	curdier
curdler	10	35	1156	2	curdler
curer	7	50	3075	2	cur_er
curler	8	52	2132	2	curler
curser	8	47	2147	2	curser
curter	8	53	2008	2	curter
funder	10	40	1608	2	funder
furler	9	36	1640	2	furler
girder	8	43	1206	2	girder
guarder	9	3	646	2	guarder
guider	8	43	1352	2	guider
harder	10	50	2240	2	harder
herder	10	45	1646	2	herder
hurdler	11	36	1000	2	hurdler
hurler	9	47	1722	2	hurler
hurter	9	39	1585	2	hurter
judder	15	43	942	2	judder
larder	7	37	2097	2	larder
lurer	5	46	2531	2	lur_er
lurker	10	36	1329	2	lurker
madder	10	35	1559	2	madder
marker	12	44	2039	2	marker
marrer	8	37	1667	2	marrer
maunder	10	32	868	2	maunder
melder	9	39	1581	2	melder
mender	9	35	2079	2	mender
mercer	10	52	1420	2	mercer
merde	8	43	2012	2	merde_
merdes	9	45	1860	2	merdes
merer	7	51	2623	2	mer_er
merger	9	50	1648	2	merger
milder	9	38	1845	2	milder
minder	9	48	2250	2	minder
mirier	8	39	1836	2	mirier
mirker	12	37	1269	2	mirker
molder	9	38	1927	2	molder
moulder	10	38	980	2	moulder
mourner	9	3	809	2	mourner
mucker	14	38	1639	2	mucker
mudded	11	45	1138	2	mudded
mudders	11	32	1111	2	mudders
muddier	11	41	1002	2	muddier
muddler	11	34	1162	2	muddler
mugger	10	39	1470	2	mugger
muller	8	38	2035	2	muller
mummer	9	36	1454	2	mummer
mumper	12	35	1352	2	mumper
murdered	12	3	602	2	murdered
murderee	11	4	684	2	murderee
murderer	11	4	526	2	murderer
mure	6	59	4133	2	mur_e_
mured	8	57	2670	2	mur_ed
mures	7	59	3722	2	mur_es
murex	14	55	1717	2	mur_ex
murkier	13	31	1027	2	murkier
murmur	10	3	485	2	murmur
murr	6	52	2513	2	mur__r
murre	7	48	2107	2	murre_
murres	8	50	1904	2	murres
murrey	11	43	1226	2	murrey
murther	12	3	795	2	murther
muser	7	60	2412	2	mu_ser
musher	11	38	2057	2	musher
muster	8	47	2452	2	muster
muter	7	45	2554	2	mu_ter
mutter	8	44	1888	2	mutter
nuder	6	64	1683	2	nu_der
nurser	6	43	1450	2	nurser
order	6	50	1936	2	_order
purer	7	51	2790	2	pur_er
purger	9	47	1723	2	purger
purser	8	50	2047	2	purser
rudder	8	38	1280	2	rudder
ruder	6	53	2054	2	ru_der
sunder	7	40	1982	2	sunder
surer	5	48	3310	2	sur_er
surfer	9	35	1588	2	surfer
surger	7	43	2009	2	surger
turner	6	39	1461	2	turner
udder	7	63	1428	2	_udder
under	6	46	2421	2	_under
urger	6	41	1647	2	_urger
warder	10	40	2027	2	warder
yarder	10	38	1397	2	yarder

Search took 3 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	82551	0.346	516448.0
2	DLD Change Limit	82551	104	2.356	35038.6
3	Display Results	104	104	0.033	3151.5
	(SQL Overall)	178691	104	2.735	65334.9