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

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

46 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
pothos	11	42	1469	(None)
pathos	11	55	1669	1	pathos
pottos	8	46	1587	1	pottos
bathos	11	62	1563	2	bathos
bohos	10	56	1825	2	bo_hos
cohos	10	59	2185	2	co_hos
ethos	8	55	1419	2	_ethos
goths	9	65	1300	2	goth_s
kotos	9	57	1770	2	kot_os
lithos	9	42	1255	2	lithos
lotos	5	47	2463	2	lot_os
lottos	6	46	1310	2	lottos
moths	10	60	2155	2	moth_s
mottos	8	46	1524	2	mottos
mythos	14	39	847	2	mythos
ottos	5	47	1432	2	_ottos
paths	10	55	2138	2	path_s
patios	8	52	2178	2	patios
photos	11	33	1664	2	phot_os
piths	10	58	1754	2	pith_s
polios	8	40	1972	2	polios
polos	7	61	2991	2	po_los
pomos	9	53	2158	2	po_mos
ponchos	14	34	1070	2	ponchos
poohs	10	39	1571	2	pooh_s
poos	6	59	4911	2	po__os
pornos	8	50	1525	2	pornos
potboy	13	9	781	2	potboy
potboys	14	7	527	2	potboys
pother	11	38	1885	2	pother
pothers	12	38	1862	2	pothers
pothole	12	3	1217	2	pothole
potholes	13	3	1293	2	potholes
pothook	16	5	688	2	pothook
pothooks	17	4	605	2	pothooks
pothouse	13	4	870	2	pothouse
potion	8	45	1957	2	potion
potions	9	34	1742	2	potions
pots	6	64	5236	2	pot__s
potshot	12	4	973	2	potshot
potshots	13	4	628	2	potshots
potto	7	53	2094	2	potto_
python	14	4	714	2	python
pythons	15	3	736	2	pythons
rotos	5	60	2788	2	rot_os
soths	8	62	1863	2	soth_s

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	46	2.296	35954.3
3	Display Results	46	46	0.016	2875.0
	(SQL Overall)	178691	46	2.655	67303.6