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

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

86 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
earshot	10	4	1082	(None)
earshots	11	4	662	1	earshots
airshot	10	5	949	2	airshot
eyeshot	13	8	654	2	eyeshot
parashot	13	4	1014	2	parashot
airshots	11	4	594	3	airshots
airshow	13	4	462	3	airshow
archon	11	3	1175	3	_archon
argot	6	77	2865	3	_ar_got
arhat	8	3	2709	3	_ar_hat
arshin	9	3	1217	3	_arshin
arson	5	51	1883	3	_ars_on
ascot	7	65	2251	3	_a_scot
barhop	13	31	964	3	bar_hop
birdshot	14	4	419	3	birdshot
borsht	11	8	1350	3	borsh_t
bowshot	15	7	825	3	bowshot
carhop	13	36	1076	3	car_hop
carrot	8	4	2312	3	car_rot
cashoo	11	3	1225	3	ca_shoo
darshan	11	6	706	3	darshan
dashpot	13	4	612	3	da_shpot
eardrop	10	6	522	3	eardrop
earldom	10	4	458	3	earldom
earlship	13	4	510	3	earlship
earnest	7	3	1873	3	earnest
earphone	13	4	825	3	earphone
ears	4	63	5659	3	ears___
earstone	8	4	860	3	earstone
earth	8	50	2305	3	earth__
earthed	11	3	992	3	earthed
earthen	10	3	925	3	earthen
earthly	13	38	738	3	earthly
earthnut	11	5	565	3	earthnut
earths	9	50	1459	3	earth_s
earthset	11	4	1082	3	earthset
earthy	12	39	994	3	earth_y
east	4	66	5910	3	ea_s__t
enroot	6	6	1599	3	enr_oot
erasion	7	3	1196	3	erasion
ergot	6	54	2289	3	e_r_got
erst	4	74	3643	3	e_rs__t
escot	7	53	2008	3	e__scot
eyeshots	14	5	337	3	eyeshots
eyespot	12	6	541	3	eyespot
gearshift	16	5	354	3	gearshift
gunshot	11	5	664	3	gunshot
hardhat	14	4	1102	3	hardhat
haricot	12	3	1196	3	haricot
harlot	9	44	2280	3	har_lot
harsh	11	64	1805	3	harsh__
harshen	13	3	928	3	harshen
harsher	13	3	1036	3	harsher
harshest	14	3	1019	3	harshest
harshly	16	3	627	3	harshly
harslet	10	3	1565	3	harslet
hipshot	15	10	664	3	hipshot
hotshot	13	5	834	3	hotshot
karst	9	72	2899	3	kars__t
manihot	12	11	1205	3	manihot
markhor	16	3	546	3	markhor
marmot	10	3	1874	3	mar_mot
marplot	11	4	967	3	marplot
marsh	10	53	2085	3	marsh__
marshal	12	3	897	3	marshal
marshes	12	36	1537	3	marshes
marshy	14	55	833	3	marsh_y
mascot	10	40	1607	3	ma_scot
nearshore	12	5	346	3	nearshore
outshot	10	3	1210	3	outshot
overshot	14	4	943	3	overshot
parashoth	17	5	397	3	parashoth
parrot	8	3	2066	3	par_rot
parson	8	38	1790	3	pars_on
potshot	12	4	973	3	potshot
reshot	9	35	1963	3	_reshot
rimshot	12	4	621	3	rimshot
sarsnet	7	3	1481	3	sarsnet
shot	7	61	5026	3	___shot
snapshot	13	4	439	3	snapshot
tarot	5	59	4393	3	tar__ot
teashop	12	4	608	3	tea_shop
upshot	11	3	845	3	_upshot
warship	15	4	783	3	warship
warthog	14	4	453	3	warthog
washout	13	4	1013	3	wa_shout

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	134027	0.156	1145455.1
2	DLD Change Limit	134027	86	6.486	20664.0
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	6.672	26782.2