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

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

97 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
husker	13	42	1270	(None)
busker	12	55	1783	1	busker
hunker	13	39	1767	1	hunker
husked	14	42	1222	1	husked
huskers	14	35	1004	1	huskers
huskier	14	36	976	1	huskier
tusker	10	42	1219	1	tusker
asker	9	64	1878	2	_asker
bosker	12	38	1365	2	bosker
brusker	13	43	785	2	brusker
bucker	14	54	2046	2	bucker
bunker	12	45	1937	2	bunker
burker	12	52	2117	2	burker
busher	11	49	2220	2	busher
busier	8	52	1972	2	busier
busked	13	49	1770	2	busked
buskers	13	34	1409	2	buskers
buster	8	47	2649	2	buster
chukker	15	4	383	2	chukker
cusser	8	60	1609	2	cusser
ducker	13	43	1799	2	ducker
duiker	11	41	1059	2	duiker
dunker	11	36	1646	2	dunker
dusked	12	41	1251	2	dusked
duskier	12	40	943	2	duskier
duster	7	49	1972	2	duster
esker	9	44	1298	2	_esker
fucker	15	34	1442	2	fucker
funker	13	39	1576	2	funker
fusser	9	48	1377	2	fusser
gusher	10	41	1577	2	gusher
hacker	15	48	2269	2	hacker
hanker	13	46	2209	2	hanker
hawker	16	48	1266	2	hawker
hiker	12	51	1939	2	h_iker
hisser	9	47	1379	2	hisser
hocker	15	51	1856	2	hocker
honker	13	41	1746	2	honker
hooker	13	48	2017	2	hooker
hoser	8	115	2976	2	hos_er
hosier	9	42	1961	2	hosier
houser	9	53	2228	2	hous_er
huger	9	49	1487	2	hu_ger
hugger	11	47	1312	2	hugger
hulked	14	46	1130	2	hulked
hulkier	14	32	897	2	hulkier
huller	9	39	1910	2	huller
hummer	13	36	1527	2	hummer
humper	13	41	1588	2	humper
hunger	10	40	1520	2	hunger
hunkers	14	33	1433	2	hunkers
hunkey	16	42	1088	2	hunkey
hunkier	14	45	1214	2	hunkier
hunter	9	48	1777	2	hunter
hurler	9	47	1722	2	hurler
hurter	9	39	1585	2	hurter
hushed	13	44	1667	2	hushed
hushes	12	47	1859	2	hushes
husk	11	60	2195	2	husk__
huskies	14	32	1208	2	huskies
husks	12	50	1545	2	husk_s
husky	15	61	1256	2	husk_y
hussar	9	31	728	2	hussar
hustler	10	34	1075	2	hustler
junker	17	42	1365	2	junker
juster	13	46	1701	2	juster
lunker	10	47	1834	2	lunker
lurker	10	36	1329	2	lurker
lusher	9	38	1876	2	lusher
luster	6	40	2367	2	luster
masker	12	44	1610	2	masker
mucker	14	38	1639	2	mucker
murker	12	37	1524	2	murker
muser	7	60	2412	2	mus_er
musher	11	38	2057	2	musher
muskeg	13	33	818	2	muskeg
musket	12	28	1820	2	musket
muskier	13	43	1273	2	muskier
muster	8	47	2452	2	muster
ouster	6	42	2373	2	ouster
pucker	14	38	1763	2	pucker
punker	12	37	1882	2	punker
pusher	11	43	1828	2	pusher
quaker	19	38	1162	2	quaker
risker	10	54	1449	2	risker
rusher	9	40	1965	2	rusher
shucker	16	37	1010	2	shucker
shusher	13	28	811	2	shusher
sucker	12	41	2066	2	sucker
sulker	10	40	1592	2	sulker
tucker	12	43	1695	2	tucker
tusked	11	41	1215	2	tusked
tuskers	11	37	1004	2	tuskers
tusser	6	46	1583	2	tusser
user	4	50	2300	2	_us_er
usher	8	45	1776	2	_usher
whisker	17	36	793	2	whisker

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	97	2.140	38575.2
3	Display Results	97	97	0.033	2939.4
	(SQL Overall)	178691	97	2.516	71021.9