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

Here are the results of your fuzzy-string dictionary search for “grubstaked” with Change Limit: [1] [2] [3] [4] [5]

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.

48 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
grubstaked	18	5	109	(None)
grubstake	16	5	162	1	grubstake_
grubstaker	17	5	154	1	grubstaker
grubstakes	17	7	174	1	grubstakes
grubstakers	18	5	147	2	grubstakers
grubstaking	19	5	132	3	grubstaking
cristated	12	4	742	4	cr_istated
crusaded	12	4	423	4	cru_s_aded
crustacea	13	4	266	4	cru_stacea
crusted	10	37	1275	4	cru_st__ed
eructated	12	4	564	4	eru_ctated
frustrated	14	4	410	4	fru_strated
gestated	10	29	1057	4	g__estated
gravitated	15	4	413	4	gravitated
grubbed	13	40	643	4	grub___bed
grunted	9	33	928	4	gru_nt__ed
gruntled	10	27	494	4	gru_nt_led
grutched	15	28	467	4	gru__tched
guested	9	15	771	4	g_uest__ed
gusted	8	43	1672	4	g_u_st__ed
guttated	10	26	687	4	g_u_ttated
outstared	10	18	842	4	_outstared
outstated	10	16	981	4	_outstated
outstayed	13	18	593	4	_outstayed
prebaked	17	3	717	4	preb__aked
presoaked	16	3	565	4	pr_esoaked
resoaked	13	3	794	4	_r_esoaked
restacked	16	3	648	4	_r_estacked
restaged	10	30	1186	4	_r_estaged
restated	9	31	2018	4	_r_estated
restoked	13	57	1053	4	_r_estoked
rusted	7	50	2092	4	_ru_st__ed
rustled	8	33	1132	4	_ru_st_led
staked	11	46	2194	4	____staked
substage	11	11	718	4	_substage_
substages	12	12	735	4	_substages
substate	10	17	1109	4	_substate_
substates	11	14	1033	4	_substates
trusted	8	34	1279	4	tru_st__ed
trusteed	9	34	653	4	tru_st_eed
unslaked	13	3	846	4	__unslaked
unsoaked	13	3	885	4	__unsoaked
unstacked	16	3	643	4	__unstacked
unstalked	14	3	552	4	__unstalked
unstated	9	16	1581	4	__unstated
unstayed	12	16	839	4	__unstayed
upstaged	12	13	524	4	__upstaged
upstared	11	15	657	4	__upstared

Search took 10 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	161450	0.440	406115.9
2	DLD Change Limit	161450	48	9.310	17341.6
3	Display Results	48	48	0.033	1454.5
	(SQL Overall)	178691	48	9.783	18265.5