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

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

93 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
showers	13	46	1268	(None)
shewers	13	43	1205	1	shewers
shoers	9	45	1833	1	sho_ers
shovers	13	46	1300	1	shovers
shower	12	43	1511	1	shower_
showery	16	43	724	1	showery
sowers	9	49	2344	1	s_owers
avowers	13	3	633	2	avowers
blowers	12	43	1359	2	blowers
bowers	11	55	2370	2	_bowers
chawers	15	44	1205	2	chawers
chewers	15	41	1114	2	chewers
chokers	16	43	1152	2	chokers
cholers	12	42	1520	2	cholers
chowders	17	38	754	2	chowders
cowers	11	46	2553	2	_cowers
crowers	12	46	1490	2	crowers
dowers	10	45	2329	2	_dowers
flowers	13	34	1317	2	flowers
glowers	11	34	1209	2	glowers
growers	11	36	1272	2	growers
hewers	12	37	1527	2	_hewers
hoers	8	57	2492	2	_ho_ers
homers	11	48	2198	2	_homers
honers	9	43	2497	2	_honers
hopers	11	42	2297	2	_hopers
hosers	9	52	2397	2	_hosers
hovers	12	43	2025	2	_hovers
howes	11	47	3026	2	_howe_s
howlers	13	33	1235	2	_howlers
knowers	14	3	635	2	knowers
lowers	9	46	2492	2	_lowers
mowers	11	32	1940	2	_mowers
plowers	12	38	1224	2	plowers
powers	11	38	2232	2	_powers
reshowers	15	14	547	2	reshowers
rowers	9	49	2457	2	_rowers
sawers	9	46	2016	2	s_awers
scorers	9	41	1532	2	scorers
scoters	9	33	1381	2	scoters
scowders	14	27	623	2	scowders
scowlers	13	25	737	2	scowlers
sewers	9	47	1972	2	s_ewers
shaders	11	59	1555	2	shaders
shadowers	16	4	430	2	shadowers
shakers	14	40	1556	2	shakers
shapers	12	40	1689	2	shapers
sharers	10	47	2062	2	sharers
shavers	13	41	1509	2	shavers
sheers	9	43	2240	2	sh_eers
shewer	12	45	1511	2	shewer_
shiers	9	49	2175	2	sh_iers
shiners	10	40	1594	2	shiners
shivers	13	37	1483	2	shivers
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
shovels	13	37	839	2	shovels
shover	12	45	1599	2	shover_
shoves	12	49	1942	2	shove_s
showed	13	50	1697	2	showe_d
showered	15	3	701	2	showered
showerer	14	3	616	2	showerer
showerers	15	4	507	2	showerers
showier	13	3	910	2	showier_
shows	11	53	2458	2	show__s
shyers	12	47	1220	2	sh_yers
skewers	14	49	838	2	skewers
slopers	9	42	1309	2	slopers
slower	9	40	1615	2	slower_
smokers	13	38	932	2	smokers
snorers	7	43	1380	2	snorers
sobers	8	52	1886	2	s_obers
sooners	7	39	1664	2	sooners
sowars	9	43	1801	2	s_owars
sowens	9	36	1315	2	s_owens
sower	8	52	2931	2	s_ower_
spewers	12	42	1066	2	spewers
stokers	11	45	1518	2	stokers
stoners	7	48	1795	2	stoners
stopers	9	42	1737	2	stopers
storers	7	50	1868	2	storers
stovers	10	37	1373	2	stovers
thawers	13	42	848	2	thawers
throwers	14	10	603	2	throwers
towers	9	44	2367	2	_towers
vowers	12	43	1718	2	_vowers

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.376	475242.0
2	DLD Change Limit	107671	93	3.423	31455.2
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	3.829	46667.8