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

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

73 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
spender	10	37	1369	(None)
sender	7	38	2441	1	s_ender
slender	8	34	1359	1	slender
speeder	10	38	1107	1	speeder
spencer	11	36	1097	1	spencer
spenders	11	32	1174	1	spenders
spendier	11	4	714	1	spendier
amender	10	34	961	2	amender
ascender	11	3	673	2	ascender
bender	9	52	2330	2	_bender
blender	10	46	1384	2	blender
emender	10	64	984	2	emender
ender	6	43	2586	2	__ender
expender	18	13	684	2	expender
fender	10	37	1872	2	_fender
gender	8	35	1793	2	_gender
lender	7	39	2127	2	_lender
mender	9	35	2079	2	_mender
opener	8	39	1099	2	open_er
pander	9	37	2552	2	_pander
pended	10	38	1901	2	_pended
penner	8	46	1666	2	_penner
pinder	9	45	2345	2	_pinder
ponder	9	45	2169	2	_ponder
render	7	40	2414	2	_render
sander	7	48	2853	2	s_ander
scended	11	32	987	2	scended
seder	6	48	2676	2	s_e_der
seeder	7	43	2077	2	s_eeder
sended	8	51	2123	2	s_ended
senders	8	30	2235	2	s_enders
shedder	12	33	932	2	shedder
slander	8	40	1544	2	slander
sledder	9	39	920	2	sledder
sonder	7	36	2352	2	s_onder
sounder	8	33	1538	2	sounder
spader	9	43	1713	2	sp_ader
spandex	17	3	583	2	spandex
spanker	13	36	1235	2	spanker
spanner	9	43	1256	2	spanner
speaker	13	33	1121	2	speaker
spearer	9	39	1366	2	spearer
specter	11	31	1173	2	specter
speeded	11	33	1042	2	speeded
speeders	11	33	931	2	speeders
speedier	11	4	662	2	speedier
speer	7	46	2390	2	spe__er
speller	9	54	1514	2	speller
spelter	9	41	1370	2	spelter
spence	10	38	1379	2	spence_
spencers	12	26	919	2	spencers
spences	11	34	1392	2	spences
spend	8	56	1933	2	spend__
spends	9	47	1447	2	spend_s
spendy	12	49	1114	2	spend_y
spense	8	39	1243	2	spense_
spenses	9	29	1357	2	spenses
spewer	11	51	1215	2	spe_wer
spider	9	45	1680	2	sp_ider
spindler	11	29	798	2	spindler
spinier	9	37	1516	2	spinier
spinner	9	39	1226	2	spinner
splendor	11	4	375	2	splendor
spondee	10	3	1059	2	spondee
sponger	10	3	852	2	sponger
spreader	11	3	748	2	spreader
spudder	11	25	655	2	spudder
stander	8	43	1616	2	stander
sunder	7	40	1982	2	s_under
suspender	12	11	509	2	suspender
tender	7	41	2184	2	_tender
upended	11	26	732	2	upended
vender	10	34	1842	2	_vender

Search took 7 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.563	317390.8
2	DLD Change Limit	107671	73	6.140	17536.0
3	Display Results	73	73	0.063	1158.7
	(SQL Overall)	178691	73	6.766	26410.1