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

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

59 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
resorting	10	6	1461	(None)
presorting	13	3	998	1	presorting
reporting	12	5	1390	1	reporting
resorbing	12	6	935	1	resorbing
retorting	10	6	1327	1	retorting
assorting	10	3	730	2	assorting
besotting	12	25	687	2	besotting
dehorting	14	4	721	2	dehorting
deporting	13	6	959	2	deporting
deserting	11	7	1314	2	deserting
desorbing	13	4	636	2	desorbing
escorting	12	3	771	2	_escorting
reassorting	12	4	502	2	reassorting
rebooting	12	13	902	2	rebooting
reboring	11	3	1278	2	rebor_ing
recoating	12	13	1746	2	recoating
recording	13	13	1162	2	recording
recorking	16	14	964	2	recorking
reforging	14	3	766	2	reforging
reforming	15	3	856	2	reforming
regorging	12	3	682	2	regorging
repotting	12	5	1112	2	repotting
rerouting	10	3	1187	2	rerouting
rescoring	12	3	1060	2	rescor_ing
reseating	10	24	2153	2	reseating
resecting	12	28	1648	2	resecting
resenting	10	26	1929	2	resenting
reserving	13	11	1064	2	reserving
resetting	10	28	1629	2	resetting
reshooting	14	3	622	2	reshooting
resifting	13	35	1209	2	resifting
resisting	10	32	1531	2	resisting
resiting	9	35	2112	2	res_iting
resitting	10	34	1487	2	resitting
reslating	10	25	1699	2	reslating
resoaking	14	3	937	2	resoaking
resodding	12	3	720	2	resodding
resoling	9	29	1630	2	reso_ling
resolving	13	3	774	2	resolving
resonating	11	3	1126	2	resonating
resorcin	10	4	682	2	resorcin_
resorcins	11	4	698	2	resorcins
resowing	12	31	1152	2	reso_wing
respiting	12	19	1286	2	respiting
respotting	13	4	711	2	respotting
respring	11	16	1406	2	respr_ing
restarting	11	3	1066	2	restarting
restating	10	23	1941	2	restating
resting	8	50	3118	2	res__ting
restoring	10	3	1461	2	restor_ing
restring	9	15	1878	2	restr_ing
resulting	10	3	1108	2	resulting
resurging	11	3	861	2	resurging
reverting	13	23	1513	2	reverting
revolting	13	3	963	2	revolting
revoting	12	3	1203	2	revo_ting
rewording	14	15	854	2	rewording
reworking	17	13	687	2	reworking
sorting	8	32	2181	2	__sorting

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	121436	0.140	1276364.3
2	DLD Change Limit	121436	59	3.546	34245.9
3	Display Results	59	59	0.016	3687.5
	(SQL Overall)	178691	59	3.702	48268.8