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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

110 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
whiter	12	43	1639	(None)
waiter	9	43	2125	1	waiter
whiner	12	45	1663	1	whiner
white	11	49	2030	1	white_
whited	13	48	1408	1	whited
whiten	12	41	1192	1	whiten
whites	12	39	1988	1	whites
whitey	15	49	1188	1	whitey
whither	16	35	1025	1	whither
whitier	13	33	1106	1	whitier
whitter	13	91	1089	1	whitter
writer	9	44	1651	1	writer
awaiter	10	5	744	2	awaiter
baiter	8	44	2255	2	baiter
biter	7	50	3003	2	_biter
chicer	13	45	1360	2	chicer
chider	12	51	1605	2	chider
chimer	13	55	1720	2	chimer
chitter	12	41	1296	2	chitter
citer	7	48	2733	2	_citer
gaiter	7	38	1950	2	gaiter
goiter	7	41	1620	2	goiter
hater	8	50	3475	2	_hater
hider	9	50	2408	2	_hider
hiker	12	51	1939	2	_hiker
hinter	9	40	2130	2	_hinter
hirer	8	54	2312	2	_hirer
hither	12	44	1725	2	_hither
hitter	9	44	1986	2	_hitter
kiter	9	55	2321	2	_kiter
liter	5	47	3634	2	_liter
loiter	6	46	1917	2	loiter
miter	7	57	3479	2	_miter
niter	5	50	2897	2	_niter
philter	12	10	821	2	philter
shier	8	54	2894	2	shi_er
shifter	13	29	1108	2	shifter
shiner	9	38	2087	2	shiner
shiver	12	45	1737	2	shiver
smiter	8	36	1641	2	smiter
suiter	6	41	2181	2	suiter
thither	13	32	810	2	thither
titer	5	54	3061	2	_titer
triter	6	51	2059	2	triter
uniter	6	46	1914	2	uniter
wafter	12	41	1461	2	wafter
wailer	9	37	2032	2	wailer
waister	10	38	1238	2	waister
waited	10	38	1977	2	waited
waiters	10	42	1862	2	waiters
waiver	12	42	1271	2	waiver
wanter	9	44	2305	2	wanter
waster	9	52	2894	2	waster
water	8	47	3331	2	w_ater
watter	9	32	2198	2	watter
weiner	9	42	1413	2	weiner
welter	9	34	1738	2	welter
wester	9	42	2289	2	wester
wetter	9	39	1944	2	wetter
whaler	12	46	1197	2	whaler
whether	16	34	662	2	whether
whetter	13	34	880	2	whetter
whicker	19	35	977	2	whicker
whiffer	19	10	532	2	whiffer
while	11	54	1869	2	while_
whiled	13	45	1413	2	whiled
whiles	12	44	1801	2	whiles
whimper	17	29	772	2	whimper
whine	11	60	2281	2	whine_
whined	13	47	1520	2	whined
whiners	13	40	1157	2	whiners
whines	12	51	2010	2	whines
whiney	15	50	1264	2	whiney
whinger	14	108	1091	2	whinger
whinier	13	41	1063	2	whinier
whipper	17	36	1138	2	whipper
whir	10	55	1928	2	whi__r
whirler	13	30	760	2	whirler
whirr	11	46	1119	2	whi_rr
whisker	17	36	793	2	whisker
whisper	15	29	801	2	whisper
whisted	14	40	1001	2	whisted
whistler	14	9	631	2	whistler
whit	10	48	3417	2	whit__
whitely	16	34	647	2	whitely
whitener	14	3	573	2	whitener
whitens	13	42	873	2	whitens
whitest	13	37	1011	2	whitest
whiteys	16	39	615	2	whiteys
whities	13	31	1325	2	whities
whits	11	59	2382	2	whit_s
whitters	14	35	940	2	whitters
whittler	14	9	519	2	whittler
whity	14	55	1347	2	whit_y
whizzer	21	3	458	2	whizzer
wider	9	48	2635	2	w_ider
winter	9	42	2280	2	winter
wiper	10	54	2129	2	w_iper
wirer	8	51	2495	2	w_irer
wiser	8	55	2280	2	w_iser
wite	7	54	4327	2	w_ite_
wited	9	47	2714	2	w_ited
wites	8	55	3696	2	w_ites
wither	12	43	2135	2	w_ither
wiver	11	59	2451	2	w_iver
wrier	8	45	2175	2	wri_er
write	8	55	2283	2	write_
writers	10	55	1349	2	writers
writes	9	44	2033	2	writes
writher	13	40	1085	2	writher

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	110	2.093	39441.5
3	Display Results	110	110	0.046	2391.3
	(SQL Overall)	178691	110	2.482	71994.8