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

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

76 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
yardmasters	17	5	273	(None)
yardmaster	16	5	271	1	yardmaster_
bandmasters	16	8	418	2	bandmasters
bandmaster	15	12	441	3	bandmaster_
cadasters	12	3	683	3	ca_d_asters
headmasters	17	17	430	3	headmasters
loadmasters	14	5	331	3	loadmasters
paymasters	17	4	384	3	pa_ymasters
remasters	11	3	1058	3	__remasters
taskmasters	17	5	263	3	taskmasters
wharfmasters	23	5	170	3	wharfmasters
adapters	11	3	610	4	_a_d_apters
adjusters	17	4	416	4	_a_djusters
admasses	11	3	541	4	_a_dmasse_s
admitters	12	4	455	4	_a_dmitters
alabasters	12	4	325	4	_alabasters
amassers	10	33	784	4	_a__massers
animaters	11	12	997	4	_anima_ters
arresters	9	4	820	4	_ar_resters
ballasters	12	4	509	4	ba_llasters
bandmates	14	4	792	4	bandma_te_s
bardolaters	14	5	270	4	bardolaters
barometers	14	19	852	4	barom_eters
barraters	11	3	804	4	bar_ra_ters
barristers	12	4	473	4	bar_risters
burgomasters	17	5	145	4	burgomasters
bushmasters	18	5	258	4	bushmasters
cadaster	11	3	690	4	ca_d_aster_
cadastres	12	4	455	4	ca_d_astres
cardcases	14	4	651	4	cardcas_e_s
carmakers	17	3	692	4	car_ma_kers
diasters	9	29	1318	4	___diasters
dockmasters	20	5	310	4	dockmasters
forecasters	16	7	501	4	forecasters
formatters	15	4	457	4	for_matters
gamesters	12	3	674	4	ga__mesters
hamsters	13	7	1042	4	ha__m_sters
harassers	12	4	620	4	har__assers
harbormasters	20	6	130	4	harbormasters
hardasses	13	4	645	4	hard_asse_s
harvesters	16	4	415	4	har_vesters
headmaster	16	20	464	4	headmaster_
ironmasters	13	16	326	4	ironmasters
lamisters	11	5	712	4	la__misters
lamsters	10	9	975	4	la__m_sters
landmasses	13	4	321	4	landmasse_s
loadmaster	13	4	323	4	loadmaster_
masters	9	46	2892	4	____masters
narraters	9	4	670	4	nar_ra_ters
outmasters	12	4	574	4	_outmasters
overmasters	16	4	482	4	overmasters
palmisters	14	4	467	4	pa_lmisters
parameters	14	4	813	4	param_eters
paymaster	16	4	387	4	pa_ymaster_
postmasters	15	11	533	4	postmasters
quizmasters	31	6	167	4	quizmasters
radwastes	13	6	412	4	ra_dwaste_s
rasters	7	46	2902	4	__r__asters
remaster	10	3	1147	4	__remaster_
rimesters	11	3	749	4	__rimesters
ringmasters	14	13	280	4	ringmasters
roasters	8	36	1593	4	__r_oasters
sandblasters	15	5	215	4	sandblasters
shipmasters	18	5	286	4	shipmasters
spymasters	17	4	280	4	_spymasters
taskmaster	16	5	246	4	taskmaster_
toastmasters	14	5	226	4	toastmasters
trimesters	12	4	542	4	_trimesters
warmakers	18	4	563	4	war_ma_kers
warranters	13	4	454	4	war_ranters
webmasters	17	4	291	4	_webmasters
wharfmaster	22	5	160	4	wharfmaster_
whoremasters	20	5	271	4	whoremasters
yardages	13	3	620	4	yard_a_ge_s
yarders	11	32	1159	4	yard____ers
yawmeters	17	8	387	4	ya_wm_eters

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.423	422437.4
2	DLD Change Limit	148819	76	9.220	16140.9
3	Display Results	76	76	0.046	1652.2
	(SQL Overall)	178691	76	9.689	18442.7