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

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

73 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
shimmying	20	4	253	(None)
shammying	20	4	295	1	shammying
shimming	16	27	825	1	shimm_ing
chammying	22	4	335	2	chammying
jimmying	23	4	238	2	_jimmying
shamming	16	28	941	2	shamm_ing
shamoying	18	4	452	2	shamoying
shimmering	18	8	462	2	shimmering
shinnying	16	19	372	2	shinnying
skimming	17	28	627	2	skimm_ing
slimming	13	28	809	2	slimm_ing
stimying	14	3	750	2	sti_mying
swimming	16	31	632	2	swimm_ing
brimming	15	19	662	3	brimm_ing
chiming	15	33	1183	3	chi_m_ing
chirming	16	31	864	3	chirm_ing
chivvying	24	4	171	3	chivvying
chivying	20	3	497	3	chi_vying
chumming	18	36	620	3	chumm_ing
dimming	13	33	959	3	_dimm_ing
dummying	17	26	372	3	_dummying
hamming	15	30	1409	3	_hamm_ing
hemming	15	26	997	3	_hemm_ing
hinnying	15	12	485	3	_hinnying
humming	15	33	1067	3	_humm_ing
jemmying	23	3	231	3	_jemmying
mummying	15	26	372	3	_mummying
nimming	12	35	814	3	_nimm_ing
primming	15	26	817	3	primm_ing
rimming	12	34	1107	3	_rimm_ing
scamming	15	32	854	3	scamm_ing
scumming	15	25	679	3	scumm_ing
shambling	17	3	559	3	shambling
shaming	13	30	1674	3	sh_am_ing
shielding	14	3	455	3	shielding
shieling	12	35	1240	3	shi_eling
shifting	15	29	1038	3	shi_fting
shilling	12	33	1538	3	shi_lling
shimmied	16	29	498	3	shimm_ied
shimmies	15	28	780	3	shimm_ies
shimmy	16	30	641	3	shimmy___
shingling	14	13	697	3	shingling
shining	11	38	1652	3	shi__ning
shinneying	17	18	267	3	shinneying
shinning	12	32	1102	3	shi_nning
shipping	16	36	1125	3	shi_pping
shirking	16	32	1047	3	shi_rking
shirring	12	29	1044	3	shi_rring
shirting	12	32	1361	3	shi_rting
shitting	12	32	1266	3	shi_tting
shivering	16	3	733	3	shivering
shlumping	17	3	337	3	shlumping
shrimping	17	3	406	3	shrimping
shying	13	42	1184	3	sh___ying
simmering	14	6	782	3	s_immering
skimmings	18	24	326	3	skimm_ings
skimping	17	30	624	3	ski_mping
skivvying	23	9	160	3	skivvying
slamming	13	33	1000	3	slamm_ing
sliming	10	29	1395	3	sli_m_ing
slumming	13	27	838	3	slumm_ing
spamming	15	31	760	3	spamm_ing
spiffying	21	4	275	3	spiffying
stemming	13	40	820	3	stemm_ing
stithying	16	4	370	3	stithying
stumming	13	34	767	3	stumm_ing
stymying	17	3	396	3	s_tymying
summing	12	29	1238	3	s_umm_ing
swimmings	17	26	315	3	swimm_ings
trimming	13	31	865	3	trimm_ing
whamming	19	27	522	3	whamm_ing
whinnying	19	17	273	3	whinnying
whirrying	19	6	273	3	whirrying

Search took 8 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.423	422437.4
2	DLD Change Limit	148641	73	6.593	22545.3
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	7.046	25360.6