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

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

77 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
outlearns	9	4	463	(None)
outearns	8	3	840	1	out_earns
outlearn	8	3	643	1	outlearn_
outlearnt	9	4	596	1	outlearnt
outearn	7	3	1068	2	out_earn_
outhears	11	8	1039	2	outhear_s
outleads	9	27	876	2	outlea_ds
outleaps	10	23	707	2	outlea_ps
outlearned	11	4	362	2	outlearned
outwears	11	9	726	2	outwear_s
unlearns	8	4	445	2	_unlearns
butlers	9	45	1805	3	butle_r_s
cutlers	9	42	1700	3	cutle_r_s
learns	6	55	1374	3	___learns
lutherns	11	3	629	3	luthe_rns
mislearns	11	4	452	3	mislearns
ostlers	7	29	1120	3	ostle_r_s
outbarks	14	3	783	3	out_barks
outbeams	12	3	606	3	outbea_ms
outbleats	11	4	439	3	outblea_ts
outboards	12	4	621	3	outboards
outburns	10	3	606	3	out_burns
outcharms	16	4	392	3	outcharms
outdares	9	27	1246	3	out_dares
outearned	10	5	668	3	out_earned
outeats	7	22	1570	3	out_ea_ts
outers	6	42	3017	3	out_e_r_s
outfawns	14	3	472	3	out_fawns
outfeasts	12	11	433	3	outfeasts
outgains	9	8	1016	3	out_gains
outglares	10	4	700	3	outglares
outgleams	12	4	260	3	outglea_ms
outhear	10	9	1060	3	outhear__
outheard	12	8	854	3	outhear_d
outhearing	14	3	844	3	outhearing
outlain	7	12	1261	3	outl_ain_
outland	8	12	1234	3	outl_a_nd
outlands	9	8	856	3	outl_ands
outlasts	8	10	871	3	outl_asts
outlaws	10	24	960	3	outl_a_ws
outlays	10	26	1090	3	outl_a_ys
outlead	8	33	1110	3	outlea__d
outleading	12	3	713	3	outleading
outleap	9	29	829	3	outlea__p
outleaped	12	4	617	3	outleaped
outleaping	13	4	620	3	outleaping
outleapt	10	31	815	3	outlea_pt
outlearning	12	4	354	3	outlearning
outlets	7	36	1636	3	outle__ts
outliers	8	26	1067	3	outlier_s
outmans	9	24	1328	3	out_ma_ns
outplans	10	25	953	3	outpla_ns
outreads	9	28	900	3	outrea_ds
outreasons	10	5	307	3	outreasons
outroars	8	3	892	3	outroar_s
outscorns	11	14	488	3	outscorns
outserts	8	30	980	3	outse_rts
outsmarts	11	15	514	3	outsmarts
outsoars	8	3	885	3	outsoar_s
outspans	10	3	822	3	outspa_ns
outstares	9	16	1018	3	outstares
outstarts	9	17	632	3	outstarts
outswears	12	4	430	3	outswear_s
outturns	8	3	591	3	out_turns
outwards	12	9	912	3	out_wards
outwars	10	9	1279	3	out_war_s
outwear	10	9	771	3	outwear__
outwearies	13	4	535	3	outwearies
outwearing	14	3	718	3	outwearing
outweary	14	8	539	3	outwear_y
overlearns	13	4	499	3	overlearns
relearns	8	3	630	3	_relearns
southerns	12	34	721	3	southe_rns
sutlers	7	31	1697	3	sutle_r_s
tutelars	8	4	499	3	tutelar_s
unlearn	7	3	595	3	_unlearn_
unlearnt	8	4	640	3	_unlearnt

Search took 8 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	148641	0.423	422437.4
2	DLD Change Limit	148641	77	7.093	20956.0
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	7.549	23670.8