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

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

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.

54 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
panhandlers	17	5	204	(None)
panhandler	16	5	254	1	panhandler_
panhandles	16	4	326	1	panhandle_s
manhandles	16	4	339	2	manhandle_s
panhandle	15	4	336	2	panhandle__
panhandled	17	7	262	2	panhandle_d
chandlers	15	38	767	3	__chandlers
handlers	12	40	1414	3	___handlers
manhandle	15	4	375	3	manhandle__
manhandled	17	5	263	3	manhandle_d
panhandling	18	5	230	3	panhandling
prehandles	16	4	418	3	prehandle_s
backhanders	23	12	380	4	backhand_ers
canallers	11	3	721	4	can_a_llers
candlers	11	42	1410	4	___candlers
chandler	14	35	837	4	__chandler_
chandlery	18	38	442	4	__chandlery
dandlers	10	39	1205	4	___dandlers
enhancers	14	4	510	4	_enhan_cers
enkindlers	15	8	199	4	_enkindlers
entanglers	11	6	303	4	_entanglers
handers	11	42	2433	4	___hand_ers
handler	11	35	1616	4	___handler_
handles	11	40	2065	4	___handle_s
handless	12	35	1206	4	___handless
inhalers	11	6	664	4	_inha__lers
inhaulers	12	6	324	4	_inha_ulers
inlanders	10	3	614	4	_inland_ers
landlers	9	43	1283	4	___landlers
mainlanders	14	6	250	4	mainland_ers
malanders	12	3	702	4	ma_land_ers
manhandling	18	5	227	4	manhandling
mishandles	16	4	377	4	mishandle_s
outhandles	14	7	365	4	outhandle_s
paddlers	12	32	915	4	p___addlers
paganizers	22	5	371	4	pa_ganizers
pandanuses	13	4	336	4	pandanuse_s
panders	10	34	2373	4	p___and_ers
panjandra	19	5	142	4	panjand__ra
panjandrums	23	6	90	4	panjandrums
panners	9	36	2127	4	pan__n__ers
panniers	10	48	885	4	pan__n_iers
pantalets	11	4	767	4	panta__lets
paraders	11	31	1311	4	pa_ra_d_ers
pathfinders	20	5	160	4	pathfind_ers
penholders	16	4	379	4	penhold_ers
pentangles	13	4	483	4	pentangle_s
philanders	16	4	427	4	philand_ers
pomanders	14	3	622	4	p_omand_ers
prehandle	15	4	453	4	prehandle__
prehandled	17	4	363	4	prehandle_d
rehandles	13	4	559	4	_rehandle_s
unhandier	13	4	488	4	_unhandier_
unhandled	14	4	570	4	_unhandle_d

Search took 10 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	148819	0.436	409841.7
2	DLD Change Limit	148819	54	8.656	17192.6
3	Display Results	54	54	0.030	1800.0
	(SQL Overall)	178691	54	9.122	19589.0