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

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

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.

61 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
handlists	13	4	713	(None)
handlist	12	3	1133	1	handlist_
handfasts	16	4	459	2	handfasts
handless	12	35	1206	2	handles_s
handlings	14	23	734	2	handlings
panelists	11	4	834	2	panelists
analysts	11	16	744	3	_analysts
animists	10	30	1063	3	_animists
annalists	9	4	906	3	annalists
backlists	17	11	741	3	backlists
bandits	10	38	1479	3	band_i_ts
banjoists	18	4	325	3	banjoists
bundists	11	4	538	3	bund_ists
cabalists	13	3	915	3	cabalists
canalises	11	5	1549	3	canalises
canoeists	11	4	716	3	canoeists
canonists	11	5	851	3	canonists
dadaists	10	4	558	3	da_daists
dandyisms	16	4	322	3	dandyisms
enlists	7	4	939	3	_en_lists
fabulists	14	4	472	3	fabulists
faddists	13	23	554	3	fa_ddists
fatalists	12	3	1002	3	fatalists
finalists	12	30	1016	3	finalists
hagadists	14	4	507	3	hagadists
halakists	16	12	535	3	halakists
handbills	15	11	474	3	handbills
handcarts	15	4	553	3	handcarts
handclasps	18	5	232	3	handclasps
handfast	15	4	673	3	handfast_
handiest	12	34	1777	3	handiest_
handlers	12	40	1414	3	handl_ers
handles	11	40	2065	3	handl__es
handlike	16	3	915	3	handli_ke
handling	13	23	1271	3	handli_ng
handlooms	15	4	383	3	handlooms
handouts	12	3	823	3	hand_outs
handpicks	21	4	323	3	handpicks
handprints	16	4	397	3	handprints
handsets	12	25	834	3	hand_sets
hangnests	13	4	454	3	hangnests
harpists	13	3	810	3	ha_rpists
holists	10	44	1396	3	h__olists
homilists	14	5	681	3	homilists
kabalists	15	4	629	3	kabalists
landless	9	40	1117	3	landles_s
landlines	10	3	976	3	landlines
midlists	11	3	752	3	_midlists
pandits	10	39	1421	3	pand_i_ts
panelist	10	4	1450	3	panelist_
phallists	14	4	572	3	pha_llists
sadists	8	33	1085	3	sa_d_ists
sandblasts	13	9	368	3	sandblasts
sandless	9	32	1234	3	sandles_s
sandlings	11	23	809	3	sandlings
sandlots	9	3	829	3	sandl_ots
sandpits	11	4	684	3	sandpi_ts
tanists	7	3	1365	3	tan__ists
vandalises	14	4	681	3	vandalises
vandalisms	16	4	580	3	vandalisms
waitlists	12	4	460	3	waitlists

Search took 7 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	148641	0.436	409841.7
2	DLD Change Limit	148641	61	6.313	23545.2
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	6.779	26359.5