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

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

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.

72 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
mealtime	12	4	512	(None)
mealtimes	13	4	524	1	mealtimes
meantime	12	4	598	1	meantime
mealie	8	25	1981	2	meal_i_e
meantimes	13	4	588	2	meantimes
teatime	9	3	1008	2	tea_time
analcime	12	4	539	3	analcime
beastie	9	24	1243	3	beasti_e
bedtime	12	3	697	3	be_dtime
beslime	11	4	683	3	besl_ime
betime	10	59	1483	3	be__time
centime	11	45	1303	3	ce_ntime
daytime	13	4	478	3	_daytime
delime	9	3	1404	3	de_l_ime
dreamtime	14	4	234	3	dreamtime
elative	10	3	1245	3	_elative
fealties	11	3	999	3	fealties
gelatine	9	32	1330	3	gelatine
halftime	16	4	331	3	_halftime
lealties	8	3	1079	3	lealties
malaise	9	3	1267	3	m_alaise
malice	10	48	1848	3	m_al_ice
maline	8	45	2908	3	m_al_ine
maltase	9	3	890	3	m_altase
maltier	9	30	1548	3	m_altier
malting	10	32	1908	3	m_alting
maltose	9	3	978	3	m_altose
maritime	12	4	738	3	maritime
mealier	9	30	1590	3	meal_ier
mealies	9	28	2193	3	meal_ies
meanie	8	37	1839	3	mea_ni_e
meatier	9	32	1461	3	mea_tier
meatily	12	3	1109	3	mea_tily
meatmen	11	3	824	3	mea_t_men
melamine	12	3	1030	3	melamine
melanite	10	5	1202	3	melanite
melanize	19	4	1030	3	melanize
melastome	13	4	460	3	melastome
meltage	10	3	795	3	me_ltage
melting	10	33	1775	3	me_lting
metalise	10	4	1605	3	metal_ise
metalize	19	4	1478	3	metal_ize
metallike	15	5	589	3	metallike
metalline	11	5	873	3	metalline
metallize	20	6	715	3	metallize
millime	11	25	1140	3	m_illime
mistime	11	3	1261	3	m_istime
moatlike	14	4	699	3	moatlike
pastime	11	46	1197	3	_pastime
peacetime	15	4	447	3	peacetime
pealike	13	12	1127	3	peal_ike
playtime	15	4	479	3	playtime
ragtime	10	3	616	3	_ragtime
reactive	13	3	1047	3	reactive
realise	7	30	2181	3	real_ise
realize	16	27	1708	3	real_ize
realties	8	5	1485	3	realties
relative	11	3	1314	3	relative
retime	8	53	2180	3	re__time
saltie	6	34	2243	3	_salti_e
saltine	7	50	1856	3	_saltine
saltire	7	31	1303	3	_saltire
seallike	12	10	832	3	seallike
seedtime	11	4	418	3	seedtime
septime	11	3	880	3	se_ptime
smalltime	13	4	219	3	smalltime
smaltine	10	3	783	3	smaltine
smaltite	10	4	690	3	smaltite
tealike	11	11	1108	3	teal_ike
teatimes	10	3	944	3	tea_times
termtime	12	4	477	3	termtime
wartime	12	3	774	3	_wartime

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	146162	0.436	409841.7
2	DLD Change Limit	146162	72	7.063	20694.0
3	Display Results	72	72	0.016	4500.0
	(SQL Overall)	178691	72	7.515	23777.9