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

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

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
speaned	10	34	1152	(None)
speared	10	43	1442	1	speared
beaned	9	56	2147	2	_beaned
cleaned	10	35	1200	2	cleaned
deaned	8	46	2045	2	_deaned
gleaned	9	34	942	2	gleaned
jeaned	14	38	1346	2	_jeaned
leaned	7	34	2254	2	_leaned
opened	9	43	1186	2	ope_ned
paned	8	54	3718	2	_p_aned
peaced	11	58	1891	2	_peaced
peaked	13	61	1740	2	_peaked
pealed	9	53	2281	2	_pealed
peened	9	43	1816	2	_peened
peined	9	49	1884	2	_peined
penned	9	42	1761	2	_penned
planed	9	44	2091	2	_planed
saned	6	56	3627	2	s__aned
seabed	9	50	1769	2	s_eabed
sealed	7	43	2836	2	s_ealed
seamed	9	48	2388	2	s_eamed
seared	7	52	3284	2	s_eared
seated	7	51	3105	2	s_eated
seined	7	40	2306	2	s_eined
sepaled	10	5	1059	2	sepaled
sheafed	14	38	897	2	sheafed
sheared	11	45	1600	2	sheared
sheaved	14	34	1163	2	sheaved
sheened	11	35	1170	2	sheened
skeane	10	46	1137	2	skeane_
skeanes	11	36	1071	2	skeanes
skeined	12	3	677	2	skeined
sleaved	11	36	1113	2	sleaved
smeared	10	45	1062	2	smeared
sneaked	12	32	969	2	sneaked
sneaped	10	33	881	2	sneaped
spaced	11	45	1725	2	sp_aced
spaded	10	38	1675	2	sp_aded
spaed	8	55	2227	2	sp_a_ed
spanked	14	31	1173	2	sp_anked
spanned	10	41	1122	2	spanned
spared	9	54	2749	2	sp_ared
spawned	13	31	680	2	spawned
spayed	12	42	1361	2	sp_ayed
speaker	13	33	1121	2	speaker
spean	7	46	2051	2	spean__
speans	8	54	1714	2	spean_s
spearer	9	39	1366	2	spearer
specced	14	26	670	2	specced
specked	16	32	901	2	specked
speed	8	55	2662	2	spe__ed
speeded	11	33	1042	2	speeded
speeled	10	37	1245	2	speeled
speered	10	36	1481	2	speered
speiled	10	44	1212	2	speiled
speired	10	38	1110	2	speired
spelled	10	37	1473	2	spelled
spend	8	56	1933	2	spe_n_d
spewed	12	55	1233	2	spe_wed
spined	9	54	2394	2	sp_ined
splayed	13	35	781	2	splayed
splined	10	50	1311	2	splined
spooned	10	34	1244	2	spooned
sprained	11	3	843	2	sprained
sprayed	13	39	890	2	sprayed
spurned	10	33	926	2	spurned
staned	7	48	2464	2	s_taned
steaded	9	28	1167	2	steaded
steamed	10	37	1214	2	steamed
sweated	11	34	1154	2	sweated
weaned	10	38	1615	2	_weaned
yeaned	10	38	1390	2	_yeaned

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	72	3.030	35535.0
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	3.436	52005.5