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

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

77 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
whirls	12	47	1053	(None)
thirls	9	50	1206	1	thirls
whirl	11	49	1382	1	whirl_
whirly	15	44	886	1	whirly
whirrs	12	40	859	1	whirrs
whirs	11	52	1809	1	whir_s
whorls	12	44	1016	1	whorls
awhirl	12	6	467	2	awhirl_
birls	7	40	2316	2	_birls
chiels	11	51	1593	2	chiels
chills	11	47	1770	2	chills
chirks	15	54	1484	2	chirks
chirms	13	51	1398	2	chirms
chiros	11	46	1777	2	chiros
chirps	13	54	1400	2	chirps
chirrs	11	45	1498	2	chirrs
chirus	11	46	1569	2	chirus
churls	11	54	1107	2	churls
dirls	6	47	2050	2	_dirls
girls	6	45	1839	2	_girls
harls	8	56	3450	2	_harls
herls	8	52	2643	2	_herls
hills	8	54	3135	2	_hills
hires	8	61	3434	2	_hires
hurls	8	65	2271	2	_hurls
phials	11	5	887	2	phials
shiels	9	54	1892	2	shiels
shills	9	45	1961	2	shills
shires	9	52	2557	2	shires
shirks	13	48	1412	2	shirks
shirrs	9	44	1317	2	shirrs
shirts	9	49	1834	2	shirts
shorls	9	45	1620	2	shorls
skirls	10	44	982	2	skirls
swirls	9	40	1013	2	swirls
thills	9	55	1538	2	thills
thiols	9	51	1276	2	thiols
thirds	10	43	860	2	thirds
thirl	8	54	1682	2	thirl_
thurls	9	41	871	2	thurls
tirls	5	45	1980	2	_tirls
twirls	9	47	812	2	twirls
virls	8	56	1860	2	_virls
wails	8	66	3148	2	wai_ls
wairs	8	64	2406	2	wair_s
weirds	10	47	805	2	weirds
weirs	8	43	1649	2	weir_s
wharfs	15	4	637	2	wharfs
wheals	12	45	1252	2	wheals
wheels	12	38	1171	2	wheels
wheres	12	59	1743	2	wheres
whids	12	54	1398	2	whi_ds
whiffs	18	3	508	2	whiffs
whigs	12	56	1264	2	whi_gs
while	11	54	1869	2	whi_le
whiles	12	44	1801	2	whiles
whilst	12	3	914	2	whi_lst
whims	13	45	1533	2	whi_ms
whines	12	51	2010	2	whines
whins	11	49	2233	2	whi_ns
whips	13	49	1708	2	whi_ps
whir	10	55	1928	2	whir__
whirled	14	36	804	2	whirled
whirler	13	30	760	2	whirler
whirlers	14	28	605	2	whirlers
whirlies	14	16	737	2	whirlies
whirr	11	46	1119	2	whir_r
whirry	15	47	706	2	whirry
whisks	16	49	735	2	whisks
whists	12	46	1381	2	whists
whites	12	39	1988	2	whites
whits	11	59	2382	2	whi_ts
whores	12	56	1710	2	whores
whorl	11	46	1245	2	whorl_
whorts	12	51	1143	2	whorts
wills	8	45	2896	2	w_ills
wires	8	60	3491	2	w_ires

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	77	2.466	33475.7
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	2.842	62875.1