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

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

77 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
handled	12	41	1453	(None)
candled	11	38	1573	1	candled
dandled	10	33	1354	1	dandled
handed	11	49	1998	1	hand_ed
handle	10	42	1929	1	handle_
handler	11	35	1616	1	handler
handles	11	40	2065	1	handles
hondled	12	35	1065	1	hondled
addled	9	41	1251	2	_addled
aneled	7	47	1927	2	_aneled
angled	8	42	1907	2	_angled
ankled	11	43	1347	2	_ankled
banded	10	52	2317	2	band_ed
bandied	11	44	1430	2	bandied
bundled	11	40	1130	2	bundled
canaled	10	36	1555	2	canaled
candied	11	38	1602	2	candied
candle	9	43	2148	2	candle_
candler	10	35	1659	2	candler
candles	10	44	2234	2	candles
chandler	14	35	837	2	chandler
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
hackled	17	33	1248	2	hackled
haded	10	52	2762	2	ha_d_ed
haggled	13	35	928	2	haggled
hailed	10	41	2274	2	ha_iled
haled	9	53	3582	2	ha__led
hander	10	45	2643	2	hand_er
handheld	16	4	446	2	handheld
handier	11	38	1744	2	handier
handlers	12	40	1414	2	handlers
handless	12	35	1206	2	handless
handsel	11	30	872	2	handsel
handseled	14	4	440	2	handseled
handset	11	30	1682	2	handset
hanged	11	42	2239	2	han_ged
hanked	14	42	2060	2	han_ked
hanseled	12	3	771	2	hanseled
hanted	10	41	2431	2	han_ted
hantle	9	43	1820	2	hantle_
hantles	10	41	1751	2	hantles
hassled	11	35	830	2	hassled
hauled	10	44	1521	2	ha_uled
hondle	10	39	1452	2	hondle_
hondles	11	36	1452	2	hondles
huddled	13	34	978	2	huddled
hundred	12	3	714	2	hundred
hurdled	12	37	983	2	hurdled
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	1525	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
rehandled	14	4	476	2	rehandled
saddled	10	31	1203	2	saddled
sandaled	10	3	923	2	sandaled
sanded	8	49	2061	2	sand_ed
tangled	9	42	1463	2	tangled
unhandled	14	4	570	2	unhandled
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 5 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.140	1276364.3
2	DLD Change Limit	107671	77	4.563	23596.5
3	Display Results	77	77	0.016	4812.5
	(SQL Overall)	178691	77	4.719	37866.3