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

Here are the results of your fuzzy-string dictionary search for “potshots” with Change Limit: [1] [2] [3] [4]

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.

67 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
potshots	13	4	628	(None)
hotshots	14	5	551	1	hotshots
potshot	12	4	973	1	potshot_
bowshots	16	4	510	2	bowshots
hotshot	13	5	834	2	hotshot_
hotspots	13	4	484	2	hotspots
pothos	11	42	1469	2	pot_ho_s
airshots	11	4	594	3	airshots
borshts	12	6	654	3	borsh_ts
bowshot	15	7	825	3	bowshot_
dropshots	15	4	339	3	dropshots
earshots	11	4	662	3	earshots
eyeshots	14	5	337	3	eyeshots
gunshots	12	4	437	3	gunshots
hotchpots	19	4	290	3	hotchpots
hotfoots	14	4	432	3	hotfoots
hotspot	12	4	746	3	hotspot_
moonshots	14	4	428	3	moonshots
motmots	11	6	613	3	mot_mots
outshoots	12	4	539	3	outshoots
outshot	10	3	1210	3	outshot_
outshouts	12	4	521	3	outshouts
pathos	11	55	1669	3	pat_ho_s
patriots	10	3	805	3	patriots
phots	10	54	1850	3	p___hots
pitchouts	16	4	367	3	pitchouts
podsols	10	5	651	3	pods_ols
poisons	9	3	1035	3	pois_ons
polycots	15	4	776	3	polycots
ponchos	14	34	1070	3	poncho_s
poshest	12	3	1242	3	po_shest
posits	8	57	1871	3	po_s_its
possets	9	42	1277	3	po_ssets
postboys	15	8	527	3	postboys
postdocs	13	4	527	3	postdocs
postheats	14	4	743	3	postheats
posthole	13	3	953	3	posthole
postholes	14	4	1045	3	postholes
postops	11	3	1171	3	po_stops
posts	7	52	2878	3	po_s__ts
postshow	16	4	304	3	postsho_w
potashes	13	3	783	3	potash_es
potatoes	10	3	994	3	potatoes
potboys	14	7	527	3	pot_boys
pothers	12	38	1862	3	pot_hers
pothole	12	3	1217	3	pot_hole
potholes	13	3	1293	3	pot_holes
pothook	16	5	688	3	pot_hook
pothooks	17	4	605	3	pothooks
pothouse	13	4	870	3	pot_house
potions	9	34	1742	3	pot_ions
potshard	14	4	453	3	potshard
potshards	15	4	405	3	potshards
potsherd	14	3	481	3	potsherd
potsherds	15	4	403	3	potsherds
potsies	9	30	1948	3	pots_ies
potstone	10	3	942	3	potstone
potstones	11	4	921	3	potstones
pottos	8	46	1587	3	pot_to_s
preshows	16	26	702	3	preshows
pythons	15	3	736	3	pyt_hons
rimshots	13	4	388	3	rimshots
shots	8	47	3085	3	___shots
toeshoes	11	4	771	3	toeshoes
tosspots	10	4	456	3	tosspots
toyshops	16	4	443	3	toyshops
upshots	12	3	519	3	_upshots

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	67	7.280	20077.2
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	7.733	23107.6