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

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

114 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
whiner	12	45	1663	(None)
shiner	9	38	2087	1	shiner
weiner	9	42	1413	1	weiner
whine	11	60	2281	1	whine_
whined	13	47	1520	1	whined
whiners	13	40	1157	1	whiners
whines	12	51	2010	1	whines
whiney	15	50	1264	1	whiney
whinger	14	108	1091	1	whinger
whinier	13	41	1063	1	whinier
whiter	12	43	1639	1	whiter
aliner	6	56	2198	2	aliner
biner	7	59	3069	2	_biner
briner	8	45	1904	2	briner
chicer	13	45	1360	2	chicer
chider	12	51	1605	2	chider
chimer	13	55	1720	2	chimer
chine	10	52	3172	2	chine_
chined	12	56	2006	2	chined
chines	11	50	2917	2	chines
coiner	8	43	2378	2	coiner
diner	6	56	3290	2	_diner
fainer	9	47	1724	2	fainer
finer	8	54	3156	2	_finer
gainer	7	41	1749	2	gainer
hider	9	50	2408	2	_hider
hiker	12	51	1939	2	_hiker
hinder	10	41	2006	2	_hinder
hinger	10	47	2333	2	_hinger
hinter	9	40	2130	2	_hinter
hirer	8	54	2312	2	_hirer
honer	8	53	3209	2	_honer
joiner	13	41	1413	2	joiner
liner	5	59	3892	2	_liner
miner	7	69	3354	2	_miner
ruiner	6	40	1364	2	ruiner
seiner	6	46	2248	2	seiner
shier	8	54	2894	2	shi_er
shine	8	55	3309	2	shine_
shined	10	46	2078	2	shined
shiners	10	40	1594	2	shiners
shines	9	50	2891	2	shines
shinier	10	41	1314	2	shinier
shiver	12	45	1737	2	shiver
thine	8	50	2686	2	thine_
thinker	14	36	1068	2	thinker
thinner	10	35	897	2	thinner
twiner	9	40	1259	2	twiner
vainer	9	37	1457	2	vainer
veiner	9	45	1475	2	veiner
wahine	12	38	1301	2	wahine_
wahines	13	31	1117	2	wahines
wailer	9	37	2032	2	wailer
waiter	9	43	2125	2	waiter
waiver	12	42	1271	2	waiver
wanier	9	39	2068	2	wanier
wanner	9	40	1962	2	wanner
warner	9	37	1722	2	warner
weaner	9	38	1677	2	weaner
weiners	10	39	1306	2	weiners
whaler	12	46	1197	2	whaler
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
whin	10	52	2569	2	whin__
whinge	13	43	1154	2	whinge
whinged	15	40	915	2	whinged
whingers	15	35	872	2	whingers
whinges	14	36	1063	2	whinges
whinnier	14	25	500	2	whinnier
whinny	15	58	749	2	whinny
whins	11	49	2233	2	whin_s
whiny	14	49	1557	2	whin_y
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
white	11	49	2030	2	white_
whited	13	48	1408	2	whited
whiten	12	41	1192	2	whiten
whitener	14	3	573	2	whitener
whites	12	39	1988	2	whites
whitey	15	49	1188	2	whitey
whither	16	35	1025	2	whither
whitier	13	33	1106	2	whitier
whitter	13	91	1089	2	whitter
whizzer	21	3	458	2	whizzer
wider	9	48	2635	2	w_ider
wiener	9	45	1354	2	wiener
wincer	11	50	1819	2	w_incer
winder	10	40	2526	2	w_inder
wine	7	49	5342	2	w_ine_
wined	9	44	3418	2	w_ined
winery	12	50	1428	2	w_inery
wines	8	55	4686	2	w_ines
winey	11	53	2543	2	w_iney
winger	10	41	2544	2	w_inger
winier	9	45	2245	2	w_inier
winker	13	42	2029	2	w_inker
winner	9	42	1993	2	winner
winter	9	42	2280	2	w_inter
wiper	10	54	2129	2	w_iper
wirer	8	51	2495	2	w_irer
wiser	8	55	2280	2	w_iser
wiver	11	59	2451	2	w_iver
wonner	9	51	1444	2	wonner
wrier	8	45	2175	2	wri_er
wringer	11	36	1245	2	wringer
writer	9	44	1651	2	writer

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.360	496363.9
2	DLD Change Limit	82551	114	2.093	39441.5
3	Display Results	114	114	0.046	2478.3
	(SQL Overall)	178691	114	2.499	71505.0