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

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

81 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
streamliner	13	5	217	(None)
streamline	12	4	421	1	streamline_
streamlined	14	5	225	1	streamlined
streamliners	14	5	162	1	streamliners
streamlines	13	4	364	1	streamlines
streamier	11	5	576	2	stream_i_er
steamier	10	4	830	3	st_eam_i_er
strainer	8	5	1222	3	str_a__iner
streakier	13	3	484	3	strea_ki_er
streamer	10	23	951	3	stream___er
streaming	12	23	965	3	stream_in_g
streamings	13	18	516	3	stream_ings
streamlet	11	4	604	3	streaml__et
streamlining	15	5	187	3	streamlining
streamside	13	5	210	3	streamside_
streamsides	14	5	197	3	streamsides
tramline	10	3	1138	3	_tr_amline_
tramlines	11	3	984	3	_tr_amlines
treaclier	11	4	415	3	_treacli_er
breadline	12	4	627	4	_breadline_
breadlines	13	4	573	4	_breadlines
creamier	12	31	906	4	_cream_i_er
dreamier	11	28	729	4	_dream_i_er
dreamlike	16	4	275	4	_dreamlike_
headliner	13	13	539	4	__headliner
realiser	8	25	1256	4	__rea_liser
realizer	17	24	1211	4	__rea_lizer
recliner	10	32	1191	4	__re_cliner
redliner	9	35	1047	4	__re_dliner
scrawlier	14	4	390	4	scr_awli_er
screamer	12	26	788	4	scream___er
screaming	14	21	783	4	scream_in_g
seamier	9	31	1463	4	s__eam_i_er
seamlike	14	12	718	4	s__eamlike_
seemlier	10	3	519	4	s__eemli_er
sideliner	10	12	601	4	side__liner
sprawlier	14	4	329	4	spr_awli_er
stainer	7	36	1492	4	st__a__iner
steadier	9	3	731	4	st_ea_di_er
stealer	7	29	1397	4	st_ea_l__er
stealing	9	34	1660	4	st_ea_lin_g
stealings	10	31	885	4	st_ea_lings
steamer	9	33	1309	4	st_eam___er
steamfitter	16	5	122	4	st_eamfitter
steaminess	12	3	677	4	st_eam_iness
steaming	11	40	1321	4	st_eam_in_g
stearine	8	3	1190	4	st_ea_rine_
stearines	9	3	1128	4	st_ea_rines
steelier	8	3	918	4	st_e_eli_er
stemlike	14	3	672	4	st_e_mlike_
stemmier	12	4	525	4	st_e_mmi_er
sterilizer	19	4	551	4	st_erilizer
stragglier	12	4	350	4	straggli_er
strained	9	4	1225	4	str_a__ined
strainers	9	5	1038	4	str_a__iners
straiter	8	3	1178	4	str_a__iter
stramonies	12	4	665	4	str_amonies
strandline	11	4	536	4	strandline_
strandlines	12	4	496	4	strandlines
strappier	13	4	513	4	str_appi_er
strawier	11	3	749	4	str_a_wi_er
streaker	12	22	948	4	strea___ker
streakiness	15	4	382	4	strea_kiness
streaking	14	20	1032	4	strea_kin_g
streakings	15	23	530	4	strea_kings
streambed	14	8	333	4	stream__bed
streamed	11	25	890	4	stream___ed
streamers	11	22	807	4	stream___ers
streamiest	12	4	511	4	stream_iest
streamlets	12	4	307	4	streaml_ets
streeling	10	18	948	4	stre_elin_g
stretchier	15	4	448	4	stretchi_er
superliner	12	4	920	4	supe_rliner
trainer	7	33	1679	4	_tr_a__iner
trampier	12	31	824	4	_tr_ampi_er
trampoliner	15	5	231	4	_tr_ampoliner
trapline	10	4	1186	4	_tr_apline_
traplines	11	3	1037	4	_tr_aplines
treadler	9	3	686	4	_treadl__er
treadling	11	3	750	4	_treadlin_g
tremblier	13	4	328	4	_trembli_er

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.420	425454.8
2	DLD Change Limit	148819	81	9.080	16389.8
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	9.530	18750.4