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

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

80 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
stotted	8	35	1142	(None)
shotted	11	39	1240	1	shotted
slotted	8	46	1388	1	slotted
sotted	7	41	2140	1	s_otted
spotted	10	37	1314	1	spotted
stetted	8	26	1040	1	stetted
swotted	11	39	871	1	swotted
totted	7	43	1995	1	_totted
blotted	10	39	1183	2	blotted
clotted	10	40	1182	2	clotted
dotted	8	47	1752	2	_dotted
hotted	10	43	1994	2	_hotted
jotted	14	36	1517	2	_jotted
knotted	12	35	723	2	knotted
lotted	7	42	2240	2	_lotted
plotted	10	46	1237	2	plotted
potted	9	46	2401	2	_potted
rotted	7	45	2443	2	_rotted
scatted	10	35	1277	2	scatted
scooted	10	36	1228	2	scooted
scouted	10	41	1203	2	scouted
shitted	11	42	1205	2	shitted
shorted	11	36	1440	2	shorted
shotten	10	28	846	2	shotten
shouted	11	39	1155	2	shouted
slatted	8	40	1518	2	slatted
slitted	8	35	1331	2	slitted
slotter	7	33	1445	2	slotter
smutted	10	3	746	2	smutted
snooted	8	42	1328	2	snooted
snorted	8	38	1349	2	snorted
snouted	8	43	1134	2	snouted
sooted	7	39	2259	2	s_ooted
soothed	11	37	1274	2	soothed
sorted	7	45	2371	2	s_orted
spatted	10	40	1414	2	spatted
spitted	10	39	1270	2	spitted
sported	10	40	1543	2	sported
spotter	9	45	1488	2	spotter
spouted	10	34	1226	2	spouted
started	8	42	1732	2	started
stated	7	54	2783	2	st_ated
statued	8	45	989	2	statued
stilted	8	35	1147	2	stilted
stinted	8	29	1419	2	stinted
stobbed	12	28	749	2	stobbed
stocked	14	43	1287	2	stocked
stodged	10	37	798	2	stodged
stoked	11	47	1829	2	sto_ked
stoled	7	45	2159	2	sto_led
stomped	12	41	1053	2	stomped
stoned	7	59	2314	2	sto_ned
stooged	9	43	1073	2	stooged
stooked	12	43	1230	2	stooked
stooled	8	43	1389	2	stooled
stooped	10	38	1383	2	stooped
stoped	9	47	2101	2	sto_ped
stopped	12	45	1220	2	stopped
stored	7	55	2421	2	sto_red
storied	8	5	1516	2	storied
stormed	10	3	904	2	stormed
stott	5	69	2979	2	stott__
stotts	6	46	1286	2	stott_s
stouten	7	30	733	2	stouten
stouter	7	40	1205	2	stouter
stowed	10	58	1720	2	sto_wed
strutted	9	4	634	2	strutted
stunted	8	30	1040	2	stunted
stutter	7	29	1146	2	stutter
swatted	11	41	1069	2	swatted
swotter	10	39	947	2	swotter
tatted	7	49	2053	2	_tatted
toited	7	40	1675	2	_toited
tooted	7	46	2012	2	_tooted
toted	6	49	2948	2	_to_ted
totter	6	50	2146	2	_totter
touted	7	44	1974	2	_touted
trotted	8	37	1128	2	trotted
tutted	7	51	1744	2	_tutted
wotted	10	41	1571	2	_wotted

Search took 6 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.406	440125.6
2	DLD Change Limit	107671	80	5.156	20882.7
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	5.592	31954.8