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

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

86 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
outsparkled	18	9	159	(None)
outsparkle	16	9	185	1	outsparkle_
outsparkles	17	9	148	1	outsparkles
outbarked	16	3	667	3	out_bark_ed
outsailed	10	3	779	3	outs_a_iled
outsmarted	13	4	432	3	outsmar_ted
outsoared	10	15	759	3	outsoar__ed
outspanned	13	4	345	3	outspa_nned
outsparkling	19	5	165	3	outsparkling
outspelled	13	4	432	3	outsp_elled
outstared	10	18	842	3	outstar__ed
outstarted	11	5	507	3	outstar_ted
sparkled	15	31	773	3	___sparkled
asparkle	14	4	384	4	__asparkle_
outargued	11	4	440	4	out__argued
outasked	13	3	712	4	out__ask_ed
outbaked	15	3	839	4	out_ba_k_ed
outbawled	15	5	495	4	out_ba_wled
outbrawled	16	4	349	4	outbra_wled
outcaviled	16	4	324	4	out_caviled
outcharged	17	4	421	4	outchar_ged
outcharmed	18	4	370	4	outchar_med
outcrawled	16	4	354	4	outcra_wled
outdared	10	27	1151	4	out_dar__ed
outdazzled	20	4	182	4	out_dazzled
outearned	10	5	668	4	out_ear_ned
outfabled	15	9	509	4	out_fa_bled
outflanked	18	4	288	4	outflank_ed
outgambled	16	9	233	4	out_gambled
outglared	11	4	592	4	outglar__ed
outhandled	15	7	363	4	out_handled
outlearned	11	4	362	4	outlear_ned
outmarched	18	4	358	4	out_marched
outpaced	13	26	979	4	out_pa__ced
outpainted	13	4	432	4	out_painted
outpassed	12	4	580	4	out_pa_ssed
outpeopled	15	4	328	4	out_peopled
outpolled	12	4	617	4	out_p_olled
outprayed	15	4	575	4	out_p_rayed
outpriced	14	4	642	4	out_p_riced
outpulled	12	4	525	4	out_p_ulled
outpursued	13	4	245	4	out_pursued
outranked	14	24	786	4	out_rank_ed
outroared	10	15	811	4	outroar__ed
outsavored	14	5	266	4	outs_avored
outscored	12	20	707	4	outscor__ed
outscorned	13	4	358	4	outscor_ned
outserved	13	13	646	4	outs_er_ved
outshamed	15	4	531	4	outsha__med
outskated	14	17	683	4	outska__ted
outslicked	17	4	320	4	outslick_ed
outsmelled	13	4	364	4	outs_melled
outsmiled	12	4	567	4	outs__miled
outsmoked	16	4	477	4	outs_mok_ed
outsnored	10	17	598	4	outsnor__ed
outsourced	13	4	287	4	outsour_ced
outsped	10	11	1032	4	outsp____ed
outspeed	11	11	793	4	outsp___eed
outspeeded	14	4	338	4	outsp_eeded
outspoke	14	4	649	4	outsp_ok_e_
outspoken	15	4	437	4	outsp_ok_en
outspread	12	4	350	4	outsp_r_ead
outsprinted	14	4	238	4	outsprinted
outstare	8	14	1069	4	outstar__e_
outstares	9	16	1018	4	outstar__es
outstated	10	16	981	4	outsta__ted
outstayed	13	18	593	4	outsta__yed
outsulked	14	12	475	4	outs_ulk_ed
outsware	11	16	884	4	outswar__e_
outtalked	14	4	551	4	out_talk_ed
outtasked	14	4	537	4	out_task_ed
outthanked	18	4	291	4	outthank_ed
outtraveled	15	5	201	4	outtraveled
outwalked	17	4	529	4	out_walk_ed
outwarred	13	4	547	4	out_war_red
outwearied	14	4	408	4	outwear_ied
outwhirled	17	4	237	4	outwhir_led
outworked	17	4	557	4	out_work_ed
spackled	17	29	780	4	___spackled
sparked	14	35	1314	4	___spark_ed
sparkle	13	37	1021	4	___sparkle_
sparkler	14	31	798	4	___sparkler
sparkles	14	32	1049	4	___sparkles
sparklet	14	31	1059	4	___sparklet
unshackled	20	4	224	4	_unshackled
unsnarled	10	3	574	4	_unsnar_led

Search took 10 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.423	422437.4
2	DLD Change Limit	148819	86	9.390	15848.7
3	Display Results	86	86	0.046	1869.6
	(SQL Overall)	178691	86	9.859	18124.7