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

Here are the results of your fuzzy-string dictionary search for “ashier” 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
ashier	9	47	1483	(None)
achier	11	39	1426	1	achier
ashler	9	45	997	1	ashler
cashier	12	37	1332	1	cashier
dashier	11	43	1118	1	dashier
shier	8	54	2894	1	_shier
washier	13	36	1115	1	washier
aerier	6	48	2315	2	aerier
airier	6	46	1936	2	airier
artier	6	34	1973	2	artier
ashed	9	78	2977	2	ash_ed
ashen	8	78	1867	2	ash_en
ashes	8	62	3061	2	ash_es
ashiest	10	3	1396	2	ashiest
ashing	10	78	2409	2	ashing
ashlar	9	33	819	2	ashlar
ashlers	10	31	958	2	ashlers
ashmen	11	6	817	2	ashmen
ashore	9	4	1461	2	ashore
asker	9	64	1878	2	as_ker
asper	7	55	2043	2	as_per
aspire	8	6	1212	2	aspire
aspirer	9	6	790	2	aspirer
aster	5	54	3489	2	as_ter
astir	5	55	1709	2	asti_r
basher	11	51	2381	2	bash_er
brashier	13	38	993	2	brashier
bushier	12	37	1281	2	bushier
cahier	11	36	1577	2	cahier
cashiers	13	31	888	2	cashiers
cushier	12	36	1083	2	cushier
dasher	10	43	1898	2	dash_er
dishier	11	36	1340	2	dishier
easier	6	42	1846	2	eas_ier
fishier	13	35	985	2	fishier
flashier	14	3	710	2	flashier
gasher	10	43	2037	2	gash_er
gassier	8	38	1257	2	gassier
gushier	11	31	1007	2	gushier
hastier	10	39	1662	2	hastier
kasher	13	49	1503	2	kash_er
lasher	9	48	2453	2	lash_er
lathier	10	3	1083	2	lathier
marshier	13	3	759	2	marshier
masher	11	41	2320	2	mash_er
mashie	11	3	1593	2	mashie_
mashies	12	3	1825	2	mashies
massier	9	36	1522	2	massier
meshier	12	34	1085	2	meshier
mushier	12	38	1359	2	mushier
nastier	7	41	1529	2	nastier
osier	5	35	1801	2	os_ier
pastier	9	43	2038	2	pastier
plashier	13	3	761	2	plashier
pushier	12	36	1109	2	pushier
rasher	9	50	2412	2	rash_er
raspier	9	31	1064	2	raspier
rushier	10	34	1197	2	rushier
sagier	7	37	1716	2	sagier
sassier	7	34	1323	2	sassier
sheer	8	47	2689	2	_sheer
shied	9	61	2549	2	_shied
shiel	8	110	2377	2	_shiel
shiers	9	49	2175	2	_shiers
shies	8	61	3655	2	_shies
shiner	9	38	2087	2	_shiner
shire	8	47	2713	2	_shire
shirr	8	47	1692	2	_shirr
shiver	12	45	1737	2	_shiver
shoer	8	47	2216	2	_shoer
shyer	11	47	1478	2	_shyer
skier	9	51	1959	2	_skier
slier	5	48	2724	2	_slier
spier	7	57	2803	2	_spier
tastier	7	118	1709	2	tastier
trashier	11	32	1010	2	trashier
usher	8	45	1776	2	ush_er
vastier	10	36	1320	2	vastier
washer	12	47	2039	2	wash_er
waspier	12	25	905	2	waspier

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.360	496363.9
2	DLD Change Limit	82551	80	2.263	36478.6
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	2.656	67278.2