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

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

416 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
haffet	15	3	1170	(None)
haffets	16	3	605	1	haffets
haffit	15	3	853	1	haffit
affect	14	4	890	2	_affect
baffed	15	48	1217	2	baffed
buffet	14	31	1378	2	buffet
chaffed	19	38	770	2	chaffed
chaffer	18	38	947	2	chaffer
daffed	14	42	949	2	daffed
gaffe	12	41	1165	2	gaffe_
gaffed	14	42	1020	2	gaffed
gaffer	13	43	1013	2	gaffer
gaffes	13	48	1110	2	gaffes
haet	7	56	5950	2	ha__et
haffits	16	3	619	2	haffits
haft	10	59	4184	2	ha_f_t
hafted	13	47	1383	2	hafted
hafter	12	48	1588	2	hafter
hamlet	11	37	2279	2	hamlet
haslet	9	32	2271	2	haslet
huffed	16	37	1015	2	huffed
naffed	13	40	833	2	naffed
taffeta	13	4	326	2	taffeta
tuffet	12	26	1208	2	tuffet
waffed	16	45	979	2	waffed
whiffet	19	6	534	2	whiffet
yaffed	16	45	732	2	yaffed
zaffer	21	39	715	2	zaffer
abet	6	105	4794	3	_a_bet
aff	9	55	3761	3	_aff__
affects	15	3	539	3	_affects
affix	18	3	600	3	_affix
afoot	8	4	2011	3	_afoot
afreet	9	3	1515	3	_afreet
afrit	8	3	2317	3	_afrit
aft	6	68	4901	3	_a_f_t
after	8	57	1979	3	_after
aglet	6	55	3414	3	_aglet
armet	7	67	3945	3	_armet
asset	5	59	3226	3	_asset
baff	12	46	3227	3	baff__
baffies	15	36	1294	3	baffies
baffle	14	39	987	3	baffle
baffled	16	41	806	3	baffled
baffler	15	41	811	3	baffler
baffles	15	37	1068	3	baffles
baffs	13	47	1805	3	baff_s
baffy	16	55	1192	3	baff_y
baguet	9	3	1610	3	baguet
ballet	8	47	3397	3	ballet
bannet	8	49	2533	3	bannet
barbet	10	44	2788	3	barbet
barfed	12	54	1638	3	barfed
barret	8	49	3048	3	barret
basket	12	57	2291	3	basket
basset	8	52	2538	3	basset
befret	11	3	1596	3	befret
biffed	15	44	988	3	biffed
boffed	15	36	948	3	boffed
buffed	15	43	1314	3	buffed
buffer	14	45	1268	3	buffer
buffest	15	29	864	3	buffest
buffets	15	31	759	3	buffets
cablet	10	44	2946	3	cablet
cachet	13	45	2641	3	cachet
cadet	8	53	3934	3	ca_det
cafe	9	52	3032	3	ca_fe_
cafes	10	64	2692	3	ca_fes
caff	12	56	3167	3	caff__
caffein	15	3	533	3	caffein
caffs	13	54	1737	3	caff_s
callet	8	45	3676	3	callet
camlet	10	44	2658	3	camlet
caplet	10	42	2681	3	caplet
caret	7	53	6056	3	ca_ret
carnet	8	47	3287	3	carnet
carpet	10	45	3009	3	carpet
casket	12	48	2099	3	casket
chafe	13	51	1735	3	cha_fe_
chafed	15	48	1391	3	cha_fed
chafer	14	47	1457	3	cha_fer
chafes	14	50	1791	3	cha_fes
chaff	16	50	1628	3	chaff__
chaffers	19	37	800	3	chaffers
chaffier	19	3	547	3	chaffier
chaffiest	20	4	542	3	chaffiest
chaffs	17	45	961	3	chaff_s
chaffy	20	45	647	3	chaff_y
chalet	11	38	2599	3	cha_let
chamfer	17	39	986	3	chamfer
chaplet	14	5	1225	3	chaplet
chaufer	15	34	794	3	chaufer
chauffer	19	26	379	3	chauffer
cheffed	19	33	586	3	cheffed
chuffed	19	31	664	3	chuffed
chuffer	18	33	714	3	chuffer
chuffest	19	4	419	3	chuffest
coffee	14	41	1374	3	coffee
coffer	14	41	1286	3	coffer
coffret	15	3	1007	3	coffret
cuffed	15	43	1121	3	cuffed
daff	11	52	2968	3	daff__
daffier	14	5	783	3	daffier
daffiest	15	3	784	3	daffiest
daffs	12	51	1642	3	daff_s
daffy	15	55	1028	3	daff_y
daft	8	55	3725	3	da_f_t
dafter	10	48	1334	3	dafter
daftest	11	24	894	3	daftest
deffer	13	44	1130	3	deffer
deffest	14	30	880	3	deffest
differ	13	39	1084	3	differ
doffed	14	42	850	3	doffed
doffer	13	39	1135	3	doffer
duffel	13	40	775	3	duffel
duffer	13	47	1166	3	duffer
eaglet	7	37	2258	3	eaglet
effect	14	3	744	3	_effect
effete	12	3	518	3	_effete
facet	10	60	3852	3	fa_cet
fanjet	16	3	1139	3	fanjet
farfel	12	43	1043	3	farfel
faucet	11	58	1655	3	faucet
feet	7	53	5221	3	__feet
fet	6	64	7163	3	___fet
fret	7	58	4504	3	__fret
gabfest	13	3	645	3	gabfest
gadget	9	36	1618	3	gadget
gaff	11	48	2815	3	gaff__
gaffers	14	42	871	3	gaffers
gaffs	12	49	1465	3	gaff_s
gallet	7	36	3085	3	gallet
gannet	7	43	2185	3	gannet
garget	8	43	2727	3	garget
garnet	7	39	2841	3	garnet
garret	7	44	2655	3	garret
gasket	11	44	1725	3	gasket
gauffer	14	7	442	3	gauffer
goffer	13	40	951	3	goffer
haaf	10	62	2773	3	haaf__
haafs	11	57	1116	3	haaf_s
habit	10	30	2702	3	ha_bit
hacek	14	54	1184	3	ha_cek
hacked	16	49	2351	3	hacked
hackee	15	49	2183	3	hackee
hacker	15	48	2269	3	hacker
haddest	12	27	1199	3	haddest
hade	8	54	4019	3	ha_de_
haded	10	52	2762	3	ha_ded
hades	9	60	3511	3	ha_des
hadjee	17	41	1182	3	hadjee
hadjes	17	52	1040	3	hadjes
hadst	9	32	2022	3	ha_dst
hae	6	73	6400	3	ha__e_
haed	8	63	3858	3	ha__ed
haem	9	57	3098	3	ha__em
haen	7	62	2945	3	ha__en
haeres	9	40	1703	3	haeres
haes	7	76	5102	3	ha__es
haets	8	65	2512	3	ha__ets
hafiz	20	6	1121	3	ha_fiz
hafizes	22	3	598	3	hafizes
hafters	13	46	1433	3	hafters
hafts	11	62	1946	3	ha_fts
hagbut	12	7	892	3	hagbut
hagged	12	43	1770	3	hagged
hailed	10	41	2274	3	hailed
hailer	9	47	2034	3	hailer
haint	8	54	3632	3	ha_int
haired	10	51	1717	3	haired
hairnet	10	9	1170	3	hairnet
hajes	15	54	2094	3	ha_jes
hajjes	15	48	524	3	hajjes
hake	11	56	3784	3	ha_ke_
hakeem	15	40	738	3	hakeem
hakes	12	60	3430	3	ha_kes
halbert	12	3	1450	3	halbert
hale	7	60	5283	3	ha_le_
haled	9	53	3582	3	ha_led
haler	8	50	3352	3	ha_ler
hales	8	54	4984	3	ha_les
halest	9	48	2327	3	halest
half	10	62	3845	3	half__
halite	9	36	2423	3	halite
hallel	9	35	1409	3	hallel
hallot	9	54	2678	3	hallot
haloed	10	47	1760	3	haloed
haloes	9	46	2386	3	haloes
halt	7	60	5630	3	ha__lt
halted	10	50	1960	3	halted
halter	9	44	2088	3	halter
halve	11	48	1892	3	halve_
halved	13	48	1390	3	halved
halves	12	47	1709	3	halves
hamate	11	33	1983	3	hamate
hame	9	70	4313	3	ha_me_
hames	10	61	3870	3	ha_mes
hamlets	12	32	1140	3	hamlets
hammed	14	41	1697	3	hammed
hammer	13	81	2003	3	hammer
hamper	13	45	1865	3	hamper
hance	10	54	2415	3	hance_
hances	11	56	2128	3	hances
handed	11	49	1998	3	handed
hander	10	45	2643	3	hander
handset	11	30	1682	3	handset
hanged	11	42	2239	3	hanged
hanger	10	40	2325	3	hanger
hanked	14	42	2060	3	hanked
hanker	13	46	2209	3	hanker
hanse	8	57	2279	3	hanse_
hansel	9	52	1437	3	hansel
hanses	9	50	2263	3	hanses
hant	7	54	6159	3	ha__nt
hanted	10	41	2431	3	hanted
haole	8	48	2008	3	haole_
haoles	9	49	1980	3	haoles
happed	14	48	2010	3	happed
happen	13	48	1219	3	happen
hapten	11	53	1298	3	hapten
harden	10	57	1853	3	harden
harder	10	50	2240	3	harder
hardest	11	31	1841	3	hardest
hardset	11	34	1583	3	hardset
hare	7	62	5573	3	ha_re_
hared	9	57	4218	3	ha_red
hareem	11	43	1206	3	hareem
harem	10	49	2445	3	ha_rem
hares	8	62	5554	3	ha_res
harked	14	54	2255	3	harked
harken	13	51	1634	3	harken
harlot	9	44	2280	3	harlot
harmed	12	52	1883	3	harmed
harmer	11	47	1955	3	harmer
harped	12	44	1840	3	harped
harper	11	50	1840	3	harper
harslet	10	3	1565	3	harslet
hart	7	68	6577	3	ha__rt
harvest	13	21	1275	3	harvest
hashed	13	60	2194	3	hashed
hashes	12	50	2480	3	hashes
haslets	10	25	1086	3	haslets
hasped	12	50	1444	3	hasped
hassel	9	56	1421	3	hassel
hast	7	62	5948	3	ha__st
haste	8	59	2786	3	haste_
hasted	10	51	2528	3	hasted
hasten	9	57	1856	3	hasten
hastes	9	57	2707	3	hastes
hat	6	72	8996	3	ha___t
hatchet	15	33	1756	3	hatchet
hate	7	84	5017	3	ha_te_
hated	9	57	3402	3	ha_ted
hater	8	50	3475	3	ha_ter
hates	8	67	4257	3	ha_tes
hatful	12	10	874	3	hatful
hatred	10	48	1433	3	hatred
hatted	10	49	2151	3	hatted
hatter	9	47	2487	3	hatter
hauled	10	44	1521	3	hauled
hauler	9	50	1512	3	hauler
haunt	8	52	2913	3	ha_unt
hausen	9	6	1038	3	hausen
haut	7	59	4973	3	ha__ut
haute	8	95	2161	3	haute_
have	10	61	3707	3	ha_ve_
haven	11	47	1853	3	ha_ven
haver	11	51	2446	3	ha_ver
haves	11	60	3487	3	ha_ves
hawed	12	60	2542	3	ha_wed
hawked	17	47	1267	3	hawked
hawker	16	48	1266	3	hawker
hawkey	19	50	763	3	hawkey
hawse	11	60	1512	3	hawse_
hawser	12	59	1084	3	hawser
hawses	12	51	1399	3	hawses
hayed	12	58	2201	3	ha_yed
hayer	11	46	2024	3	ha_yer
hayey	14	48	1253	3	ha_yey
haze	16	48	3339	3	ha_ze_
hazed	18	52	2220	3	ha_zed
hazel	17	64	1481	3	ha_zel
hazer	17	48	2023	3	ha_zer
hazes	17	49	2832	3	ha_zes
hazier	18	47	1240	3	hazier
haziest	19	33	1301	3	haziest
hazmat	20	3	1226	3	hazmat
headset	11	3	1260	3	headset
heft	10	67	3629	3	h_ef_t
hefted	13	49	1142	3	hefted
hefter	12	43	1392	3	hefter
heifer	12	3	820	3	heifer
helmet	11	37	1893	3	helmet
het	6	76	7431	3	h___et
hogget	11	47	1576	3	hogget
hoofed	13	46	1489	3	hoofed
hoofer	12	40	1495	3	hoofer
hornet	9	49	2643	3	hornet
howlet	12	35	1834	3	howlet
huff	13	56	2384	3	huff__
huffier	16	3	749	3	huffier
huffiest	17	5	720	3	huffiest
huffs	14	45	1474	3	huff_s
huffy	17	48	1023	3	huff_y
jacket	19	47	2067	3	jacket
kaffir	16	34	530	3	kaffir
labret	8	3	2022	3	labret
lancet	8	42	2357	3	lancet
lappet	10	38	1773	3	lappet
leaflet	10	19	974	3	leaflet
luffed	13	38	1082	3	luffed
maffia	14	32	720	3	maffia
magnet	9	3	2066	3	magnet
malfed	12	36	976	3	malfed
mallet	8	44	3305	3	mallet
mammet	9	43	1925	3	mammet
market	12	32	2604	3	market
maumet	10	35	1888	3	maumet
miffed	15	39	871	3	miffed
muffed	15	42	1059	3	muffed
naff	10	51	2893	3	naff__
naffs	11	62	1396	3	naff_s
niffer	12	37	844	3	niffer
offed	12	35	916	3	_offed
offer	11	43	1138	3	_offer
offset	12	3	837	3	offset
packet	14	47	2650	3	packet
palet	7	46	5080	3	pa_let
pallet	8	42	3265	3	pallet
parget	9	45	2939	3	parget
pfft	12	3	1188	3	_pff_t
piaffe	14	9	491	3	piaffe_
piaffed	16	9	375	3	piaffed
piaffer	15	10	444	3	piaffer
piaffes	15	11	505	3	piaffes
puffed	15	35	1060	3	puffed
puffer	14	46	1073	3	puffer
quaffed	23	3	425	3	quaffed
quaffer	22	3	513	3	quaffer
rabbet	10	38	1865	3	rabbet
rachet	11	50	2897	3	rachet
racket	12	52	2942	3	racket
raff	10	49	3304	3	raff__
raffia	12	28	770	3	raffia
raffle	12	39	1070	3	raffle
raffled	14	42	908	3	raffled
raffler	13	33	922	3	raffler
raffles	13	36	1184	3	raffles
raffs	11	50	1752	3	raff_s
raft	7	62	4591	3	ra_f_t
rafted	10	47	1470	3	rafted
rafter	9	45	1758	3	rafter
ramet	7	57	4314	3	ra_met
ramjet	15	3	1154	3	ramjet
reffed	13	47	1251	3	reffed
reflet	9	40	2423	3	reflet
riffed	13	38	1156	3	riffed
ruffe	11	47	1381	3	ruffe_
ruffed	13	43	1274	3	ruffed
ruffes	12	41	1242	3	ruffes
sachet	11	47	2577	3	sachet
safe	7	59	3095	3	sa_fe_
safer	8	47	2181	3	sa_fer
safes	8	52	2672	3	sa_fes
safest	9	50	1660	3	safest
safety	12	20	691	3	sa_fety
sallet	6	37	3454	3	sallet
samlet	8	41	2656	3	samlet
shaft	11	57	2527	3	sha_f_t
shafted	14	28	881	3	shafted
soffit	12	3	788	3	soffit
staffed	14	29	828	3	staffed
staffer	13	29	909	3	staffer
suffer	12	43	1451	3	suffer
tablet	8	42	2764	3	tablet
tacet	7	58	4002	3	ta_cet
tacket	12	46	2749	3	tacket
taffetas	14	4	272	3	taffetas
taffia	12	28	690	3	taffia
taffies	13	30	1269	3	taffies
taffy	14	51	1082	3	taff_y
tappet	10	38	2011	3	tappet
target	7	50	2890	3	target
tasset	6	59	2531	3	tasset
tiffed	13	36	839	3	tiffed
toffee	12	33	1101	3	toffee
tuffets	13	26	652	3	tuffets
valet	8	43	3787	3	va_let
varlet	9	4	2350	3	varlet
wadset	10	3	1430	3	wadset
wafer	11	44	1764	3	wa_fer
waff	13	42	2804	3	waff__
waffie	15	33	856	3	waffie
waffies	16	36	1144	3	waffies
waffle	15	36	918	3	waffle
waffled	17	35	752	3	waffled
waffler	16	37	778	3	waffler
waffles	16	32	998	3	waffles
waffly	18	30	543	3	waffly
waffs	14	63	1547	3	waff_s
waft	10	61	3900	3	wa_f_t
wafted	13	40	1214	3	wafted
wafter	12	41	1461	3	wafter
waifed	13	40	1103	3	waifed
wallet	9	33	2709	3	wallet
wharfed	17	3	441	3	wharfed
whiffed	20	6	447	3	whiffed
whiffer	19	10	532	3	whiffer
whiffets	20	7	252	3	whiffets
yaff	13	53	2426	3	yaff__
yaffs	14	53	1112	3	yaff_s
zaffar	21	38	504	3	zaffar
zaffers	22	38	677	3	zaffers
zaffir	21	39	551	3	zaffir
zaffre	21	35	466	3	zaffre
zaffres	22	32	499	3	zaffres

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.376	475242.0
2	DLD Change Limit	112716	416	4.860	23192.6
3	Display Results	416	416	0.123	3382.1
	(SQL Overall)	178691	416	5.359	33344.1