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

Here are the results of your fuzzy-string dictionary search for “phased” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

101 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
phased	12	40	1197	(None)
chased	12	50	1929	1	chased
phase	10	46	1721	1	phase_
phases	11	46	1840	1	phases
phrased	13	8	738	1	phrased
physed	15	38	679	1	physed
abased	9	65	1499	2	abased
based	8	53	3158	2	_based
biased	9	40	1222	2	biased
cased	8	60	3241	2	_cased
ceased	9	49	2078	2	ceased
chafed	15	48	1391	2	chafed
chared	12	54	2369	2	chared
chase	10	51	2712	2	chase_
chaser	11	49	1838	2	chaser
chases	11	51	2823	2	chases
chasmed	15	47	1017	2	chasmed
chassed	13	47	1213	2	chassed
chawed	15	52	1460	2	chawed
eased	6	54	3040	2	_eased
erased	7	48	1675	2	erased
feased	10	57	1871	2	feased
haded	10	52	2762	2	_haded
haed	8	63	3858	2	_ha_ed
haled	9	53	3582	2	_haled
hared	9	57	4218	2	_hared
hashed	13	60	2194	2	_hashed
hasped	12	50	1444	2	_hasped
hasted	10	51	2528	2	_hasted
hated	9	57	3402	2	_hated
hawed	12	60	2542	2	_hawed
hayed	12	58	2201	2	_hayed
hazed	18	52	2220	2	_hazed
hosed	9	58	3098	2	_hosed
lased	6	51	3234	2	_lased
leased	7	47	2288	2	leased
paced	10	69	3168	2	p_aced
paged	9	59	2678	2	p_aged
paled	8	55	3872	2	p_aled
paned	8	54	3718	2	p_aned
pared	8	69	4676	2	p_ared
parsed	9	63	2389	2	parsed
pase	6	53	4686	2	p_ase_
paseo	7	70	2251	2	p_aseo
pases	7	53	4650	2	p_ases
pashed	12	59	2314	2	p_ashed
passed	9	43	2094	2	passed
pasted	9	44	2690	2	p_asted
pated	8	52	3784	2	p_ated
paused	9	51	1496	2	paused
paved	11	55	2526	2	p_aved
pawed	11	57	2561	2	p_awed
payed	11	59	2593	2	p_ayed
peaced	11	58	1891	2	peaced
peaked	13	61	1740	2	peaked
pealed	9	53	2280	2	pealed
pease	7	52	3111	2	pease_
peasen	8	48	1596	2	peasen
peases	8	52	2947	2	peases
peised	9	48	1768	2	peised
phage	11	51	1367	2	phage_
phages	12	52	1351	2	phages
phaseal	12	4	567	2	phaseal
phasic	13	36	1205	2	phasic
phasis	11	46	1492	2	phasis
phasmid	15	26	760	2	phasmid
phoned	12	40	1455	2	phoned
phrase	11	10	990	2	phrase_
phrases	12	7	1146	2	phrases
physeds	16	34	403	2	physeds
physes	14	39	978	2	physes
pissed	9	48	1693	2	pissed
placed	11	43	1800	2	placed
planed	9	44	2091	2	planed
plashed	13	37	1264	2	plashed
plated	9	52	2577	2	plated
played	12	48	1503	2	played
pleased	10	37	1207	2	pleased
poised	9	49	1847	2	poised
posed	8	58	2841	2	p_osed
praised	10	42	1481	2	praised
prase	7	61	2875	2	prase_
prases	8	44	2902	2	prases
prated	9	49	2492	2	prated
prayed	12	48	1543	2	prayed
prised	9	43	2220	2	prised
prosed	9	49	2109	2	prosed
pshawed	16	10	303	2	pshawed
pulsed	9	40	1372	2	pulsed
pursed	9	52	2088	2	pursed
rased	6	50	3393	2	_rased
shaded	11	45	1887	2	shaded
shaled	10	50	2395	2	shaled
shamed	12	51	2021	2	shamed
shaped	12	50	2010	2	shaped
shared	10	58	2906	2	shared
shaved	13	51	1838	2	shaved
shawed	13	48	1723	2	shawed
teased	7	47	2115	2	teased
thawed	13	45	846	2	thawed
whaled	13	46	1203	2	whaled

Search took 3 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	82551	0.123	1452772.4
2	DLD Change Limit	82551	101	2.673	30883.3
3	Display Results	101	101	0.030	3366.7
	(SQL Overall)	178691	101	2.826	63231.1