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

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

72 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
smidgin	11	33	510	(None)
smidgen	11	42	651	1	smidgen
smidgins	12	31	484	1	smidgins
amidin	9	40	1567	2	amid_in
pidgin	10	25	981	2	_pidgin
smidge	10	37	848	2	smidg_e
smidgens	12	32	564	2	smidgens
smidgeon	12	30	327	2	smidgeon
smidges	11	44	819	2	smidges
smudging	13	25	572	2	smudging
amidic	11	40	1287	3	amid_ic
amidine	10	36	1385	3	amid_ine
amidins	10	37	1310	3	amid_ins
amidogen	12	4	391	3	amidogen
avidin	10	35	1084	3	avid_in
biggin	10	37	1060	3	_biggin
bridging	13	28	844	3	bridging
emodin	9	3	1035	3	emod_in
fidging	13	39	1050	3	_fidging
imidic	11	35	820	3	imid_ic
margin	9	40	1685	3	_margin
midair	9	3	799	3	_midair
midden	10	41	1285	3	_midden
midge	9	50	1655	3	_midg_e
midges	10	35	1648	3	_midges
midget	10	37	1845	3	_midget
midgut	10	35	1005	3	_midgut
midi	7	56	2848	3	_mid_i_
midis	8	59	2341	3	_mid_is
midline	10	23	1510	3	_midline
midrib	11	3	824	3	_midrib
mirin	7	50	2315	3	_mi_rin
origin	7	3	1103	3	ori_gin
pidgins	11	25	912	3	_pidgins
piggin	10	31	1109	3	_piggin
ridgil	8	31	682	3	_ridgil
ridging	10	41	1298	3	_ridging
saimin	8	3	1366	3	sai_min
seisin	6	37	1512	3	sei_sin
seizin	15	36	1085	3	sei_zin
siding	8	38	2213	3	s_id_ing
sidling	9	9	1542	3	s_idling
sieging	9	26	1320	3	s_ieging
sigil	6	35	1550	3	s_i_gil
sign	5	55	2305	3	s_i_g_n
simlin	8	3	1173	3	s_imlin
singing	9	32	2142	3	s_inging
siskin	10	7	978	3	s_iskin
skidding	15	3	546	3	skidding
sledging	11	28	818	3	sledging
slidden	9	3	515	3	slidden
sliding	9	31	1455	3	slid_ing
slinging	10	33	1286	3	slinging
sludging	11	26	836	3	sludging
smidgeons	13	27	273	3	smidgeons
smiling	10	39	1544	3	smi_ling
smirking	15	27	723	3	smirking
smiting	10	30	1444	3	smi_ting
smitten	9	3	669	3	smitten
smudge	10	38	791	3	smudg_e
smudged	12	32	646	3	smudged
smudges	11	34	828	3	smudges
smudgier	12	3	375	3	smudgier
smudgily	15	4	312	3	smudgily
smudgy	13	29	413	3	smudg_y
spongin	10	3	637	3	spongin
stinging	10	32	1345	3	stinging
stodging	11	27	746	3	stodging
swidden	12	3	423	3	swidden
swigging	14	33	722	3	swigging
swinging	13	34	1111	3	swinging
virgin	10	3	808	3	_virgin

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	134027	0.390	458182.1
2	DLD Change Limit	134027	72	6.326	21186.7
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	6.749	26476.7