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

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

91 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
shovers	13	46	1300	(None)
hovers	12	43	2025	1	_hovers
shavers	13	41	1509	1	shavers
shivers	13	37	1483	1	shivers
shoers	9	45	1833	1	sho_ers
shovels	13	37	839	1	shovels
shover	12	45	1599	1	shover_
shoves	12	49	1942	1	shove_s
showers	13	46	1268	1	showers
stovers	10	37	1373	1	stovers
chokers	16	43	1152	2	chokers
cholers	12	42	1520	2	cholers
clovers	12	51	1466	2	clovers
covers	11	46	2796	2	_covers
drovers	11	52	1264	2	drovers
estovers	11	3	645	2	estovers
glovers	11	43	1088	2	glovers
havers	12	47	2148	2	_havers
hoers	8	57	2492	2	_ho_ers
homers	11	48	2197	2	_homers
honers	9	43	2497	2	_honers
hoovers	13	43	1270	2	hoovers
hopers	11	42	2297	2	_hopers
hosers	9	52	2396	2	_hosers
hovels	12	54	1333	2	_hovels
hover	11	55	2413	2	_hover_
lovers	9	42	2343	2	_lovers
movers	11	51	1719	2	_movers
overs	8	52	2479	2	__overs
plovers	12	36	1183	2	plovers
provers	12	38	1779	2	provers
pushovers	17	4	300	2	pushovers
rovers	9	54	2352	2	_rovers
salvers	10	39	1600	2	salvers
savers	9	38	2592	2	s_avers
scorers	9	41	1532	2	scorers
scoters	9	33	1381	2	scoters
servers	10	32	1483	2	servers
severs	9	41	2112	2	s_evers
shaders	11	59	1555	2	shaders
shakers	14	40	1556	2	shakers
shapers	12	40	1689	2	shapers
sharers	10	47	2062	2	sharers
shaver	12	37	1891	2	shaver_
shaves	12	52	2493	2	shave_s
sheers	9	43	2240	2	sh_eers
shelvers	14	38	881	2	shelvers
shewers	13	43	1205	2	shewers
shiers	9	49	2175	2	sh_iers
shiners	10	40	1594	2	shiners
shiver	12	45	1737	2	shiver_
shivery	16	31	702	2	shivery
shives	12	49	2141	2	shive_s
shockers	17	31	946	2	shockers
shoer	8	47	2216	2	sho_er_
shoes	8	54	2966	2	sho_e_s
shofars	13	3	583	2	shofars
shooters	11	28	1158	2	shooters
shoppers	15	30	1076	2	shoppers
shores	9	48	3041	2	shore_s
shotes	9	53	2191	2	shote_s
shouters	11	35	1062	2	shouters
shove	11	44	2104	2	shove__
shoved	13	42	1428	2	shove_d
shovel	12	46	1132	2	shove_l
shovelers	15	17	494	2	shovelers
shower	12	43	1511	2	shower_
showery	16	43	724	2	showery
shrivers	14	41	910	2	shrivers
shyers	12	47	1220	2	sh_yers
silvers	10	47	1404	2	silvers
sivers	9	53	2415	2	s_ivers
skivers	14	40	970	2	skivers
slavers	10	37	1650	2	slavers
slivers	10	41	1525	2	slivers
slopers	9	42	1309	2	slopers
slovens	10	31	657	2	slovens
smokers	13	38	932	2	smokers
snorers	7	43	1380	2	snorers
sobers	8	52	1886	2	s_obers
solvers	10	44	1425	2	solvers
sooners	7	39	1664	2	sooners
sowers	9	49	2344	2	s_owers
stivers	10	36	1354	2	stivers
stokers	11	45	1518	2	stokers
stoners	7	48	1795	2	stoners
stopers	9	42	1737	2	stopers
storers	7	50	1868	2	storers
stover	9	41	1564	2	stover_
stoves	9	38	1892	2	stove_s
trovers	10	37	1332	2	trovers

Search took 4 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.373	479064.3
2	DLD Change Limit	107671	91	2.970	36252.9
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	3.373	52976.9