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

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

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
delighted	15	4	620	(None)
delighter	14	4	558	1	delighter
relighted	14	3	686	1	relighted
alighted	13	4	767	2	_alighted
bedighted	17	4	458	2	bedighted
benighted	16	4	474	2	benighted
blighted	15	4	686	2	_blighted
daylighted	19	5	219	2	daylighted
delegated	12	3	837	2	delegated
delight	12	6	1067	2	delight__
delightedly	20	6	221	2	delightedly
delighters	15	4	436	2	delighters
delights	13	4	733	2	delight_s
delimited	13	4	659	2	delimited
delisted	10	3	1056	2	deli_sted
dighted	13	25	1149	2	d__ighted
flighted	16	4	697	2	_flighted
lighted	12	29	1350	2	__lighted
plighted	15	4	646	2	_plighted
resighted	14	3	652	2	resighted
slighted	13	5	739	2	_slighted
unlighted	14	5	578	2	unlighted
uplighted	16	5	384	2	uplighted
weighted	16	3	559	2	we_ighted
beknighted	21	5	186	3	beknighted
bighted	14	28	1092	3	__bighted
blighter	14	6	685	3	_blighter
debited	11	33	1162	3	debi__ted
decimated	15	4	895	3	decimated
dedicated	14	3	1025	3	dedicated
deigned	10	3	750	3	de_ig_ned
delated	9	37	2287	3	del__ated
delegate	10	4	1046	3	delegate_
delegatee	11	4	880	3	delegatee
delegates	11	3	984	3	delegates
deleted	9	33	1491	3	del__eted
delicate	11	3	1549	3	delicate_
delicates	12	3	1431	3	delicates
delightful	18	5	142	3	delightful
delighting	16	4	499	3	delighting
delimed	11	3	1072	3	deli__med
delimiter	12	4	624	3	delimiter
delineated	12	4	624	3	delineated
delivered	14	4	503	3	delivered
deluged	10	16	741	3	delug__ed
demitted	12	28	877	3	demi_tted
denigrated	13	6	697	3	denigrated
depicted	14	3	774	3	depi_cted
depilated	13	3	965	3	depilated
derogated	12	3	867	3	derogated
designated	13	4	593	3	designated
designed	11	3	694	3	desig_ned
desisted	10	3	978	3	desi_sted
deviated	13	3	1104	3	devi_ated
draughted	15	4	369	3	draughted
elicited	11	3	909	3	_elicited
enlighten	13	4	435	3	enlighten
freighted	17	5	520	3	freighted
frighted	16	5	717	3	_frighted
heighten	15	4	570	3	he_ighten
highted	15	27	1016	3	__highted
knighted	17	4	512	3	_knighted
levigated	14	4	564	3	levigated
lichted	13	26	880	3	__lichted
ligated	9	24	1414	3	__ligated
lighten	11	28	1152	3	__lighten
lighter	11	31	1344	3	__lighter
limelighted	18	5	179	3	limelighted
mislighted	17	4	365	3	mislighted
neighed	12	13	589	3	ne_igh_ed
obligated	13	18	690	3	obligated
overlighted	19	4	421	3	overlighted
plighter	14	7	662	3	_plighter
preflighted	21	7	278	3	preflighted
relegated	11	3	976	3	relegated
relight	11	5	1206	3	relight__
relights	12	4	805	3	relight_s
relished	12	3	943	3	relish_ed
relisted	9	3	1262	3	reli_sted
retighten	13	7	477	3	retighten
righted	12	29	1214	3	__righted
sighted	12	31	1152	3	__sighted
skylighted	22	5	180	3	skylighted
sleighed	13	3	403	3	sleigh_ed
slighter	12	5	782	3	_slighter
unsighted	14	5	543	3	unsighted
uprighted	16	5	421	3	uprighted
weighed	15	13	593	3	we_igh_ed
weighter	15	3	560	3	we_ighter

Search took 8 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	148641	0.436	409841.7
2	DLD Change Limit	148641	89	6.736	22066.7
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	7.218	24756.3