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

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

69 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
whicker	19	35	977	(None)
shicker	16	39	1482	1	shicker
thicker	16	36	1102	1	thicker
whacker	19	36	850	1	whacker
whickers	20	29	798	1	whickers
whisker	17	36	793	1	whisker
wicker	15	45	1867	1	w_icker
bicker	14	48	1917	2	_bicker
checker	18	32	953	2	checker
chicer	13	45	1360	2	chic_er
chickee	18	31	1155	2	chickee
chicken	18	27	898	2	chicken
chirker	16	42	932	2	chirker
clicker	15	41	1188	2	clicker
dicker	13	45	2140	2	_dicker
flicker	16	36	1062	2	flicker
hacker	15	48	2269	2	_hacker
hickey	18	50	1199	2	_hickey
hiker	12	51	1939	2	_hi_ker
hocker	15	51	1856	2	_hocker
icker	11	40	1844	2	__icker
kicker	11	41	1618	2	_kicker
licker	12	52	2204	2	_licker
nicker	12	38	1870	2	_nicker
picker	14	44	2217	2	_picker
pricker	15	40	1341	2	pricker
quicker	22	4	702	2	quicker
shickers	17	30	1282	2	shickers
shikker	13	27	702	2	shikker
shirker	14	37	1134	2	shirker
shocker	16	34	1143	2	shocker
shucker	16	37	1010	2	shucker
sicker	12	40	2390	2	_sicker
slicker	13	33	1453	2	slicker
snicker	13	30	1267	2	snicker
sticker	13	35	1588	2	sticker
thicken	16	31	787	2	thicken
thicket	16	32	1307	2	thicket
thinker	14	36	1068	2	thinker
ticker	12	43	2150	2	_ticker
tricker	13	46	1552	2	tricker
wacker	15	49	2012	2	w_acker
whacked	20	45	862	2	whacked
whackers	20	32	654	2	whackers
whackier	20	4	467	2	whackier
whickered	22	11	403	2	whickered
whiffer	19	10	532	2	whiffer
whimper	17	29	772	2	whimper
whiner	12	45	1663	2	whi_ner
whinger	14	108	1091	2	whinger
whinier	13	41	1063	2	whinier
whipper	17	36	1138	2	whipper
whirler	13	30	760	2	whirler
whisked	18	33	691	2	whisked
whiskers	18	30	677	2	whiskers
whiskery	21	31	455	2	whiskery
whiskey	20	44	558	2	whiskey
whisper	15	29	801	2	whisper
whiter	12	43	1639	2	whi_ter
whither	16	35	1025	2	whither
whitier	13	33	1106	2	whitier
whitter	13	91	1089	2	whitter
whizzer	21	3	458	2	whizzer
wicked	16	43	1741	2	w_icked
wickers	16	41	1470	2	w_ickers
wicket	15	53	1894	2	w_icket
winker	13	42	2029	2	w_inker
wrecker	16	36	760	2	wrecker
wricked	17	49	1019	2	wricked

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.373	479064.3
2	DLD Change Limit	107671	69	3.190	33752.7
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	3.593	49733.1