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

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

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
ashlaring	13	4	449	(None)
ashlering	13	4	415	1	ashlering
sharing	11	37	2324	2	_sh_aring
shearing	12	39	1590	2	_shearing
abhorring	15	4	354	3	abhorring
ablating	11	3	1200	3	a_blating
acylating	15	4	757	3	acylating
adhering	13	3	888	3	adh_ering
adulating	11	7	872	3	adulating
alarming	11	3	858	3	a__larming
allaying	12	33	931	3	a_llaying
alluring	9	3	907	3	a_lluring
anearing	9	4	1397	3	a_nearing
appearing	14	3	689	3	appearing
ashing	10	78	2409	3	ash___ing
ashlar	9	33	819	3	ashlar___
ashlared	12	5	393	3	ashlar_ed
ashlars	10	29	706	3	ashlar__s
asphalting	16	4	338	3	asphalting
aspiring	11	3	887	3	as_piring
assaying	12	3	600	3	as_saying
assuaging	11	4	412	3	assuaging
assuring	9	3	777	3	as_suring
asswaging	14	4	310	3	asswaging
blaring	10	43	1711	3	__blaring
cashiering	16	4	378	3	cashiering
cellaring	12	3	853	3	cellaring
charing	13	37	2132	3	_ch_aring
collaring	12	3	1056	3	collaring
declaring	13	3	957	3	declaring
flaring	11	41	1680	3	__flaring
glaring	9	37	1488	3	__glaring
haring	10	42	3300	3	__h_aring
hearing	11	33	2416	3	__hearing
isolating	10	3	974	3	isolating
kashering	17	3	625	3	kash_ering
mishearing	16	4	788	3	mishearing
pillaring	12	3	765	3	pillaring
pshawing	17	3	352	3	psh_awing
rehearing	13	22	1176	3	rehearing
saggaring	12	23	624	3	saggaring
salarying	13	3	607	3	_salarying
sashaying	16	4	459	3	sash_aying
scaring	10	34	2197	3	_s_caring
searing	8	33	3092	3	_s_earing
shading	12	31	1556	3	_sh_ading
shaking	15	33	1725	3	_sh_aking
shaming	13	30	1674	3	_sh_aming
shaping	13	31	1618	3	_sh_aping
sharking	16	39	1297	3	_sh_arking
sharping	14	30	1137	3	_sh_arping
shaving	14	34	1433	3	_sh_aving
shawing	14	35	1488	3	_sh_awing
sheafing	15	32	948	3	_sheafing
shealing	12	34	1546	3	_shealing
shearings	13	33	756	3	_shearings
shearling	13	3	692	3	_shearling
sheaving	15	41	1025	3	_sheaving
sheering	12	37	1510	3	_sheering
shirring	12	29	1044	3	_shirring
shoaling	12	31	1175	3	_shoaling
shoring	11	28	2007	3	_sh_oring
showring	15	4	832	3	_showring
slaking	12	37	1747	3	_s_laking
slating	8	37	2465	3	_s_lating
slaving	11	35	1483	3	_s_laving
slaying	11	33	1684	3	_s_laying
smearing	11	35	1175	3	_smearing
snaring	8	39	2095	3	_s_naring
soaring	8	35	2189	3	_s_oaring
solacing	11	3	1013	3	_solacing
solating	9	3	1559	3	_solating
sparing	10	48	2387	3	_s_paring
spearing	11	32	1610	3	_spearing
splaying	14	21	930	3	_splaying
squaring	18	15	863	3	_squaring
staring	8	45	2705	3	_s_taring
sugaring	10	3	905	3	_sugaring
swearing	12	37	1144	3	_swearing
ushering	12	5	892	3	ush_ering

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	148641	0.420	425454.8
2	DLD Change Limit	148641	80	6.313	23545.2
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	6.766	26410.1