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

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

331 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
toffee	12	33	1101	(None)
coffee	14	41	1374	1	coffee
toffees	13	32	708	1	toffees
boffed	15	36	948	2	boffed
coffees	15	32	957	2	coffees
coffer	14	41	1286	2	coffer
coffle	14	35	904	2	coffle
doffed	14	42	850	2	doffed
doffer	13	39	1135	2	doffer
etouffee	14	6	230	2	etouffee
feoffee	12	4	390	2	feoffee
goffer	13	40	951	2	goffer
offed	12	35	916	2	_offed
offer	11	43	1138	2	_offer
tiffed	13	36	839	2	tiffed
toff	10	59	2990	2	toff__
toffies	13	32	1021	2	toffies
toffs	11	60	1672	2	toff_s
toffy	14	53	1028	2	toff_y
topee	7	60	2995	2	to_pee
toupee	8	3	1613	2	toupee
towhee	12	26	1388	2	towhee
townee	9	28	1521	2	townee
troffer	13	12	586	2	troffer
tuffet	12	26	1208	2	tuffet
baffed	15	48	1217	3	baffed
baffle	14	39	987	3	baffle
biffed	15	44	988	3	biffed
boff	12	47	2733	3	boff__
boffin	14	35	905	3	boffin
boffo	13	60	1037	3	boff_o
boffos	14	56	819	3	boffos
boffs	13	49	1550	3	boff_s
bootee	8	43	2302	3	bootee
bouffe	14	43	831	3	bouffe
bouffes	15	38	863	3	bouffes
buffed	15	43	1314	3	buffed
buffer	14	45	1268	3	buffer
buffet	14	31	1378	3	buffet
coatee	8	43	2722	3	coatee
coff	12	69	3078	3	coff__
coffered	17	3	767	3	coffered
coffers	15	41	1269	3	coffers
coffin	14	33	981	3	coffin
coffled	16	29	736	3	coffled
coffles	15	26	1000	3	coffles
coffret	15	3	1007	3	coffret
coffs	13	49	1630	3	coff_s
coifed	12	41	1306	3	coifed
coiffe	14	4	704	3	coiffe
coiffed	16	3	541	3	coiffed
coiffes	15	4	680	3	coiffes
confer	11	40	1868	3	confer
congee	9	60	2446	3	congee
cooee	7	45	3102	3	co_oee
corvee	11	43	2009	3	corvee
coulee	8	3	2350	3	coulee
cuffed	15	43	1121	3	cuffed
daffed	14	42	949	3	daffed
deffer	13	44	1130	3	deffer
differ	13	39	1084	3	differ
doff	11	62	2578	3	doff__
doffers	14	35	985	3	doffers
doffs	12	56	1433	3	doff_s
donee	6	69	3101	3	do_nee
donnee	7	43	1706	3	donnee
doolee	7	30	1895	3	doolee
duffel	13	40	775	3	duffel
duffer	13	47	1166	3	duffer
duffle	13	36	853	3	duffle
effete	12	3	518	3	_effete
etouffees	15	6	127	3	etouffees
fee	6	68	6201	3	___fee
feoffed	13	3	281	3	feoffed
feoffees	13	4	216	3	feoffees
feoffer	12	3	302	3	feoffer
flee	7	62	3879	3	__flee
formee	11	39	1994	3	formee
free	7	59	4018	3	__free
gaffe	12	41	1165	3	gaff_e
gaffed	14	42	1020	3	gaffed
gaffer	13	43	1013	3	gaffer
gaffes	13	48	1110	3	gaffes
giftee	10	35	1208	3	giftee
goatee	7	32	1953	3	goatee
gofer	9	48	1428	3	go_fer
goffered	16	3	452	3	goffered
goffers	14	40	921	3	goffers
golfed	11	56	976	3	golfed
golfer	10	44	1118	3	golfer
goofed	11	49	1138	3	goofed
haffet	15	3	1170	3	haffet
hoofed	13	46	1489	3	hoofed
hoofer	12	40	1495	3	hoofer
huffed	16	37	1015	3	huffed
loafed	10	40	1115	3	loafed
loafer	9	36	1094	3	loafer
lofted	10	38	1189	3	lofted
lofter	9	46	1472	3	lofter
luffed	13	38	1082	3	luffed
miffed	15	39	871	3	miffed
moffette	16	4	349	3	moffette
muffed	15	42	1059	3	muffed
muffle	14	33	964	3	muffle
naffed	13	40	833	3	naffed
niffer	12	37	844	3	niffer
off	9	63	3163	3	_off__
offal	11	3	624	3	_offal
offence	15	4	535	3	_offence
offend	13	36	566	3	_offend
offense	13	4	368	3	_offense
offered	14	3	614	3	_offered
offerer	13	3	554	3	_offerer
offers	12	34	996	3	_offers
office	14	3	569	3	_office
offkey	19	3	234	3	_offkey
offs	10	71	1701	3	_off_s
offset	12	3	837	3	_offset
often	8	46	1141	3	_often
ofter	8	41	1687	3	_ofter
ogee	5	76	2988	3	_o_gee
piffle	14	41	823	3	piffle
pollee	8	36	2327	3	pollee
pommee	12	28	1328	3	pommee
pongee	9	49	2019	3	pongee
poufed	12	44	971	3	poufed
pouffe	14	44	826	3	pouffe
pouffed	16	36	595	3	pouffed
pouffes	15	40	812	3	pouffes
proffer	15	12	693	3	proffer
puffed	15	35	1060	3	puffed
puffer	14	46	1073	3	puffer
raffle	12	39	1070	3	raffle
reffed	13	47	1251	3	reffed
reoffer	13	3	501	3	reoffer
riffed	13	38	1156	3	riffed
riffle	12	42	1023	3	riffle
rolfed	10	45	1052	3	rolfed
rolfer	9	44	1227	3	rolfer
roofed	10	52	1474	3	roofed
roofer	9	44	1528	3	roofer
roofie	9	34	1117	3	roofie
ruffe	11	47	1381	3	ruff_e
ruffed	13	43	1274	3	ruffed
ruffes	12	41	1242	3	ruffes
ruffle	12	41	1167	3	ruffle
scoffed	16	26	618	3	scoffed
scoffer	15	31	702	3	scoffer
soffit	12	3	788	3	soffit
soften	9	42	949	3	soften
softer	9	40	1531	3	softer
softie	9	33	1248	3	softie
soiree	6	29	1948	3	soiree
solfege	11	4	422	3	solfege
souffle	13	30	680	3	souffle
staffed	14	29	828	3	staffed
staffer	13	29	909	3	staffer
stiffed	14	35	958	3	stiffed
stiffen	13	28	602	3	stiffen
stiffer	13	31	939	3	stiffer
stiffie	13	24	577	3	stiffie
stuffed	14	32	897	3	stuffed
stuffer	13	34	979	3	stuffer
suffer	12	43	1451	3	suffer
tafferel	14	4	312	3	tafferel
taffeta	13	4	326	3	taffeta
taffia	12	28	690	3	taffia
taffies	13	30	1269	3	taffies
taffy	14	51	1082	3	taff_y
tee	3	83	6687	3	t___ee
teepee	8	3	1436	3	teepee
teff	10	60	2376	3	teff__
teffs	11	51	1173	3	teff_s
telfer	9	37	989	3	telfer
tepee	7	47	2421	3	t_epee
testee	6	43	2330	3	testee
thee	7	80	3906	3	t__hee
three	8	75	2691	3	t_hree
tiff	10	47	2772	3	tiff__
tiffin	12	32	793	3	tiffin
tiffs	11	44	1488	3	tiff_s
titfer	9	40	952	3	titfer
tobies	8	45	2102	3	tobies
tocher	11	40	1491	3	tocher
toddle	8	58	1103	3	toddle
todies	7	42	2355	3	todies
toe	3	101	6685	3	to___e
toea	4	67	3233	3	to__ea
toed	5	61	3704	3	to__ed
toes	4	69	5644	3	to__es
toft	7	74	4165	3	to_f_t
tofts	8	49	1924	3	to_fts
tofu	7	69	2133	3	to_f_u
tofus	8	64	1542	3	to_fus
togae	6	70	2011	3	to_gae
togaed	8	47	1134	3	togaed
togate	7	45	1568	3	togate
togged	9	51	1751	3	togged
toggle	8	38	1087	3	toggle
togue	6	48	1630	3	to_gue
togues	7	60	1424	3	togues
toile	5	46	2649	3	to_ile
toiled	7	44	2032	3	toiled
toiler	6	39	1828	3	toiler
toiles	6	39	2351	3	toiles
toilet	6	62	2809	3	toilet
toited	7	40	1675	3	toited
toke	8	67	3849	3	to__ke
toked	10	56	2649	3	to_ked
token	9	54	1931	3	to_ken
toker	9	59	2491	3	to_ker
tokes	9	52	3497	3	to_kes
tolane	6	43	1658	3	tolane
tole	4	60	5290	3	to__le
toled	6	59	3492	3	to_led
toles	5	51	4713	3	to_les
tolled	7	38	1903	3	tolled
toller	6	38	1944	3	toller
toluene	7	3	646	3	toluene
tombed	11	38	1213	3	tombed
tome	6	75	4319	3	to__me
tomes	7	60	3738	3	to_mes
tommed	11	33	1014	3	tommed
tone	4	69	5374	3	to__ne
toned	6	54	3534	3	to_ned
toneme	8	3	1210	3	toneme
toner	5	53	3624	3	to_ner
tones	5	60	4866	3	to_nes
toney	8	60	2741	3	to_ney
tonged	8	65	1890	3	tonged
tonger	7	47	1968	3	tonger
tongue	7	4	1009	3	tongue
tonier	6	55	2071	3	tonier
tonlet	6	29	2470	3	tonlet
tonne	5	49	2143	3	to_nne
tonner	6	48	1920	3	tonner
tonnes	6	53	2085	3	tonnes
tooled	7	49	1890	3	tooled
tooler	6	38	1861	3	tooler
toonie	6	36	1799	3	toonie
tooted	7	46	2012	3	tooted
tooter	6	44	2080	3	tooter
tootle	6	26	1381	3	tootle
tope	6	59	4638	3	to__pe
toped	8	56	3131	3	to_ped
topees	8	55	1970	3	topees
toper	7	52	3102	3	to_per
topes	7	69	4176	3	to_pes
topful	11	3	654	3	topful
tophe	10	67	1897	3	to_phe
tophes	11	52	1842	3	tophes
topped	11	46	1772	3	topped
topper	10	38	1760	3	topper
topple	10	44	1132	3	topple
toque	14	51	1309	3	to_que
toques	15	46	1235	3	toques
toquet	15	44	1468	3	toquet
tore	4	73	5932	3	to__re
tores	5	53	5267	3	to_res
tories	6	54	3588	3	tories
torose	6	43	1769	3	torose
torque	15	23	767	3	torque
torse	5	58	3333	3	to_rse
torses	6	47	2795	3	torses
torte	5	54	3170	3	to_rte
torten	6	53	1435	3	torten
tortes	6	48	2605	3	tortes
toshes	9	45	2010	3	toshes
tossed	7	42	1522	3	tossed
tosser	6	42	1566	3	tosser
tosses	6	52	2539	3	tosses
tote	4	66	4367	3	to__te
toted	6	49	2948	3	to_ted
totem	7	48	1937	3	to_tem
toter	5	59	3213	3	to_ter
totes	5	51	3968	3	to_tes
tother	9	41	1714	3	tother
totted	7	43	1995	3	totted
totter	6	50	2146	3	totter
touche	11	49	1617	3	touche
toupees	9	3	851	3	toupees
toured	7	42	1615	3	toured
tourer	6	41	1507	3	tourer
touse	5	54	3067	3	to_use
toused	7	41	2201	3	toused
touses	6	42	2967	3	touses
tousle	6	45	1465	3	tousle
touted	7	44	1974	3	touted
touter	6	38	2103	3	touter
touzle	15	42	900	3	touzle
towage	10	3	983	3	towage
towed	9	51	3458	3	to_wed
towel	8	49	2052	3	to_wel
tower	8	57	2920	3	to_wer
towhees	13	27	779	3	towhees
towie	8	58	2187	3	to_wie
towies	9	35	2119	3	towies
townees	10	26	978	3	townees
townie	9	33	1230	3	townie
toxine	13	31	1412	3	toxine
toyed	9	60	1980	3	to_yed
toyer	8	45	2155	3	to_yer
tree	4	77	4581	3	t__ree
trifle	9	40	1288	3	trifle
trochee	12	26	1388	3	trochee
troffers	14	12	543	3	troffers
truffe	12	7	623	3	truffe
truffes	13	5	677	3	truffes
truffle	13	8	489	3	truffle
tuff	10	45	2852	3	tuff__
tuffets	13	26	652	3	tuffets
tuffs	11	51	1826	3	tuff_s
tufted	10	35	928	3	tufted
tufter	9	31	993	3	tufter
turfed	10	31	1096	3	turfed
tutee	5	4	2352	3	t_utee
twee	7	68	2708	3	t__wee
twofer	12	3	435	3	twofer
tyee	7	51	3142	3	t__yee
unfree	9	4	1320	3	unfree
waffed	16	45	979	3	waffed
waffie	15	33	856	3	waffie
waffle	15	36	918	3	waffle
wolfed	13	42	801	3	wolfed
wolfer	12	42	998	3	wolfer
woofed	13	45	1120	3	woofed
woofer	12	44	1136	3	woofer
yaffed	16	45	732	3	yaffed
yogee	9	5	1806	3	yo_gee
zaffer	21	39	715	3	zaffer
zaffre	21	35	466	3	zaffre

Search took 6 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	112716	0.263	679433.5
2	DLD Change Limit	112716	331	5.486	20546.1
3	Display Results	331	331	0.110	3009.1
	(SQL Overall)	178691	331	5.859	30498.5