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

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

42 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
joisting	16	32	850	(None)
foisting	12	29	1050	1	foisting
hoisting	12	36	1090	1	hoisting
jointing	16	24	861	1	jointing
jousting	16	30	935	1	jousting
agisting	10	3	824	2	agisting
boasting	11	35	1250	2	boasting
boosting	11	33	1105	2	boosting
coasting	11	36	1551	2	coasting
costing	10	43	2302	2	co_sting
existing	16	3	907	2	existing
fisting	11	38	1812	2	_fisting
heisting	12	34	1104	2	heisting
histing	11	37	2037	2	_histing
hoising	11	34	1441	2	hois_ing
hosting	11	43	1838	2	ho_sting
jesting	15	43	1771	2	j_esting
jilting	15	32	1174	2	j_ilting
joining	15	30	1148	2	joi_ning
jolting	15	34	1091	2	jo_lting
joshing	18	51	941	2	jo_shing
jostling	16	20	712	2	jo_stling
jotting	15	29	1277	2	jo_tting
justing	15	36	1516	2	j_usting
listing	8	40	2059	2	_listing
misting	10	36	2338	2	_misting
noising	8	36	1517	2	nois_ing
ousting	8	40	2135	2	_ousting
pointing	11	28	1368	2	pointing
poising	10	36	1710	2	pois_ing
positing	11	3	1230	2	positing
posting	10	56	2224	2	po_sting
roasting	9	30	1270	2	roasting
roosting	9	34	1146	2	roosting
rousting	9	39	1327	2	rousting
toasting	9	34	1058	2	toasting
toiting	8	32	1709	2	toi_ting
twisting	12	42	781	2	twisting
waisting	12	36	1521	2	waisting
whisting	15	32	954	2	whisting
wisting	11	35	1974	2	_wisting
worsting	12	6	768	2	worsting

Search took 4 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	42	3.190	37949.5
3	Display Results	42	42	0.013	3230.8
	(SQL Overall)	178691	42	3.593	49733.1