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

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

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.

55 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
dealings	10	35	1070	(None)
dealing	9	43	2323	1	dealing_
dialings	10	32	982	1	dialings
yealings	12	25	770	1	yealings
beadings	12	37	1178	2	beadings
bearings	11	39	1225	2	bearings
beatings	11	41	1323	2	beatings
bellings	11	38	1115	2	bellings
ceilings	11	39	799	2	ceilings
darings	9	37	1365	2	d_arings
darlings	10	37	1038	2	darlings
deadlines	11	13	850	2	deadlines
deaning	9	40	2047	2	deaning_
deaving	12	38	1475	2	deaving_
deckings	16	34	668	2	deckings
declines	11	33	1580	2	declines
delaines	9	3	1296	2	delaines
detailings	12	24	392	2	detailings
dialing	9	43	1817	2	dialing_
diallings	11	3	499	2	diallings
drawings	13	38	628	2	drawings
dwellings	14	24	421	2	dwellings
eanlings	9	12	847	2	_eanlings
earings	8	45	1771	2	_earings
eatings	8	46	1644	2	_eatings
feelings	12	33	893	2	feelings
gearings	10	35	950	2	gearings
headings	13	35	1049	2	headings
healing	11	39	2296	2	healing_
hearings	12	36	1185	2	hearings
heelings	12	35	975	2	heelings
keglings	14	24	523	2	keglings
leadings	10	35	1124	2	leadings
leanings	9	40	1018	2	leanings
leasings	9	37	984	2	leasings
leavings	12	40	749	2	leavings
meanings	11	32	916	2	meanings
palings	10	39	1582	2	_palings
pealing	10	41	2320	2	pealing_
peelings	11	33	952	2	peelings
readings	10	35	1264	2	readings
realigns	9	3	625	2	realigns
reelings	9	40	1256	2	reelings
sealing	8	35	2856	2	sealing_
seatings	9	36	1430	2	seatings
shealings	13	31	756	2	shealings
stealings	10	31	885	2	stealings
vealing	11	42	1742	2	vealing_
veilings	12	35	731	2	veilings
weaklings	17	9	400	2	weaklings
weanlings	13	9	441	2	weanlings
whalings	15	25	676	2	whalings
yealing	11	27	1638	2	yealing_
yeanlings	13	9	369	2	yeanlings
yearlings	13	8	420	2	yearlings

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	55	3.720	32542.7
3	Display Results	55	55	0.013	4230.8
	(SQL Overall)	178691	55	4.123	43340.0