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

Here are the results of your fuzzy-string dictionary search for “waitresses” 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
waitresses	13	4	506	(None)
waitressed	14	4	292	1	waitressed
actresses	11	3	793	2	_actresses
editresses	11	6	507	2	editresses
mattresses	12	4	543	2	mattresses
traitresses	11	4	460	2	traitresses
waitress	11	3	522	2	waitre_s_s
wardresses	14	4	541	2	wardresses
witnesses	12	21	992	2	w_itnesses
addresses	11	6	563	3	_addresses
aggresses	11	4	614	3	_aggresses
ancresses	11	3	841	3	_ancresses
aptnesses	11	16	899	3	_aptnesses
arbitresses	13	4	334	3	arbitresses
aviatresses	14	8	300	3	aviatresses
buttresses	12	4	566	3	buttresses
caresses	10	3	1406	3	ca__resses
cateresses	12	4	835	3	cateresses
daftnesses	14	3	638	3	daftnesses
digresses	11	3	786	3	_digresses
distresses	11	4	885	3	distresses
faintnesses	14	4	714	3	faintnesses
fairnesses	13	5	738	3	fairnesses
fastnesses	13	8	908	3	fastnesses
fatnesses	12	17	1046	3	fa_tnesses
fitnesses	12	21	937	3	_fitnesses
fortresses	13	4	566	3	fortresses
gastnesses	11	12	914	3	gastnesses
heiresses	12	3	696	3	hei_resses
huntresses	13	4	528	3	huntresses
jointresses	18	4	347	3	jointresses
matinesses	12	3	1454	3	matinesses
matrasses	11	5	729	3	ma_trasses
mattrasses	12	4	383	3	mattrasses
mayoresses	15	4	369	3	mayoresses
mistresses	12	4	799	3	mistresses
oratresses	10	4	549	3	oratresses
pantdresses	14	4	375	3	pantdresses
pastnesses	12	9	1051	3	pastnesses
patnesses	11	16	1179	3	pa_tnesses
portresses	12	4	731	3	portresses
prioresses	12	4	570	3	prioresses
raptnesses	12	4	852	3	raptnesses
restresses	10	4	931	3	restresses
saltnesses	10	3	1016	3	saltnesses
stresses	8	11	1249	3	__stresses
swartnesses	14	3	671	3	swartnesses
tacitnesses	13	3	632	3	tacitnesses
tartnesses	10	11	1071	3	tartnesses
tautnesses	10	11	828	3	tautnesses
tigresses	10	4	640	3	_tigresses
traitoresses	12	5	264	3	traitoresses
tresses	7	37	1954	3	___tresses
unstresses	10	4	603	3	unstresses
vainnesses	13	3	734	3	vainnesses
vastnesses	13	12	820	3	vastnesses
victresses	15	4	497	3	victresses
vitesses	11	3	633	3	_vit_esses
votresses	12	3	650	3	_votresses
waenesses	12	3	977	3	wa_enesses
waitressing	15	5	249	3	waitressing
wannesses	12	3	923	3	wa_nnesses
warinesses	13	15	1452	3	warinesses
warmnesses	15	16	735	3	warmnesses
wavinesses	16	19	928	3	wavinesses
waxinesses	20	13	876	3	waxinesses
wetnesses	12	20	821	3	w_etnesses
whatnesses	16	3	573	3	whatnesses
whitenesses	17	4	665	3	whitenesses
witnessed	13	21	472	3	w_itnessed
witnesser	12	22	453	3	w_itnesser
witnessers	13	17	310	3	w_itnessers

Search took 7 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	140603	0.153	1167915.0
2	DLD Change Limit	140603	72	6.393	21993.3
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	6.592	27107.3