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

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

77 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
blotted	10	39	1183	(None)
blatted	10	48	1271	1	blatted
bloated	10	45	1343	1	bloated
blotter	9	46	1285	1	blotter
clotted	10	40	1182	1	clotted
lotted	7	42	2240	1	_lotted
plotted	10	46	1237	1	plotted
slotted	8	46	1388	1	slotted
allotted	9	8	687	2	allotted
batted	9	56	2365	2	b_atted
bedotted	12	3	498	2	bedotted
besotted	11	3	584	2	besotted
betted	9	47	2116	2	b_etted
bitted	9	44	1848	2	b_itted
blasted	10	42	1347	2	blasted
blatter	9	44	1565	2	blatter
bleated	10	40	1597	2	bleated
blitzed	19	33	653	2	blitzed
bloater	9	40	1342	2	bloater
blobbed	11	36	656	2	blobbed
blocked	16	44	998	2	blocked
blooded	11	37	980	2	blooded
bloomed	12	43	943	2	bloomed
blooped	12	39	854	2	blooped
blotched	16	3	565	2	blotched
blotters	10	41	1098	2	blotters
blottier	10	33	641	2	blottier
blotto	8	19	844	2	blott_o
blotty	11	17	834	2	blott_y
bloused	10	43	1064	2	bloused
blowed	12	50	1669	2	blo_wed
blowsed	13	44	902	2	blowsed
blowzed	22	43	597	2	blowzed
blunted	10	42	1066	2	blunted
blurted	10	39	978	2	blurted
boated	9	42	2197	2	b_oated
bolted	9	46	1780	2	b_olted
boosted	10	41	1198	2	boosted
booted	9	48	2273	2	b_ooted
bottled	10	46	1123	2	b_ottled
butted	9	47	2206	2	b_utted
clothed	13	40	1028	2	clothed
clouted	10	42	1216	2	clouted
dotted	8	47	1752	2	_dotted
flatted	11	40	1294	2	flatted
flitted	11	40	1164	2	flitted
floated	11	33	1270	2	floated
flouted	11	32	1081	2	flouted
gloated	9	35	1153	2	gloated
glouted	9	42	971	2	glouted
glutted	9	3	724	2	glutted
hotted	10	43	1994	2	_hotted
jotted	14	36	1517	2	_jotted
knotted	12	35	723	2	knotted
letted	7	41	1854	2	_letted
lofted	10	38	1189	2	_lofted
looted	7	44	2111	2	_looted
lotte	5	49	2385	2	_lotte_
lotter	6	40	2560	2	_lotter
lottes	6	53	2275	2	_lottes
louted	7	49	2069	2	_louted
platted	10	36	1426	2	platted
plotter	9	41	1366	2	plotter
plotzed	19	37	622	2	plotzed
potted	9	46	2401	2	_potted
rotted	7	45	2443	2	_rotted
shotted	11	39	1240	2	shotted
slatted	8	40	1518	2	slatted
slitted	8	35	1331	2	slitted
slotter	7	33	1445	2	slotter
sotted	7	41	2140	2	_sotted
spotted	10	37	1314	2	spotted
stotted	8	35	1142	2	stotted
swotted	11	39	871	2	swotted
totted	7	43	1995	2	_totted
trotted	8	37	1128	2	trotted
wotted	10	41	1571	2	_wotted

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	77	3.190	33752.7
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	3.593	49733.1