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

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

325 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
foetid	10	5	1051	(None)
fetid	9	37	1598	1	f_etid
felid	9	47	1717	2	f_elid
feted	9	44	2093	2	f_eted
foetal	9	3	1188	2	foetal
foetor	9	3	956	2	foetor
foetus	9	5	852	2	foetus
footed	10	44	1862	2	footed
footie	9	47	1814	2	footie
forbid	12	33	1243	2	forbid
fordid	11	35	1205	2	fordid
foredid	12	3	850	2	foredid
fortis	9	54	1861	2	fortis
noetic	8	5	1404	2	noetic
ootid	6	14	1670	2	_ootid
poetic	10	4	1684	2	poetic
acetic	10	3	1450	3	acetic
acetin	8	3	1469	3	acetin
aloetic	9	3	1318	3	aloetic
aortic	8	3	1661	3	aortic
betide	9	51	1597	3	_betide
boated	9	42	2197	3	boated
boleti	8	4	1340	3	boleti_
bolted	9	46	1780	3	bolted
booted	9	48	2273	3	booted
bootie	8	54	2116	3	bootie
bovid	11	10	1162	3	bo_vid
cebid	10	43	1408	3	_cebid
clerid	9	3	1241	3	clerid
coated	9	49	2704	3	coated
coati	7	56	2464	3	coati_
coatis	8	51	2260	3	coatis
coccid	10	29	1074	3	coccid
coed	7	71	4054	3	coe__d
coedit	9	3	1624	3	coedit
cometic	13	12	1572	3	cometic
conoid	9	8	1888	3	conoid
cootie	8	42	2309	3	cootie
cortin	8	24	2315	3	cortin
corvid	12	3	1047	3	corvid
cosmid	11	8	1064	3	cosmid
costed	9	56	2312	3	costed
coted	8	50	3385	3	co_ted
coveted	13	30	1152	3	coveted
cretic	10	28	1628	3	cretic
cretin	8	29	1791	3	cretin
dieted	8	31	1549	3	dieted
doated	8	41	1818	3	doated
docetic	12	3	991	3	docetic
doeth	9	4	1198	3	doet_h
doited	8	50	1663	3	doited
doted	7	52	2707	3	do_ted
dotted	8	47	1752	3	dotted
dueted	8	41	1359	3	dueted
emetic	10	6	1445	3	emetic
emetin	8	6	1346	3	emetin
etic	6	61	2395	3	__etic
eyelid	10	3	844	3	eyelid
faceted	13	50	956	3	faceted
factoid	13	3	869	3	factoid
faerie	9	35	1468	3	faerie
fantod	10	20	1003	3	fantod
farted	10	51	2178	3	farted
fasted	10	53	2095	3	fasted
fated	9	56	3213	3	f_ated
fatted	10	54	1984	3	fatted
fed	7	65	4835	3	f_e__d
feed	8	45	3890	3	f_e_ed
feet	7	53	5221	3	feet__
feezed	19	43	999	3	feezed
felids	10	31	1162	3	f_elids
felted	10	37	1465	3	felted
fend	8	48	3297	3	f_e_nd
feod	8	155	2300	3	f_e_od
feria	8	59	2271	3	f_eria
fervid	13	3	751	3	fervid
fet	6	64	7163	3	f_et__
feta	7	65	2890	3	f_et_a
fetal	8	56	2337	3	f_etal
fetas	8	56	2440	3	f_etas
fetch	13	49	1347	3	f_etch
fete	7	57	3492	3	f_et_e
fetes	8	56	3014	3	f_etes
fetial	9	57	1619	3	f_etial
fetich	14	7	969	3	f_etich
fetidly	14	3	501	3	f_etidly
feting	10	44	1779	3	f_eting
fetish	12	3	1037	3	f_etish
fetor	8	12	1453	3	f_etor
fets	7	53	4594	3	f_et_s
fetted	10	48	1789	3	fetted
fetus	8	58	1654	3	f_etus
feud	8	65	2302	3	f_e_ud
feued	9	47	1566	3	f_eued
fid	7	68	4769	3	f___id
field	9	50	1532	3	fie_ld
fiend	9	53	1298	3	fie_nd
fileted	11	5	909	3	fileted
fisted	10	42	1870	3	fisted
fistic	11	8	1257	3	fistic
fitted	10	47	1666	3	fitted
fjeld	16	46	558	3	fje_ld
fled	8	54	2977	3	fle__d
fleeted	11	33	1023	3	fleeted
fletch	14	38	819	3	fletch
flexed	17	41	909	3	flexed
fleyed	13	40	881	3	fleyed
flited	10	46	1658	3	flited
floated	11	33	1270	3	floated
florid	10	3	1145	3	florid
flouted	11	32	1081	3	flouted
fluid	9	40	1396	3	f_luid
fluted	10	49	1716	3	fluted
flyted	13	37	877	3	flyted
foaled	10	45	1596	3	foaled
foamed	12	60	1440	3	foamed
fobbed	14	41	1261	3	fobbed
foci	9	45	2101	3	fo_ci_
foe	6	63	5081	3	foe___
foehn	11	23	632	3	foe_hn
foehns	12	20	497	3	foehns
foeman	11	3	1123	3	foeman
foemen	11	3	1052	3	foemen
foes	7	65	4344	3	foe__s
foetors	10	3	976	3	foetors
fogged	12	55	1837	3	fogged
fogie	9	67	1900	3	fo_gie
foil	7	64	3391	3	fo__il
foiled	10	46	1840	3	foiled
foin	7	72	3156	3	fo__in
foined	10	59	1501	3	foined
foisted	11	32	1060	3	foisted
fold	8	65	2894	3	fo__ld
folded	11	42	1279	3	folded
folia	8	36	1893	3	fo_lia
folic	10	53	1932	3	fo_lic
folio	8	38	2088	3	fo_lio
folkie	13	36	961	3	folkie
follis	9	31	1390	3	follis
fomented	14	3	780	3	fomented
fomite	11	33	1407	3	fomite
fond	8	63	3095	3	fo__nd
fonded	11	57	1704	3	fonded
font	7	71	4375	3	font__
fontal	9	3	1314	3	fontal
fontina	10	3	863	3	fontina
fonts	8	61	2475	3	font_s
food	8	68	3057	3	fo__od
foodie	10	44	1384	3	foodie
fooled	10	43	1782	3	fooled
foot	7	62	4801	3	foot__
footer	9	43	2077	3	footer
footier	10	41	1511	3	footier
footies	10	37	2154	3	footies
footing	11	50	1759	3	footing
footle	9	39	1438	3	footle
footled	11	36	1076	3	footled
footpad	13	4	390	3	footpad
foots	8	55	2828	3	foot_s
footsie	10	4	765	3	footsie
footsy	12	58	793	3	footsy
footy	11	58	2053	3	foot_y
fopped	14	40	1267	3	fopped
forbad	12	27	1050	3	forbad
forbids	13	26	826	3	forbids
forced	12	63	1652	3	forced
ford	8	68	3549	3	fo__rd
forded	11	50	2039	3	forded
foresaid	12	4	780	3	foresaid
foreside	12	3	1030	3	foreside
forested	12	3	1246	3	forested
foretime	13	4	821	3	foretime
foretold	12	5	649	3	foretold
foretop	12	11	789	3	foretop
forged	11	55	1932	3	forged
forked	14	52	1714	3	forked
formed	12	50	2117	3	formed
formic	13	3	1045	3	formic
fornix	16	3	603	3	fornix
forrit	9	19	1662	3	forrit
fort	7	64	5644	3	fort__
forte	8	61	3146	3	fort_e
fortes	9	53	2718	3	fortes
forth	11	62	2267	3	fort_h
forties	10	43	2386	3	forties
fortify	16	3	652	3	fortify
forts	8	60	3445	3	fort_s
forty	11	48	2427	3	fort_y
fossil	9	37	935	3	fossil
foster	9	43	2222	3	foster
fouette	10	3	821	3	fouette
fouled	10	43	1597	3	fouled
found	9	49	1784	3	fo_und
foveated	15	3	629	3	foveated
fowled	13	39	1410	3	fowled
foxed	16	51	1521	3	fo_xed
foxtail	17	4	538	3	foxtail
freed	9	52	2354	3	fre_ed
fremd	11	50	1032	3	fre_md
fret	7	58	4504	3	fret__
frets	8	55	2340	3	fret_s
fretted	11	34	1185	3	fretted
fretty	12	4	922	3	fretty
frigid	11	3	692	3	frigid
fronted	11	40	1127	3	fronted
frosted	11	32	1188	3	frosted
fucoid	12	3	789	3	fucoid
fueled	10	49	1360	3	fueled
fulgid	11	3	704	3	fulgid
fustic	11	9	1063	3	fustic
gelid	7	49	1698	3	_gelid
geoid	7	42	1576	3	_geoid
godetia	9	4	535	3	godetia
hoed	8	78	3798	3	hoe__d
hogtie	10	27	1177	3	hogtie
hogtied	12	22	665	3	hogtied
hooted	10	44	2266	3	hooted
horrid	10	3	1156	3	horrid
hosted	10	50	2034	3	hosted
hotted	10	43	1994	3	hotted
hottie	9	25	1438	3	hottie
iodid	7	43	1553	3	io_did
jerid	13	23	1642	3	_jerid
jolted	14	35	1063	3	jolted
jotted	14	36	1517	3	jotted
lofted	10	38	1189	3	lofted
loid	5	55	3149	3	lo__id
looted	7	44	2111	3	looted
loti	4	64	3184	3	lo_ti_
lotic	7	64	2067	3	lo_tic
lotted	7	42	2240	3	lotted
louted	7	49	2069	3	louted
luetic	8	3	1038	3	luetic
mantid	9	38	2038	3	mantid
meted	8	54	2443	3	_meted
metis	7	50	2590	3	_metis
moated	9	48	1900	3	moated
molted	9	42	1747	3	molted
mooted	9	41	2037	3	mooted
morbid	11	25	1146	3	morbid
motif	10	5	1968	3	mo_tif
nitid	6	18	1783	3	_nitid
noctuid	10	6	438	3	noctuid
noesis	6	3	1144	3	noesis
noted	6	51	2384	3	no_ted
octad	8	15	1065	3	_octad
ontic	7	44	1857	3	_ontic
ootids	7	11	1035	3	_ootids
opted	8	49	1427	3	_opted
optic	9	37	1518	3	_optic
ostia	5	23	1558	3	_ostia
otic	6	66	2482	3	_o_tic
outbid	9	14	1186	3	_outbid
outdid	8	12	1092	3	_outdid
outed	6	54	2906	3	_outed
ovoid	9	48	1102	3	_ovoid
oxid	12	8	1548	3	_o_xid
peptid	11	27	1237	3	peptid
petit	7	43	3265	3	_petit
poet	6	55	5290	3	poet__
poetics	11	3	1207	3	poetics
poetise	9	3	1404	3	poetise
poetised	11	3	852	3	poetised
poetize	18	3	1077	3	poetize
poetized	20	3	798	3	poetized
poetry	11	3	938	3	poetry
poets	7	60	2444	3	poet_s
pongid	10	41	1158	3	pongid
pontil	8	3	1546	3	pontil
ported	9	42	2324	3	ported
posted	9	37	2249	3	posted
postie	8	41	2396	3	postie
postin	8	35	2103	3	postin
potted	9	46	2401	3	potted
pouted	9	40	2139	3	pouted
prebid	11	35	1284	3	prebid
proteid	10	35	1367	3	proteid
rebid	8	51	2136	3	_rebid
redid	7	49	2239	3	_redid
resid	6	41	2409	3	_resid
retia	5	53	2611	3	_retia
retie	5	57	3530	3	_retie
retied	7	59	2498	3	_retied
rooted	7	54	2400	3	rooted
roti	4	63	3293	3	ro_ti_
rotis	5	63	2706	3	ro_tis
rotted	7	45	2443	3	rotted
routed	7	56	2433	3	routed
softie	9	33	1248	3	softie
solid	6	50	2508	3	so_lid
sooted	7	39	2259	3	sooted
sordid	8	34	1116	3	sordid
sorted	7	45	2371	3	sorted
sortie	6	36	2199	3	sortie
sortied	8	33	1410	3	sortied
sotted	7	41	2140	3	sotted
teiid	6	3	1253	3	_teiid
tepid	8	3	1431	3	_tepid
thetic	11	4	1289	3	thetic
toed	5	61	3704	3	toe__d
toited	7	40	1675	3	toited
toluid	7	3	821	3	toluid
tomtit	8	4	1385	3	tomtit
tonetic	9	3	1343	3	tonetic
tooted	7	46	2012	3	tooted
toroid	7	4	1601	3	toroid
torpid	9	3	1091	3	torpid
torrid	7	3	1185	3	torrid
toted	6	49	2948	3	to_ted
totted	7	43	1995	3	totted
touted	7	44	1974	3	touted
toxoid	14	3	815	3	toxoid
trepid	9	3	1008	3	trepid
uretic	8	29	1435	3	uretic
void	8	62	2056	3	vo__id
volti	8	49	1596	3	volti_
voted	9	39	1914	3	vo_ted
weeted	10	39	1379	3	weeted
wonted	10	32	1328	3	wonted
wotted	10	41	1571	3	wotted
yeti	7	58	2321	3	_yeti_
yetis	8	54	1839	3	_yetis
zoecia	17	3	555	3	zoecia
zoftig	19	3	297	3	zoftig
zooid	15	3	1210	3	zo_oid

Search took 7 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.373	479064.3
2	DLD Change Limit	112716	325	5.563	20261.7
3	Display Results	325	325	0.110	2954.5
	(SQL Overall)	178691	325	6.046	29555.2