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

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

81 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
reffing	14	37	1217	(None)
reefing	11	40	1686	1	reefing
riffing	14	40	1127	1	riffing
ruffing	14	32	1084	1	ruffing
baffing	16	40	1160	2	baffing
beefing	13	39	1147	2	beefing
biffing	16	35	1001	2	biffing
boffing	16	33	998	2	boffing
buffing	16	34	1139	2	buffing
cheffing	20	3	446	2	cheffing
coffing	16	38	1125	2	coffing
cuffing	16	32	1025	2	cuffing
daffing	15	36	973	2	daffing
defying	15	32	882	2	defying
doffing	15	35	779	2	doffing
feoffing	14	3	296	2	feoffing
gaffing	15	37	973	2	gaffing
gruffing	16	3	527	2	gruffing
hefting	14	45	1091	2	hefting
huffing	17	27	883	2	huffing
kerfing	15	30	753	2	kerfing
leafing	11	33	1358	2	leafing
luffing	14	33	1010	2	luffing
miffing	16	29	840	2	miffing
muffing	16	32	1040	2	muffing
naffing	14	35	903	2	naffing
offing	13	36	864	2	_offing
puffing	16	29	1094	2	puffing
raffling	15	6	706	2	raffling
rafting	11	38	1575	2	rafting
reading	9	33	2721	2	reading
reaming	10	39	2401	2	reaming
reaping	10	36	2121	2	reaping
rearing	8	31	2878	2	rearing
reaving	11	38	2053	2	reaving
rebuffing	18	4	326	2	rebuffing
recking	14	43	1992	2	recking
redding	10	32	1851	2	redding
redfin	10	3	1022	2	redfin_
redfins	11	3	992	2	redfins
reding	8	38	2556	2	re_ding
redoing	9	35	1673	2	redoing
redwing	12	28	1198	2	redwing
reeding	9	41	2413	2	reeding
reeking	12	33	1864	2	reeking
reeling	8	31	2686	2	reeling
reeving	11	37	1766	2	reeving
refacing	14	25	1281	2	refacing
refiling	12	31	1653	2	refiling
refind	10	47	1707	2	re_find
refine	9	52	2569	2	re_fine
refining	12	24	1686	2	refining
refiring	12	35	1392	2	refiring
refixing	19	32	979	2	refixing
reflying	15	26	817	2	reflying
refrying	15	27	890	2	refrying
refuging	13	21	842	2	refuging
refusing	12	23	1087	2	refusing
refuting	12	19	1190	2	refuting
reifying	15	3	938	2	reifying
reining	8	44	2532	2	reining
reiving	11	33	1684	2	reiving
relying	11	29	1461	2	relying
rending	9	39	2426	2	rending
renting	8	40	2685	2	renting
repping	12	33	1498	2	repping
resting	8	50	3118	2	resting
retting	8	34	2588	2	retting
retying	11	32	1383	2	retying
reusing	8	25	1678	2	reusing
revving	14	37	934	2	revving
riffling	15	5	611	2	riffling
rifling	11	28	1501	2	rifling
rifting	11	35	1500	2	rifting
rolfing	11	37	1065	2	rolfing
roofing	11	38	1435	2	roofing
ruffling	15	4	609	2	ruffling
selfing	11	29	1162	2	selfing
tiffing	14	33	938	2	tiffing
waffing	17	37	1024	2	waffing
yaffing	17	33	782	2	yaffing

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	107671	0.406	440125.6
2	DLD Change Limit	107671	81	3.576	30109.3
3	Display Results	81	81	0.016	5062.5
	(SQL Overall)	178691	81	3.998	44695.1