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

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

57 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
streamliners	14	5	162	(None)
streamliner	13	5	217	1	streamliner_
streamlines	13	4	364	1	streamline_s
streamline	12	4	421	2	streamline__
streamlined	14	5	225	2	streamline_d
steaminess	12	3	677	3	st_eam_iness
strainers	9	5	1040	3	str_a__iners
streakiness	15	4	382	3	strea_kiness
streamers	11	22	808	3	stream___ers
streamier	11	5	576	3	stream_i_er_
streamings	13	18	516	3	stream_in_gs
streamlets	12	4	307	3	streaml__ets
streamlining	15	5	187	3	streamlining
streamsides	14	5	197	3	streamside_s
tramlines	11	3	984	3	_tr_amline_s
breadlines	13	4	573	4	_breadline_s
creaminess	14	4	620	4	_cream_iness
dreaminess	13	4	531	4	_dream_iness
headliners	14	14	433	4	__headliners
realisers	9	24	832	4	__rea_lisers
realizers	18	23	793	4	__rea_lizers
recliners	11	27	911	4	__re_cliners
redliners	10	26	785	4	__re_dliners
screamers	13	23	626	4	scream___ers
seaminess	11	3	1047	4	s__eam_iness
seemliness	12	4	415	4	s__eemliness
sideliners	11	12	513	4	side__liners
stainers	8	32	1217	4	st__a__iners
steadiers	10	3	508	4	st_ea_di_ers
steadiness	11	4	670	4	st_ea_diness
stealers	8	34	1221	4	st_ea_l__ers
stealings	10	31	885	4	st_ea_lin_gs
steamers	10	34	1087	4	st_eam___ers
steamfitters	17	5	103	4	st_eamfitters
steamier	10	4	830	4	st_eam_i_er_
stearines	9	3	1128	4	st_ea_rine_s
steeliness	10	4	679	4	st_e_eliness
sterilizers	20	4	362	4	st_erilizers
strainer	8	5	1222	4	str_a__iner_
stramonies	12	4	665	4	str_amonie_s
strandlines	12	4	497	4	strandline_s
streakers	13	21	814	4	strea___kers
streakier	13	3	484	4	strea_ki_er_
streakings	15	23	530	4	strea_kin_gs
streambeds	15	4	163	4	stream__beds
streamer	10	23	951	4	stream___er_
streamiest	12	4	512	4	stream_i_est
streaming	12	23	965	4	stream_in__g
streamlet	11	4	604	4	streaml__e_t
streamside	13	5	210	4	streamside__
superliners	13	4	738	4	supe_rliners
trainers	8	31	1465	4	_tr_a__iners
tramline	10	3	1138	4	_tr_amline__
trampoliners	16	5	144	4	_tr_ampoliners
traplines	11	3	1037	4	_tr_apline_s
treaclier	11	4	415	4	_treacli_er_
treadlers	10	4	589	4	_treadl__ers

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	124790	0.390	458182.1
2	DLD Change Limit	124790	57	7.470	16705.5
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	7.890	22647.8