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

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

78 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
streamlined	14	5	225	(None)
streamline	12	4	421	1	streamline_
streamliner	13	5	217	1	streamliner
streamlines	13	4	364	1	streamlines
streamliners	14	5	162	2	streamliners
strained	9	4	1225	3	str_a__ined
streambed	14	8	333	3	stream__bed
streamed	11	25	890	3	stream___ed
streamier	11	5	576	3	stream_i_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
breadline	12	4	627	4	_breadline_
breadlines	13	4	573	4	_breadlines
deadlined	12	12	532	4	__deadlined
dreamland	13	4	207	4	_dreamlan_d
dreamlike	16	4	275	4	_dreamlike_
headlined	14	13	513	4	__headlined
realigned	11	4	533	4	__rea_ligned
realised	9	22	1453	4	__rea_lised
realized	18	25	1422	4	__rea_lized
reclined	11	36	1360	4	__re_clined
redlined	10	38	1123	4	__re_dlined
relined	8	53	2193	4	__re__lined
remained	11	24	1289	4	__re_mained
screamed	13	27	760	4	scream___ed
screaming	14	21	783	4	scream_in_g
seamlike	14	12	718	4	s__eamlike_
serialised	11	8	828	4	seria_lised
serialized	20	8	1069	4	seria_lized
sidelined	11	12	588	4	side__lined
sprained	11	3	843	4	spr_a__ined
stained	8	42	1534	4	st__a__ined
stamened	11	3	763	4	st__am_ened
steadied	10	3	656	4	st_ea_di_ed
stealing	9	34	1660	4	st_ea_lin_g
stealings	10	31	885	4	st_ea_lings
steamed	10	37	1214	4	st_eam___ed
steamered	12	4	491	4	st_eam_ered
steamier	10	4	830	4	st_eam_i_er
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
stemlike	14	3	672	4	st_e_mlike_
sterilised	11	4	544	4	st_erilised
sterilized	20	4	676	4	st_erilized
strainer	8	5	1222	4	str_a__iner
straitened	11	4	378	4	str_aitened
stramonies	12	4	665	4	str_amonies
strandline	11	4	536	4	strandline_
strandlines	12	4	496	4	strandlines
stravaiged	15	5	223	4	str_avaiged
streaked	13	22	845	4	strea___ked
streakier	13	3	484	4	strea_ki_er
streakiness	15	4	382	4	strea_kiness
streaking	14	20	1032	4	strea_kin_g
streakings	15	23	530	4	strea_kings
streambeds	15	4	163	4	stream__beds
streamer	10	23	951	4	stream___er
streamiest	12	4	512	4	stream_iest
streamlets	12	4	307	4	streaml_ets
streeled	9	26	787	4	stre_el__ed
streeling	10	18	948	4	stre_elin_g
trained	8	41	1720	4	_tr_a__ined
trapline	10	4	1186	4	_tr_apline_
traplines	11	3	1037	4	_tr_aplines
treaclier	11	4	415	4	_treacli_er
treadled	10	6	712	4	_treadl__ed
treadling	11	3	750	4	_treadlin_g
trellised	10	4	465	4	_tre_llised
trephined	15	4	490	4	_tre_phined
unrealized	20	4	721	4	unrea_lized

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.436	409841.7
2	DLD Change Limit	148819	78	8.533	17440.4
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	8.999	19856.8