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

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

66 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
distaffs	15	6	508	(None)
distaff	14	6	768	1	distaff_
distains	9	4	1360	2	distains
distaves	12	3	1140	2	distaves
dustoffs	15	4	316	2	dustoffs
restaffs	14	4	478	2	restaffs
staffs	12	34	975	2	__staffs
tipstaffs	17	5	178	2	tipstaffs
castoffs	16	4	404	3	castoffs
daffs	12	51	1642	3	d___affs
dastards	10	27	808	3	dastards
destains	9	3	1181	3	destains
diastases	10	4	707	3	diastases
dictates	11	3	1138	3	dictates
dieoffs	14	4	303	3	di_eoffs
diffs	12	63	1548	3	di___ffs
diktats	12	3	562	3	dikta_ts
disarms	10	3	904	3	dis_arms
disbands	12	3	735	3	disbands
disbars	10	3	1032	3	disba_rs
discants	11	29	1202	3	discants
discards	12	3	891	3	discards
discases	11	20	1450	3	discases
disdains	10	3	791	3	disdains
diseases	9	24	1581	3	diseases
dismals	10	20	1024	3	disma_ls
dismasts	11	3	751	3	dismasts
dismays	13	23	743	3	disma_ys
disparts	11	10	995	3	disparts
disrates	9	11	1815	3	disrates
dissaves	12	3	941	3	dissaves
distain	8	3	1378	3	dista_in
distal	7	36	1577	3	dista__l
distally	12	3	955	3	distally
distance	11	3	1185	3	distance
distances	12	3	1165	3	distances
distant	8	35	1995	3	dista_nt
distaste	9	3	994	3	distaste
distastes	10	3	963	3	distastes
distends	10	33	982	3	distends
distichs	14	4	763	3	distichs
distills	9	31	904	3	distills
distils	8	30	1580	3	dist_ils
distomes	11	3	1416	3	distomes
distorts	9	11	1235	3	distorts
distracts	12	4	928	3	distracts
distrains	10	4	1133	3	distrains
distress	9	3	1171	3	distress
disturbs	11	4	540	3	disturbs
ditas	6	59	2367	3	di_ta__s
draffs	13	61	790	3	d__raffs
dustoff	14	4	505	3	dustoff_
dyestuffs	19	5	132	3	dyestuffs
liftoffs	13	4	206	3	liftoffs
mastiffs	16	4	423	3	mastiffs
mistakes	14	12	1341	3	mistakes
pikestaffs	22	5	117	3	pikestaffs
pilaffs	15	36	515	3	pi_laffs
restaff	13	3	901	3	restaff_
restuffs	14	4	419	3	restuffs
staff	11	38	1771	3	__staff_
stiffs	12	38	996	3	__stiffs
stuffs	12	38	1022	3	__stuffs
tipstaff	16	4	300	3	tipstaff_
vistas	9	45	1327	3	vista__s
waitstaffs	19	5	124	3	waitstaffs

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	66	6.703	21805.5
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	6.889	25938.6