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

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

51 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
achier	11	39	1426	(None)
ashier	9	47	1483	1	ashier
cahier	11	36	1577	1	cahier
ache	9	68	2982	2	ach_e_
ached	11	92	2783	2	ach_ed
aches	10	61	3229	2	ach_es
achiest	12	3	1518	2	achiest
achieve	15	4	502	2	achieve
achiever	16	4	384	2	achiever
aching	12	65	2197	2	aching
acrider	10	3	862	2	acrider
acuter	8	44	1286	2	acuter
aerier	6	48	2315	2	aerier
airier	6	46	1936	2	airier
archer	11	50	1624	2	arch_er
artier	6	34	1973	2	artier
ashler	9	45	997	2	ashler
beachier	15	3	880	2	beachier
cagier	9	37	1593	2	cagier
cahiers	12	35	1067	2	cahiers
cakier	12	31	1524	2	cakier
cashier	12	37	1332	2	cashier
catchier	15	32	986	2	catchier
cheer	10	54	2038	2	_cheer
chicer	13	45	1360	2	_chicer
chider	12	51	1605	2	_chider
chief	13	44	1948	2	_chief
chiel	10	49	1897	2	_chiel
chimer	13	55	1720	2	_chimer
chirr	10	50	1590	2	_chirr
crier	7	47	2446	2	_crier
dashier	11	43	1118	2	dashier
echoer	11	40	1110	2	echoer
icier	7	43	1375	2	ic_ier
ickier	12	43	992	2	ickier
itchier	12	24	767	2	itchier
lacier	8	40	2009	2	lac_ier
lathier	10	3	1083	2	lathier
leachier	13	3	725	2	leachier
ocher	10	45	1610	2	och_er
pacier	10	50	1868	2	pac_ier
patchier	15	31	966	2	patchier
peachier	15	4	862	2	peachier
poachier	15	5	682	2	poachier
racier	8	51	2097	2	rac_ier
shier	8	54	2894	2	_shier
tackier	13	37	1252	2	tackier
techier	12	6	924	2	techier
wackier	16	36	973	2	wackier
washier	13	36	1115	2	washier
yachter	15	3	491	2	yachter

Search took 4 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.376	475242.0
2	DLD Change Limit	82551	51	2.733	30205.3
3	Display Results	51	51	0.016	3187.5
	(SQL Overall)	178691	51	3.125	57181.1