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

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

289 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
truffes	13	5	677	(None)
ruffes	12	41	1242	1	_ruffes
truffe	12	7	623	1	truffe_
truffles	14	8	559	1	truffles
bouffes	15	38	863	2	bouffes
griffes	14	36	792	2	griffes
gruffed	15	4	494	2	gruffed
gruffer	14	7	579	2	gruffer
gruffest	15	4	459	2	gruffest
gruffs	13	33	745	2	gruff_s
pouffes	15	40	812	2	pouffes
ruffe	11	47	1381	2	_ruffe_
ruffed	13	43	1274	2	_ruffed
ruffles	13	35	1227	2	_ruffles
ruffs	11	45	1674	2	_ruff_s
tartuffes	15	5	162	2	tartuffes
trifles	10	38	1482	2	trifles
troffer	13	12	586	2	troffer
troffers	14	12	543	2	troffers
truces	8	49	1633	2	tru_ces
trudges	9	33	999	2	trudges
trues	5	49	2532	2	tru__es
truffle	13	8	489	2	truffle
truffled	15	6	399	2	truffled
trusses	7	38	1364	2	trusses
tuffet	12	26	1208	2	t_uffet
tuffets	13	26	652	2	t_uffets
tuffs	11	51	1826	2	t_uff_s
agraffes	15	5	304	3	agraffes
argufies	12	4	374	3	argufies
bluffed	16	32	643	3	bluffed
bluffer	15	39	688	3	bluffer
bluffers	16	40	570	3	bluffers
bluffest	16	6	464	3	bluffest
bluffs	14	38	837	3	bluff_s
bouffe	14	43	831	3	bouffe_
bruises	9	32	1291	3	bruises
brumes	10	64	1707	3	bru_mes
brushes	12	40	1466	3	brushes
brutes	8	61	1868	3	bru_tes
bruxes	15	48	1102	3	bru_xes
buffed	15	43	1314	3	_buffed
buffer	14	45	1268	3	_buffer
buffers	15	33	1079	3	_buffers
buffest	15	29	864	3	_buffest
buffet	14	31	1378	3	_buffet
buffets	15	31	759	3	_buffets
buffos	14	44	785	3	_buffos
buffs	13	55	1951	3	_buff_s
chuffed	19	31	664	3	chuffed
chuffer	18	33	714	3	chuffer
chuffest	19	4	419	3	chuffest
chuffs	17	42	778	3	chuff_s
coiffes	15	4	680	3	coiffes
cruces	10	51	1754	3	cru_ces
crudes	9	62	1862	3	cru_des
cruises	9	35	1444	3	cruises
cruses	8	81	2771	3	cru_ses
crushes	12	42	1513	3	crushes
cruxes	15	49	1156	3	cru_xes
cuffed	15	43	1121	3	_cuffed
cuffs	13	50	1749	3	_cuff_s
draffs	13	61	790	3	draff_s
drudges	10	30	887	3	drudges
drupes	9	49	1265	3	dru_pes
druses	7	55	1725	3	dru_ses
duffel	13	40	775	3	_duffel
duffels	14	29	645	3	_duffels
duffer	13	47	1166	3	_duffer
duffers	14	34	1009	3	_duffers
duffles	14	30	892	3	_duffles
duffs	12	52	1662	3	_duff_s
etouffee	14	6	230	3	etouffee
etouffees	15	6	127	3	etouffees
fluffed	13	29	590	3	fluffed
fluffer	12	33	650	3	fluffer
fluffers	13	33	529	3	fluffers
fluffs	11	34	778	3	fluff_s
gaffes	13	48	1110	3	_gaffes
gauffer	14	7	442	3	gauffer
gauffers	15	6	383	3	gauffers
giraffes	15	4	260	3	giraffes
griffe	13	43	809	3	griffe_
griffs	13	39	899	3	griff_s
grudges	10	34	942	3	grudges
grues	6	57	2196	3	gru__es
gruff	12	47	1214	3	gruff__
gruffier	15	4	470	3	gruffier
gruffiest	16	3	453	3	gruffiest
gruffish	18	4	394	3	gruffish
gruffly	17	41	389	3	gruffly
gruffness	16	9	274	3	gruffness
gruffy	16	39	601	3	gruff_y
grumes	9	44	1555	3	gru_mes
grunges	9	33	1040	3	grunges
guffs	12	44	1482	3	_guff_s
huffed	16	37	1015	3	_huffed
huffs	14	45	1474	3	_huff_s
luffas	12	33	748	3	_luffas
luffed	13	38	1082	3	_luffed
luffs	11	45	1628	3	_luff_s
muffed	15	42	1059	3	_muffed
muffles	15	39	1045	3	_muffles
muffs	13	41	1421	3	_muff_s
piaffes	15	11	505	3	piaffes
pouffe	14	44	826	3	pouffe_
pouffed	16	36	595	3	pouffed
pouffs	14	41	812	3	pouff_s
proffer	15	12	693	3	proffer
proffers	16	12	659	3	proffers
prudes	9	42	1544	3	pru_des
prunes	8	34	1906	3	pru_nes
puffed	15	35	1060	3	_puffed
puffer	14	46	1073	3	_puffer
puffers	15	34	920	3	_puffers
puffs	13	41	1493	3	_puff_s
purfles	12	25	1184	3	purfles
raffles	13	36	1184	3	_raffles
raffs	11	50	1752	3	_raff_s
reffed	13	47	1251	3	_reffed
riffed	13	38	1156	3	_riffed
riffles	13	39	1116	3	_riffles
riffs	11	51	1461	3	_riff_s
rifles	9	42	1770	3	_rifles
rubes	7	49	2841	3	_ru_bes
rubies	8	44	2034	3	_rubies
rubles	8	39	2170	3	_rubles
ruches	11	48	1958	3	_ruches
rues	4	60	4448	3	_ru__es
ruff	10	51	2765	3	_ruff__
ruffle	12	41	1167	3	_ruffle
ruffled	14	36	915	3	_ruffled
ruffler	13	36	972	3	_ruffler
rufflers	14	34	719	3	_rufflers
ruffly	15	33	667	3	_ruffly
rufous	9	4	827	3	_rufous
rules	5	52	3425	3	_ru_les
runes	5	55	3022	3	_ru_nes
rupees	8	3	1257	3	_rupees
ruses	5	61	3658	3	_ru_ses
rushes	9	47	2436	3	_rushes
scruffs	15	5	417	3	scruff_s
scuffed	16	29	824	3	scuffed
scuffer	15	32	888	3	scuffer
scuffers	16	30	749	3	scuffers
scuffles	16	28	786	3	scuffles
scuffs	14	41	905	3	scuff_s
shuffles	17	29	778	3	shuffles
sluffed	14	30	830	3	sluffed
sluffs	12	34	958	3	sluff_s
snuffed	14	30	807	3	snuffed
snuffer	13	31	885	3	snuffer
snuffers	14	32	692	3	snuffers
snuffles	14	31	841	3	snuffles
snuffs	12	35	853	3	snuff_s
souffles	14	29	812	3	souffles
strafes	10	45	1600	3	str_afes
strifes	10	47	1658	3	str_ifes
stuffed	14	32	897	3	stuffed
stuffer	13	34	979	3	stuffer
stuffers	14	27	738	3	stuffers
stuffs	12	38	1022	3	stuff_s
suffer	12	43	1451	3	_suffer
suffers	13	31	1354	3	_suffers
taffies	13	30	1269	3	taffies
tariffed	15	3	372	3	tariffed
tariffs	13	3	459	3	tariff_s
tartufes	11	6	415	3	tartufes
tartuffe	14	6	190	3	tartuffe_
taupes	8	2	1267	3	tau_pes
teffs	11	51	1173	3	t_eff_s
thrushes	14	3	652	3	thrushes
tiffed	13	36	839	3	t_iffed
tiffs	11	44	1488	3	t_iff_s
toffee	12	33	1101	3	t_offee
toffees	13	32	708	3	toffees
toffies	13	32	1021	3	toffies
toffs	11	60	1672	3	t_off_s
touches	12	51	1834	3	touches
toupees	9	3	851	3	toupees
touses	6	42	2967	3	tou_ses
tousles	7	41	1393	3	tousles
touzles	16	35	922	3	touzles
traces	8	53	2993	3	tr_aces
trades	7	57	2450	3	tr_ades
traffic	15	4	473	3	traffic
traffics	16	4	418	3	traffics
trances	9	39	1964	3	trances
trapes	8	50	2446	3	tr_apes
trashes	10	41	1926	3	trashes
trasses	7	48	1932	3	trasses
traves	9	42	2274	3	tr_aves
trebles	9	3	1144	3	trebles
trees	5	58	3576	3	tr__ees
tres	4	65	4290	3	tr___es
tresses	7	37	1954	3	tresses
triages	8	26	1379	3	triages
tribes	8	51	1902	3	tr_ibes
trices	8	48	2633	3	tr_ices
trienes	7	41	1841	3	trienes
tries	5	57	4281	3	tr__ies
trifle	9	40	1288	3	trifle_
trifled	11	37	1196	3	trifled
trifler	10	39	1215	3	trifler
triflers	11	31	1021	3	triflers
trikes	10	54	1949	3	tr_ikes
trines	6	41	3256	3	tr_ines
triodes	8	40	1250	3	triodes
trioses	7	50	1565	3	trioses
tripes	8	53	2487	3	tr_ipes
triples	9	46	1687	3	triples
triunes	7	43	1138	3	triunes
troches	12	37	1534	3	troches
trokes	10	40	1926	3	tr_okes
trompes	11	41	1162	3	trompes
trones	6	56	2928	3	tr_ones
tropes	8	48	2435	3	tr_opes
troubles	10	5	720	3	troubles
trounces	10	3	706	3	trounces
troupes	9	41	1285	3	troupes
troves	9	47	1911	3	tr_oves
truants	7	3	816	3	truants
truce	7	51	1869	3	tru_ce_
truced	9	53	1205	3	tru_ced
trucked	14	39	1081	3	trucked
trucker	13	40	1073	3	trucker
truckers	14	27	901	3	truckers
truckles	14	31	938	3	truckles
trucks	12	47	1197	3	tru_cks
trudge	8	31	873	3	trudge_
trudged	10	29	804	3	trudged
trudgen	9	35	705	3	trudgen
trudgens	10	25	515	3	trudgens
trudger	9	33	873	3	trudger
trudgers	10	25	686	3	trudgers
true	4	67	2585	3	tru__e_
trued	6	51	1769	3	tru__ed
trueness	8	3	869	3	trueness
truer	5	49	1664	3	tru__er
truest	6	48	1619	3	tru__est
trugs	6	55	1680	3	tru__gs
truisms	9	10	682	3	truisms
trulls	6	41	1028	3	tru_lls
trumped	12	43	971	3	trumped
trumpet	11	38	1072	3	trumpet
trumpets	12	31	557	3	trumpets
trumps	10	46	1188	3	tru_mps
trundles	9	27	848	3	trundles
trunked	12	35	841	3	trunked
trunks	10	42	975	3	tru_nks
trunnel	7	4	540	3	trunnel
trunnels	8	4	451	3	trunnels
truss	5	49	1692	3	tru__ss
trussed	8	40	1003	3	trussed
trusser	7	40	1026	3	trusser
trussers	8	34	828	3	trussers
trusted	8	34	1279	3	trusted
trustee	7	35	1444	3	trustee
trustees	8	33	932	3	trustees
truster	7	31	1431	3	truster
trusters	8	31	1226	3	trusters
trusties	8	27	1285	3	trusties
trusts	6	47	1443	3	tru_sts
truths	9	44	950	3	tru_ths
trystes	10	41	999	3	trystes
tubes	7	48	2645	3	t_u_bes
tufas	8	53	1438	3	t_u_fas
tuff	10	45	2852	3	t_uff__
tufted	10	35	928	3	t_ufted
tufter	9	31	993	3	t_ufter
tufters	10	29	835	3	t_ufters
tufts	8	57	1327	3	t_u_fts
tules	5	45	3279	3	t_u_les
tulles	6	32	1889	3	t_ulles
tunes	5	53	3219	3	t_u_nes
tuques	15	35	837	3	t_uques
turfed	10	31	1096	3	t_urfed
turfier	10	24	979	3	turfier
turfiest	11	24	1013	3	turfiest
turfless	11	3	553	3	turfless
turfmen	12	4	416	3	turfmen
turfs	8	46	2044	3	t_urf_s
turtles	7	29	1434	3	turtles
turves	9	42	1269	3	t_urves
tushes	9	43	1947	3	t_ushes
tusses	6	49	2124	3	t_usses
tutees	6	5	1455	3	t_utees
tuxes	12	43	1604	3	t_u_xes
uruses	6	36	1650	3	uru_ses

Search took 8 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	134027	0.393	454684.5
2	DLD Change Limit	134027	289	7.250	18486.5
3	Display Results	289	289	0.106	2726.4
	(SQL Overall)	178691	289	7.749	23059.9