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

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

78 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
recaned	10	28	1720	(None)
recane	8	30	2287	1	recane_
recanes	9	32	2226	1	recanes
recanted	11	25	1351	1	recanted
beaned	9	56	2147	2	be_aned
caned	8	58	3809	2	__caned
deaned	8	46	2045	2	de_aned
decane	9	38	1887	2	decane_
decanes	10	31	1891	2	decanes
decanted	12	23	1049	2	decanted
decayed	14	30	933	2	decayed
jeaned	14	38	1346	2	je_aned
leaned	7	34	2254	2	le_aned
reached	13	46	1908	2	reached
reacted	10	30	1571	2	reacted
reamed	9	43	2612	2	re_amed
reaped	9	41	2245	2	re_aped
reared	7	59	3001	2	re_ared
reaved	10	45	2392	2	re_aved
rebated	10	36	1970	2	rebated
recalled	11	3	1080	2	recalled
recant	8	32	2868	2	recan_t
recanter	10	19	1315	2	recanter
recants	9	32	1709	2	recants
recapped	15	3	594	2	recapped
receded	11	27	1304	2	receded
rechanged	16	4	685	2	rechanged
recited	10	43	1910	2	recited
recked	13	48	2180	2	rec_ked
reckoned	15	4	695	2	reckoned
recleaned	12	3	658	2	recleaned
reclined	11	36	1360	2	reclined
recoaled	11	31	1178	2	recoaled
recoated	11	34	1678	2	recoated
recoded	11	31	1503	2	recoded
recoined	11	36	1442	2	recoined
reconned	11	36	1065	2	reconned
recrated	11	29	1860	2	recrated
recused	10	47	1442	2	recused
redated	9	31	2092	2	redated
reearned	9	4	888	2	reearned
refaced	13	37	1357	2	refaced
refined	11	47	2000	2	refined
regained	10	21	1124	2	regained
regaled	9	36	1596	2	regaled
rehanged	13	5	783	2	rehanged
reigned	9	4	921	2	reigned
reined	7	44	2552	2	re_ined
relaced	10	35	1721	2	relaced
reland	7	59	2043	2	relan_d
relanded	10	24	1046	2	relanded
related	8	33	2757	2	related
relaxed	15	33	1253	2	relaxed
relayed	11	32	1275	2	relayed
relined	8	53	2193	2	relined
reloaned	9	3	972	2	reloaned
remained	11	24	1289	2	remained
remand	9	56	1896	2	reman_d
remanded	12	30	1132	2	remanded
remanned	11	31	935	2	remanned
remated	10	35	2247	2	remated
renamed	10	31	1452	2	renamed
repand	9	53	1606	2	repan_d
repanel	9	3	996	2	repanel
repaved	13	33	1113	2	repaved
repined	10	49	1877	2	repined
resawed	11	31	1118	2	resawed
rescaled	11	33	1130	2	rescaled
resined	8	45	2265	2	resined
retained	9	30	1609	2	retained
retaped	10	38	1428	2	retaped
retaxed	15	35	1223	2	retaxed
retuned	8	66	1397	2	retuned
rewaked	15	38	1190	2	rewaked
rewaxed	18	40	934	2	rewaxed
rezoned	17	36	1116	2	rezoned
weaned	10	38	1615	2	we_aned
yeaned	10	38	1390	2	ye_aned

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	78	3.330	32333.6
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.733	47867.9