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

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

80 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
measurers	11	4	488	(None)
measurer	10	3	595	1	measurer_
measures	10	3	891	1	measure_s
censurers	11	25	607	2	censurers
ensurers	8	27	937	2	_ensurers
manurers	10	3	759	2	m_anurers
maturers	10	3	737	2	m_aturers
measure	9	3	903	2	measure__
measured	11	3	646	2	measure_d
treasurers	10	4	320	2	treasurers
admeasures	13	5	243	3	admeasure_s
assurers	8	6	631	3	_assurers
bearers	9	46	1959	3	bea__rers
censurer	10	22	813	3	censurer_
censures	10	22	1162	3	censure_s
desirers	9	3	926	3	de_sirers
devourers	13	4	409	3	devourers
easters	7	51	2568	3	_eas_ters
endurers	9	31	795	3	_endurers
ensurer	7	30	1190	3	_ensurer_
ensures	7	33	1590	3	_ensure_s
erasures	8	3	721	3	erasure_s
fearers	10	48	1527	3	fea__rers
feasters	11	5	1156	3	feas_ters
features	11	3	1033	3	feature_s
gesturers	10	4	428	3	gesturers
hearers	10	43	1978	3	hea__rers
insurers	8	37	1013	3	_insurers
leaguers	9	3	506	3	leagu_ers
leasers	7	47	1784	3	leas__ers
lecturers	11	12	423	3	lecturers
leisures	8	3	668	3	leisure_s
manurer	9	3	858	3	m_anurer_
manures	9	3	1335	3	m_anure_s
marrers	9	34	1431	3	m_a_rrers
masers	8	46	2345	3	m_as__ers
mashers	12	46	2105	3	m_as_hers
maskers	13	39	1384	3	m_as_kers
masquers	19	19	570	3	m_asquers
masters	9	46	2892	3	m_as_ters
maturer	9	3	897	3	m_aturer_
matures	9	3	1430	3	m_ature_s
maulers	9	42	1330	3	m_a_ulers
meanderers	13	4	380	3	meanderers
meanders	11	6	883	3	mea_nders
meaners	9	44	1524	3	mea__ners
measles	9	24	1275	3	meas_le_s
measlier	10	3	601	3	measlier_
measuredly	16	5	217	3	measuredly
measureless	13	7	173	3	measureless
measuring	12	3	612	3	measuring
meatuses	10	3	820	3	meatuse_s
meisters	10	33	1384	3	meis_ters
misusers	10	34	808	3	m_isusers
murmurers	13	4	267	3	murmurers
pasturers	11	3	639	3	_pasturers
peasoupers	14	9	205	3	peasoupers
perjurers	18	22	446	3	perjurers
pleasures	11	4	557	3	pleasure_s
rasures	7	3	1201	3	_rasure_s
rearers	7	43	2356	3	rea__rers
reasoners	9	4	711	3	reasoners
reassures	9	3	722	3	reassure_s
reinsurers	10	4	357	3	reinsurers
remeasures	12	4	385	3	remeasure_s
resumers	10	3	808	3	re_sumers
seafarers	12	4	414	3	seafarers
seasoners	9	4	626	3	seasoners
securers	10	5	715	3	se_curers
seisures	8	3	827	3	seisure_s
smearers	10	30	862	3	smea__rers
tearers	7	52	1823	3	tea__rers
teaselers	9	16	584	3	teaselers
teasers	7	53	1724	3	teas__ers
treasurer	9	4	425	3	treasurer_
treasures	9	4	663	3	treasure_s
usurers	7	6	636	3	__usurers
venturers	12	4	552	3	venturers
wearers	10	46	1590	3	wea__rers
yeasayers	15	4	202	3	yeasayers

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	148641	0.423	422437.4
2	DLD Change Limit	148641	80	7.406	20070.3
3	Display Results	80	80	0.043	1860.5
	(SQL Overall)	178691	80	7.872	22699.6