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

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

99 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
wield	9	52	1391	1	wield
wile	7	59	4437	1	wi_le
abele	7	63	2325	2	abele
aisle	5	52	2319	2	aisle
anele	5	56	2883	2	anele
bible	9	51	1942	2	bible
bield	8	46	1465	2	bield
bile	6	61	4718	2	bi_le
birle	7	50	2363	2	birle
dele	5	68	4308	2	_dele
diel	5	90	3460	2	diel_
diene	6	57	2013	2	diene
field	9	50	1532	2	field
file	7	54	4664	2	fi_le
fille	8	43	2740	2	fille
idle	5	54	2376	2	_idle
isle	4	51	2170	2	_isle
liege	6	53	1443	2	liege
lieve	8	63	1547	2	lieve
lisle	5	39	1672	2	lisle
mile	6	63	5257	2	mi_le
mille	7	50	2913	2	mille
niece	7	48	1450	2	niece
nieve	8	56	1318	2	nieve
pele	6	55	3955	2	_pele
piece	9	67	1799	2	piece
pile	6	56	4969	2	pi_le
riel	4	64	3238	2	riel_
riels	5	51	2133	2	riels
rifle	8	55	1833	2	rifle
rile	4	56	5053	2	ri_le
rille	5	57	2873	2	rille
sidle	6	51	2403	2	sidle
siege	6	67	1844	2	siege
sieve	8	49	1884	2	sieve
stele	5	50	2684	2	stele
swiple	11	37	923	2	swiple
tele	4	50	4087	2	_tele
tile	4	54	5144	2	ti_le
title	5	47	2107	2	title
vile	7	61	3980	2	vi_le
wale	7	45	4643	2	w_ale
wee	6	67	6081	2	w_e_e
weel	7	58	3408	2	weel_
weld	8	47	2773	2	w_eld
well	7	58	3204	2	w_ell
welt	7	55	4786	2	w_elt
were	7	62	3833	2	w_ere
whale	11	55	1743	2	whale
whee	10	54	2959	2	whe_e
wheel	11	55	1533	2	wheel
whelk	15	43	1106	2	whelk
whelm	13	46	1198	2	whelm
whelp	13	60	1209	2	whelp
where	11	70	1942	2	where
while	11	54	1869	2	while
whole	11	44	1809	2	whole
widdle	11	38	1484	2	widdle
wide	8	52	3540	2	wi_de
widely	13	33	1103	2	widely
wielded	12	21	668	2	wielded
wielder	11	19	767	2	wielder
wields	10	46	962	2	wields
wieldy	13	47	618	2	wieldy
wiener	9	45	1354	2	wiener
wienie	9	22	997	2	wienie
wife	10	52	2802	2	wi_fe
wifely	15	42	942	2	wifely
wiggle	11	37	1301	2	wiggle
wiglet	10	55	1915	2	wiglet
wild	8	51	2651	2	wi_ld
wiled	9	52	3155	2	wiled
wiles	8	54	3787	2	wiles
will	7	57	3751	2	wi_ll
willed	10	47	2245	2	willed
willer	9	40	2106	2	willer
willet	9	51	2483	2	willet
willie	9	41	1645	2	willie
wills	8	45	2896	2	wills
willy	11	53	2191	2	willy
wilt	7	62	4629	2	wi_lt
wily	10	64	2881	2	wi_ly
wimble	13	32	1192	2	wimble
wimple	13	36	1136	2	wimple
wince	10	52	2088	2	wince
windle	10	46	1795	2	windle
wine	7	49	5342	2	wi_ne
winkle	13	38	1283	2	winkle
wintle	9	40	1460	2	wintle
winze	17	50	1485	2	winze
wipe	9	48	3028	2	wi_pe
wire	7	58	3981	2	wi_re
wise	7	57	3734	2	wi_se
wisely	12	27	1171	2	wisely
wite	7	54	4327	2	wi_te
withe	11	52	2023	2	withe
wive	10	59	3175	2	wi_ve
wyle	10	55	1938	2	w_yle
yield	9	51	969	2	yield

Search took 2 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	53800	0.110	1624463.6
2	DLD Change Limit	53800	99	1.780	30224.7
3	Display Results	99	99	0.030	3300.0
	(SQL Overall)	178691	99	1.920	93068.2