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

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

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.

69 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
outsparkles	17	9	148	(None)
outsparkle	16	9	185	1	outsparkle_
outsparkled	18	9	159	1	outsparkled
outsparkling	19	5	165	3	outsparkling
outstares	9	16	1018	3	outstar__es
sparkles	14	32	1049	3	___sparkles
asparkle	14	4	384	4	__asparkle_
autarkies	13	4	477	4	aut__arkies
outargues	10	4	487	4	out__argues
outbakes	14	3	999	4	out_ba_k_es
outbarked	16	3	667	4	out_bark_ed
outbarks	14	3	783	4	out_bark__s
outcharges	16	4	483	4	outchar_ges
outdares	9	27	1246	4	out_dar__es
outdazzles	19	5	171	4	out_dazzles
outfables	14	8	556	4	out_fa_bles
outgambles	15	8	236	4	out_gambles
outglares	10	4	700	4	outglar__es
outhandles	14	7	365	4	out_handles
outmarches	17	4	412	4	out_marches
outpaces	12	24	1194	4	out_pa__ces
outpasses	11	4	661	4	out_pa_sses
outpeoples	14	4	313	4	out_peoples
outprices	13	3	762	4	out_p_rices
outpursues	12	4	263	4	out_pursues
outsailed	10	3	779	4	outs_a_iled
outsails	8	13	986	4	outs_a_il_s
outscores	11	17	846	4	outscor__es
outserves	12	14	737	4	outs_er_ves
outshames	14	4	592	4	outsha__mes
outskates	13	17	715	4	outska__tes
outsmarted	13	4	432	4	outsmar_ted
outsmarts	11	15	514	4	outsmar__ts
outsmiles	11	4	644	4	outs__miles
outsmokes	15	4	531	4	outs_mok_es
outsnores	9	17	677	4	outsnor__es
outsoared	10	15	759	4	outsoar__ed
outsoars	8	3	885	4	outsoar___s
outsoles	8	8	1311	4	outs___oles
outsources	12	4	291	4	outsour_ces
outspanned	13	4	345	4	outspa_nned
outspans	10	3	822	4	outspa___ns
outspeaks	15	5	401	4	outspeak__s
outspelled	13	4	432	4	outsp_elled
outspells	11	10	460	4	outsp__ells
outspoke	14	4	649	4	outsp_ok_e_
outspoken	15	4	437	4	outsp_ok_en
outspreads	13	4	275	4	outsp_reads
outsprings	13	4	395	4	outsp_rings
outsprints	12	4	357	4	outsp_rints
outstare	8	14	1069	4	outstar__e_
outstared	10	18	842	4	outstar__ed
outstarted	11	5	507	4	outstar_ted
outstarts	9	17	632	4	outstar__ts
outstates	9	17	1075	4	outsta__tes
outstrides	11	5	475	4	outs_trides
outstrives	13	7	425	4	outs_trives
outstrokes	14	6	459	4	outs_trokes
outsware	11	16	884	4	outswar__e_
outtakes	12	3	1003	4	out_ta_k_es
outwearies	13	4	535	4	outwear_ies
spackles	16	31	995	4	___spackles
sparkle	13	37	1021	4	___sparkle_
sparkled	15	31	773	4	___sparkled
sparkler	14	31	798	4	___sparkler
sparklers	15	31	564	4	___sparklers
sparklet	14	31	1059	4	___sparklet
sparklets	15	27	584	4	___sparklets
unshackles	19	4	199	4	_unshackles

Search took 9 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	148819	0.436	409841.7
2	DLD Change Limit	148819	69	8.050	18486.8
3	Display Results	69	69	0.043	1604.7
	(SQL Overall)	178691	69	8.529	20951.0