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

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

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.

82 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
candled	11	38	1574	(None)
canaled	10	36	1556	1	canaled
candied	11	38	1602	1	candied
candle	9	43	2148	1	candle_
candler	10	35	1659	1	candler
candles	10	44	2234	1	candles
dandled	10	33	1354	1	dandled
handled	12	41	1453	1	handled
addled	9	41	1252	2	_addled
aneled	7	47	1928	2	_aneled
angled	8	42	1909	2	_angled
ankled	11	43	1348	2	_ankled
banded	10	52	2317	2	band_ed
bandied	11	44	1430	2	bandied
bundled	11	40	1130	2	bundled
cabled	11	48	1987	2	ca_bled
cackled	16	46	1330	2	cackled
caddied	12	37	1056	2	caddied
cadged	11	48	1234	2	ca_dged
cajoled	17	42	828	2	cajoled
called	9	41	2673	2	ca_lled
canalled	11	3	958	2	canalled
canceled	13	27	940	2	canceled
candela	10	8	974	2	candela
candid	10	45	1785	2	cand_id
candies	10	41	2561	2	candies
candlers	11	42	1410	2	candlers
caned	8	58	3809	2	can__ed
canned	9	50	2206	2	can_ned
canoed	9	46	1896	2	can_oed
canoodled	13	4	280	2	canoodled
canted	9	48	2578	2	can_ted
cantle	8	45	2215	2	cantle_
cantles	9	47	2141	2	cantles
carded	10	54	2490	2	card_ed
caroled	10	37	1769	2	caroled
castled	10	43	1151	2	castled
caudle	9	39	1291	2	caudle_
caudles	10	39	1281	2	caudles
caviled	13	4	872	2	caviled
chandler	14	35	837	2	chandler
coddled	12	34	1057	2	coddled
condoled	12	31	1072	2	condoled
cradled	11	34	1081	2	cradled
crankled	15	40	815	2	crankled
cuddled	12	41	1076	2	cuddled
curdled	11	39	1066	2	curdled
daddled	11	38	1074	2	daddled
dandle	8	42	1809	2	dandle_
dandler	9	44	1427	2	dandler
dandles	9	42	1853	2	dandles
dangled	10	40	1315	2	dangled
dawdled	13	37	672	2	dawdled
dindled	10	44	1272	2	dindled
fondled	12	39	942	2	fondled
handed	11	49	1998	2	hand_ed
handle	10	42	1929	2	handle_
handler	11	35	1616	2	handler
handles	11	40	2065	2	handles
hondled	12	35	1065	2	hondled
jangled	16	41	1156	2	jangled
kindled	13	34	1054	2	kindled
ladled	8	50	1348	2	la_dled
landed	8	46	1924	2	land_ed
landler	8	41	1320	2	landler
mangled	11	36	1526	2	mangled
mantled	10	41	1339	2	mantled
paddled	12	36	1202	2	paddled
pandied	11	39	1344	2	pandied
paneled	10	6	1257	2	paneled
raddled	10	38	1222	2	raddled
rankled	12	39	1065	2	rankled
saddled	10	31	1203	2	saddled
sandaled	10	3	924	2	sandaled
sanded	8	49	2061	2	sand_ed
scandaled	13	4	466	2	scandaled
tangled	9	42	1464	2	tangled
uncandled	13	4	599	2	uncandled
waddled	13	36	1164	2	waddled
wandle	10	53	1666	2	wandle_
wangled	12	33	1241	2	wangled
windled	12	37	1348	2	windled

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	82	3.513	30649.3
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	3.922	45561.2