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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

154 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
feoffing	14	3	296	(None)
boffing	16	33	998	2	_boffing
coffing	16	38	1125	2	_coffing
doffing	15	35	779	2	_doffing
enfeoffing	16	5	131	2	enfeoffing
fluffing	14	27	541	2	fluffing
infeoffing	16	4	166	2	infeoffing
offing	13	36	864	2	__offing
reffing	14	37	1217	2	re_ffing
scoffing	17	27	594	2	scoffing
baffing	16	40	1160	3	_baffing
beefing	13	39	1147	3	be_efing
biffing	16	35	1001	3	_biffing
bluffing	17	27	549	3	bluffing
boffin	14	35	905	3	_boffin_
boffins	15	32	907	3	_boffins
buffing	16	34	1139	3	_buffing
chaffing	20	3	632	3	chaffing
cheffing	20	3	446	3	cheffing
chuffing	20	5	504	3	chuffing
coffin	14	33	981	3	_coffin_
coffins	15	31	1019	3	_coffins
coffling	17	3	648	3	_coffling
coiffing	17	5	593	3	coiffing
coifing	13	32	1389	3	_coifing
cuffing	16	32	1025	3	_cuffing
daffing	15	36	973	3	_daffing
defying	15	32	882	3	de_fying
deifying	16	3	763	3	deifying
fearing	11	35	2003	3	fe_aring
feasing	11	39	1665	3	fe_asing
feasting	12	20	1132	3	feasting
feazing	20	54	1144	3	fe_azing
fedexing	20	3	449	3	fedexing
feeding	12	35	1507	3	fe_eding
feeing	10	44	1650	3	fe__eing
feeling	11	36	1707	3	fe_eling
feezing	20	46	1016	3	fe_ezing
feigning	13	3	581	3	feigning
feinting	12	34	1083	3	feinting
felling	11	33	2113	3	fe_lling
felting	11	35	1521	3	fe_lting
fencing	13	24	1113	3	fe_ncing
fending	12	37	1760	3	fe_nding
feoff	10	7	1105	3	feoff___
feoffed	13	3	281	3	feoff_ed
feoffee	12	4	390	3	feoff_ee
feoffees	13	4	216	3	feoffees
feoffer	12	3	302	3	feoff_er
feoffers	13	3	313	3	feoffers
feoffment	16	5	260	3	feoffment
feoffor	12	4	178	3	feoff_or
feoffors	13	4	198	3	feoffors
feoffs	11	6	370	3	feoff__s
ferrying	15	14	624	3	ferrying
feruling	12	5	887	3	feruling
fessing	11	38	1286	3	fe_ssing
fetching	17	29	841	3	fetching
feting	10	44	1779	3	fe__ting
fetting	11	35	1787	3	fe_tting
fettling	12	6	677	3	fettling
feuding	12	34	1026	3	fe_uding
feuing	10	44	1227	3	fe__uing
fevering	15	25	1008	3	fevering
fifing	13	42	1234	3	f__ifing
floating	12	31	1188	3	floating
floccing	16	30	603	3	floccing
flocking	18	34	1087	3	flocking
flogging	14	32	917	3	flogging
flooding	13	23	896	3	flooding
flooring	12	25	988	3	flooring
flopping	16	38	877	3	flopping
flossing	12	24	790	3	flossing
flouring	12	30	1014	3	flouring
flouting	12	26	1047	3	flouting
flowing	14	34	1176	3	flo_wing
foaling	11	35	1584	3	f_oaling
foaming	13	36	1299	3	f_oaming
fobbing	15	34	1027	3	f_obbing
fogging	13	35	1373	3	f_ogging
foiling	11	33	1765	3	f_oiling
foining	11	30	1345	3	f_oining
folding	12	39	1244	3	f_olding
fonding	12	38	1542	3	f_onding
fooling	11	31	1737	3	f_ooling
footing	11	50	1759	3	f_ooting
footling	12	23	992	3	footling
foozling	21	27	572	3	foozling
fopping	15	35	1113	3	f_opping
forcing	13	40	1375	3	f_orcing
fording	12	37	1704	3	f_ording
forging	12	41	1472	3	f_orging
forking	15	40	1484	3	f_orking
forming	13	36	1573	3	f_orming
fouling	11	33	1537	3	f_ouling
fowling	14	37	1311	3	f_owling
foxing	17	50	1243	3	f_o_xing
frocking	18	30	957	3	frocking
frogging	14	35	873	3	frogging
fronting	12	3	1044	3	fronting
frosting	12	3	1118	3	frosting
frothing	15	20	853	3	frothing
frowning	15	30	783	3	frowning
gaffing	15	37	973	3	_gaffing
golfing	12	36	894	3	_golfing
goofing	12	35	1063	3	_goofing
gruffing	16	3	527	3	gruffing
hefting	14	45	1091	3	he_fting
hoofing	14	39	1255	3	_hoofing
huffing	17	27	883	3	_huffing
kerfing	15	30	753	3	ke_rfing
leafing	11	33	1358	3	le_afing
loafing	11	31	979	3	_loafing
lofting	11	33	1131	3	_lofting
luffing	14	33	1010	3	_luffing
meouing	10	5	920	3	meo_uing
meowing	13	6	859	3	meo_wing
miffing	16	29	840	3	_miffing
muffing	16	32	1040	3	_muffing
naffing	14	35	903	3	_naffing
offings	14	28	583	3	__offings
peopling	13	3	835	3	peopling
piaffing	17	3	392	3	piaffing
proofing	14	3	931	3	proofing
puffing	16	29	1094	3	_puffing
quaffing	24	3	435	3	quaffing
rebuffing	18	4	326	3	rebuffing
reefing	11	40	1686	3	re_efing
reifying	15	3	938	3	reifying
reoffering	17	4	409	3	reoffering
reoiling	9	32	1721	3	reoiling
reroofing	13	3	686	3	reroofing
riffing	14	40	1127	3	_riffing
rolfing	11	37	1065	3	_rolfing
roofing	11	38	1435	3	_roofing
ruffing	14	32	1084	3	_ruffing
scuffing	17	28	711	3	scuffing
selfing	11	29	1162	3	se_lfing
shroffing	19	4	331	3	shroffing
sluffing	15	24	730	3	sluffing
sniffing	15	22	745	3	sniffing
snuffing	15	25	680	3	snuffing
spiffing	17	23	708	3	spiffing
spoofing	14	22	836	3	spoofing
staffing	15	24	749	3	staffing
stiffing	15	24	870	3	stiffing
stuffing	15	24	784	3	stuffing
tiffing	14	33	938	3	_tiffing
waffing	17	37	1024	3	_waffing
whiffing	21	3	470	3	whiffing
whoofing	18	23	483	3	whoofing
wolfing	14	27	789	3	_wolfing
woofing	14	34	989	3	_woofing
yaffing	17	33	782	3	_yaffing

Search took 9 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	146162	0.843	211970.3
2	DLD Change Limit	146162	154	7.953	18378.2
3	Display Results	154	154	0.063	2444.4
	(SQL Overall)	178691	154	8.859	20170.6