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

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

89 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
shipmasters	18	5	286	(None)
shipmaster	17	4	296	1	shipmaster_
shinplasters	17	5	186	2	shinplasters
shipmates	16	4	595	2	shipma_te_s
choirmasters	19	5	226	3	choirmasters
hipsters	13	26	879	3	_hip__sters
quizmasters	31	6	167	3	quizmasters
shinplaster	16	5	193	3	shinplaster_
shipfitters	19	6	117	3	shipfitters
shipmate	15	4	615	3	shipma_te__
spymasters	17	4	280	3	s_pymasters
animaters	11	12	997	4	ani_ma_ters
bandmasters	16	8	418	4	bandmasters
bimesters	13	3	634	4	_bi_mesters
bushmasters	18	5	258	4	bushmasters
choirmaster	18	5	213	4	choirmaster_
diasters	9	29	1318	4	_di__asters
disasters	10	3	915	4	_di_sasters
dockmasters	20	5	310	4	dockmasters
drillmasters	15	5	129	4	drillmasters
hamsters	13	7	1042	4	_h_am_sters
headmasters	17	17	430	4	headmasters
hipster	12	28	878	4	_hip__ster_
impacters	15	30	548	4	__impacters
imparters	13	27	657	4	__imparters
impastes	12	23	819	4	__impaste_s
imposters	13	34	734	4	__imposters
ironmasters	13	16	326	4	ironmasters
loadmasters	14	5	331	4	loadmasters
masters	9	46	2892	4	____masters
outmasters	12	4	573	4	_outmasters
overmasters	16	4	482	4	overmasters
pasters	9	45	3173	4	___p_asters
paymasters	17	4	384	4	_paymasters
piasters	10	29	1281	4	___piasters
pilasters	11	3	822	4	_pi_lasters
pinasters	11	3	682	4	_pi_nasters
plasters	10	35	1813	4	___plasters
postmasters	15	11	532	4	postmasters
quipsters	20	4	359	4	quip__sters
quizmaster	30	6	165	4	quizmaster_
remasters	11	3	1058	4	__remasters
replasters	12	4	553	4	_replasters
rhymesters	18	4	260	4	rh_ymesters
rimesters	11	3	748	4	_ri_mesters
ringmasters	14	13	280	4	ringmasters
sailmakers	16	4	378	4	sailma_kers
scamsters	13	3	499	4	s_cam_sters
schoolmasters	20	6	197	4	schoolmasters
scimiters	13	4	512	4	sci_m_iters
scoutmasters	16	5	251	4	scoutmasters
seamsters	11	3	633	4	s_eam_sters
semesters	11	3	912	4	s__emesters
shatters	11	33	1391	4	sh___atters
shifters	14	31	986	4	shi___fters
shimmers	15	26	941	4	shi_m__mers
shipfitter	18	6	131	4	shipfitter_
shipments	16	25	470	4	shipment__s
shipowners	18	4	212	4	ship_owners
shippers	15	30	1231	4	ship___pers
shirtmakers	20	5	220	4	shirtma_kers
shoemakers	19	4	349	4	shoema_kers
shoplifters	19	5	176	4	shoplifters
shysters	14	10	646	4	sh___ysters
sisters	7	37	2159	4	s_i___sters
skirmishers	20	5	123	4	skirmishers
slicksters	16	4	338	4	sli_cksters
slipcases	13	6	425	4	slipcas_e_s
smashers	13	33	959	4	s___mashers
smatters	10	40	1171	4	s___matters
spatters	10	39	1470	4	s__p_atters
spinsters	11	3	661	4	s__pinsters
splashers	14	4	528	4	s__plashers
splatters	11	32	754	4	s__platters
spymaster	16	4	258	4	s_pymaster_
stepsisters	13	5	213	4	stepsisters
stigmasterol	15	6	80	4	stigmasterol
stigmasterols	16	6	63	4	stigmasterols
supplanters	15	11	304	4	supplanters
surpassers	12	4	308	4	surp_assers
taskmasters	17	5	263	4	taskmasters
thirsters	12	3	523	4	thi__rsters
tipsters	10	27	851	4	_tip__sters
trimesters	12	4	541	4	tri_mesters
webmasters	17	4	291	4	_webmasters
wharfmasters	23	5	170	4	wharfmasters
whiplashes	21	5	206	4	whiplashe_s
whoremasters	20	5	271	4	whoremasters
yardmasters	17	5	273	4	yardmasters

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.406	440125.6
2	DLD Change Limit	148819	89	8.860	16796.7
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	9.312	19189.3