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

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

82 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
whiners	13	40	1157	(None)
shiners	10	40	1594	1	shiners
weiners	10	39	1306	1	weiners
whiner	12	45	1663	1	whiner_
whines	12	51	2010	1	whine_s
whingers	15	35	872	1	whingers
aliners	7	47	1772	2	aliners
biners	8	50	2363	2	_biners
briners	9	43	1563	2	briners
chiders	13	53	1294	2	chiders
chimers	14	45	1514	2	chimers
chines	11	50	2917	2	chine_s
coiners	9	36	2075	2	coiners
diners	7	55	2595	2	_diners
gainers	8	42	1459	2	gainers
hiders	10	49	1965	2	_hiders
hikers	13	50	1435	2	_hikers
hinders	11	37	1850	2	_hinders
hingers	11	34	2021	2	_hingers
hinters	10	37	1958	2	_hinters
hirers	9	45	1806	2	_hirers
honers	9	43	2497	2	_honers
joiners	14	42	1157	2	joiners
liners	6	54	2885	2	_liners
miners	8	41	2663	2	_miners
ruiners	7	42	1302	2	ruiners
seiners	7	42	1927	2	seiners
shiers	9	49	2175	2	shi_ers
shiner	9	38	2087	2	shiner_
shines	9	50	2891	2	shine_s
shivers	13	37	1483	2	shivers
thinkers	15	30	870	2	thinkers
thinners	11	32	776	2	thinners
twiners	10	45	963	2	twiners
veiners	10	41	1252	2	veiners
wahines	13	31	1117	2	wahine_s
wailers	10	39	1681	2	wailers
waiters	10	42	1862	2	waiters
waivers	13	34	1005	2	waivers
warners	10	33	1556	2	warners
weaners	10	46	1383	2	weaners
weiner	9	42	1413	2	weiner_
whalers	13	52	971	2	whalers
whickers	20	29	798	2	whickers
whiffers	20	6	449	2	whiffers
whiles	12	44	1801	2	while_s
whimpers	18	27	661	2	whimpers
whine	11	60	2281	2	whine__
whined	13	47	1520	2	whine_d
whiney	15	50	1264	2	whine_y
whinger	14	108	1091	2	whinger_
whinges	14	36	1063	2	whinges
whinier	13	41	1063	2	whinier_
whins	11	49	2233	2	whin__s
whippers	18	32	904	2	whippers
whirlers	14	28	605	2	whirlers
whirrs	12	40	859	2	whi_rrs
whirs	11	52	1809	2	whi__rs
whiskers	18	30	677	2	whiskers
whispers	16	26	699	2	whispers
whiteners	15	3	525	2	whiteners
whitens	13	42	873	2	whitens
whiter	12	43	1639	2	whiter_
whites	12	39	1988	2	white_s
whiteys	16	39	615	2	whiteys
whitters	14	35	940	2	whitters
whizzers	22	3	342	2	whizzers
wieners	10	32	1248	2	wieners
wincers	12	34	1536	2	w_incers
winders	11	37	2126	2	w_inders
winery	12	50	1428	2	w_inery
wines	8	55	4686	2	w_ine_s
wingers	11	39	2148	2	w_ingers
winkers	14	35	1711	2	w_inkers
winners	10	43	1691	2	winners
winters	10	37	2048	2	w_inters
wipers	11	54	1608	2	w_ipers
wirers	9	46	1789	2	w_irers
wivers	12	53	2080	2	w_ivers
wonners	10	43	1281	2	wonners
wringers	12	31	1007	2	wringers
writers	10	55	1349	2	writers

Search took 10 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.610	292936.1
2	DLD Change Limit	107671	82	9.063	11880.3
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	9.719	18385.7