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

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

55 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
achillea	13	4	410	(None)
achilleas	14	4	326	1	achilleas
chilled	13	33	1093	2	_chilled
chiller	12	41	1218	2	_chiller
rachilla	13	4	571	2	rachill_a
rachillae	14	4	366	2	rachillae
schiller	13	29	647	2	schiller
achier	11	39	1426	3	achi__er
achieve	15	4	502	3	achieve_
achieved	17	4	371	3	achieved
achiever	16	4	384	3	achiever
achieves	16	4	552	3	achieves
achiote	12	3	921	3	achiote_
achiotes	13	3	900	3	achiotes
acholia	12	3	997	3	ach_olia
ancilla	9	4	860	3	ancill_a
ancillae	10	4	765	3	ancillae
anvilled	12	3	648	3	anvilled
armilla	9	3	699	3	armill_a
armillae	10	4	556	3	armillae
awhile	12	5	779	3	awhi_le_
axilla	13	28	957	3	a_xill_a
axillae	14	24	823	3	a_xillae
cavilled	14	3	672	3	cavilled
caviller	13	3	705	3	caviller
challa	11	40	1419	3	_chall_a
chicle	13	43	1254	3	_chicle_
chicles	14	35	1250	3	_chicles
childe	12	47	1121	3	_childe_
childes	13	42	1127	3	_childes
chile	10	56	2689	3	_chi_le_
chiles	11	54	2530	3	_chi_les
chilies	12	42	1830	3	_chilies
chill	10	56	1987	3	_chill__
chillers	13	37	1091	3	_chillers
chillest	13	25	959	3	_chillest
chilli	11	43	1277	3	_chill_i
chillier	13	32	842	3	_chillier
chillies	13	41	1347	3	_chillies
chillis	12	44	1160	3	_chillis
chills	11	47	1770	3	_chill_s
chillum	14	3	544	3	_chillum
chilly	14	41	1322	3	_chill_y
chimla	13	3	759	3	_chiml_a
chimley	17	8	516	3	_chimley
cholla	11	39	1102	3	_choll_a
echelle	12	4	662	3	echelle_
echelles	13	4	666	3	echelles
hilled	10	40	2222	3	__hilled
hiller	9	44	2163	3	__hiller
hilloa	9	47	1303	3	__hilloa
schillers	14	28	565	3	schillers
scilla	8	3	1094	3	sc_ill_a
shilled	11	33	1362	3	_shilled
unchilled	15	4	556	3	unchilled

Search took 9 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.173	1032896.0
2	DLD Change Limit	146162	55	8.546	17103.0
3	Display Results	55	55	0.030	1833.3
	(SQL Overall)	178691	55	8.749	20424.2