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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

105 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
wyled	12	46	1184	(None)
waled	9	43	3099	1	waled
wiled	9	52	3155	1	wiled
wyle	10	55	1938	1	wyle_
wyles	11	46	1532	1	wyles
wyted	12	52	947	1	wyted
abled	8	69	2683	2	abled
ailed	6	62	4028	2	ailed
axled	13	53	1581	2	axled
baled	8	54	3644	2	baled
bled	7	57	2931	2	_bled
byrled	12	43	717	2	byrled
coled	8	55	4075	2	coled
cycled	14	3	654	2	cycled
deled	7	53	2654	2	deled
doled	7	54	3091	2	doled
dyed	9	67	2076	2	dy_ed
dyked	14	53	1095	2	dyked
eyed	8	66	2323	2	ey_ed
filed	9	53	3190	2	filed
fled	8	54	2977	2	_fled
gled	6	56	3114	2	_gled
gybed	12	58	1102	2	gybed
gyred	10	51	1409	2	gyred
gyved	13	56	874	2	gyved
haled	9	53	3582	2	haled
holed	9	56	3413	2	holed
hyped	14	53	1333	2	hyped
idled	7	49	1521	2	idled
isled	6	46	1599	2	isled
led	4	62	5455	2	__led
lysed	9	50	1156	2	lysed
muled	8	58	2443	2	muled
naled	6	55	2505	2	naled
ogled	7	59	1596	2	ogled
oiled	6	44	2947	2	oiled
paled	8	55	3872	2	paled
piled	8	52	3299	2	piled
pled	7	52	3143	2	_pled
poled	8	49	3484	2	poled
puled	8	49	2652	2	puled
riled	6	58	3325	2	riled
ruled	6	58	2252	2	ruled
ryked	13	66	951	2	ryked
sled	5	53	3437	2	_sled
soled	6	58	3517	2	soled
styled	10	56	1310	2	styled
tiled	6	48	3294	2	tiled
toled	6	59	3492	2	toled
tyned	9	59	1501	2	tyned
typed	11	58	1545	2	typed
tyred	9	58	1643	2	tyred
unled	6	40	2107	2	unled
voled	9	53	2372	2	voled
waded	10	60	2475	2	waded
waged	10	48	2278	2	waged
wailed	10	48	2359	2	wailed
waked	13	56	2675	2	waked
wale	7	45	4643	2	wale_
waler	8	42	2926	2	waler
wales	8	61	4283	2	wales
walked	14	53	1378	2	walked
walled	10	40	2129	2	walled
waned	9	58	3178	2	waned
wared	9	63	3987	2	wared
wauled	10	47	1396	2	wauled
waved	12	52	2358	2	waved
wawled	13	38	1170	2	wawled
waxed	16	60	1848	2	waxed
wed	7	58	4362	2	w__ed
weed	8	56	3751	2	w_eed
weld	8	47	2773	2	wel_d
welded	11	40	1338	2	welded
welled	10	38	2021	2	welled
welted	10	37	1582	2	welted
whaled	13	46	1203	2	whaled
whiled	13	45	1413	2	whiled
wield	9	52	1391	2	wield
wifed	12	51	1774	2	wifed
wild	8	51	2651	2	wil_d
wilded	11	37	1450	2	wilded
wile	7	59	4437	2	wile_
wiles	8	54	3787	2	wiles
willed	10	47	2245	2	willed
wilted	10	39	1571	2	wilted
wined	9	44	3418	2	wined
wiped	11	47	2208	2	wiped
wired	9	53	2764	2	wired
wised	9	51	2334	2	wised
wited	9	47	2714	2	wited
wived	12	51	2150	2	wived
wold	8	54	2907	2	wol_d
wolfed	13	42	801	2	wolfed
wooed	9	44	1987	2	wooed
wooled	10	37	1550	2	wooled
wowed	12	40	2377	2	wowed
wried	9	55	1856	2	wried
wye	9	63	3197	2	wy_e_
wyes	10	57	2750	2	wy_es
wynd	11	61	1446	2	wy_nd
wyte	10	60	1864	2	wyte_
wytes	11	41	1343	2	wytes
xylem	17	3	612	2	xylem
yeld	8	114	2387	2	_yeld
ylem	9	2	1789	2	_ylem

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.096	1861364.6
2	DLD Change Limit	53800	105	1.826	29463.3
3	Display Results	105	105	0.033	3181.8
	(SQL Overall)	178691	105	1.955	91402.0