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

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

38 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
wickless	17	3	608	(None)
backless	16	29	1063	2	backless
clickless	17	4	398	2	clickless
feckless	17	22	578	2	feckless
ficklest	17	26	790	2	ficklest
iceless	9	21	996	2	_iceless
inkless	11	34	871	2	_inkless
luckless	14	26	589	2	luckless
mickles	15	34	1500	2	mickle_s
micklest	16	21	912	2	micklest
milkless	14	3	477	2	milkless
neckless	14	23	643	2	neckless
nickles	13	37	1382	2	nickle_s
pickles	15	32	1544	2	pickle_s
reckless	14	25	797	2	reckless
riskless	12	3	576	2	riskless
rockless	14	29	729	2	rockless
sickles	13	34	1754	2	sickle_s
sickness	14	3	783	2	sickness
sockless	14	26	779	2	sockless
suckless	14	28	882	2	suckless
tackless	14	41	948	2	tackless
ticklers	14	33	930	2	ticklers
tickles	13	34	1685	2	tickle_s
viceless	13	3	798	2	viceless
wickers	16	41	1470	2	wick_ers
wickets	16	40	1094	2	wick_ets
wifeless	14	27	748	2	wifeless
wigless	11	35	967	2	wi_gless
windless	12	33	1086	2	windless
wineless	11	27	1117	2	wineless
wingless	12	29	1002	2	wingless
winkles	14	34	1277	2	winkle_s
winless	10	32	1228	2	wi_nless
wireless	11	24	963	2	wireless
wishless	14	3	599	2	wishless
witless	10	33	1098	2	wi_tless
workless	15	27	680	2	workless

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	121059	0.390	458182.1
2	DLD Change Limit	121059	38	3.360	36029.5
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	3.766	47448.5