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

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

348 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
foetor	9	3	956	(None)
fetor	8	12	1453	1	f_etor
foetors	10	3	976	1	foetors
doctor	9	3	899	2	doctor
factor	11	9	1145	2	factor
fetors	9	10	1447	2	f_etors
flexor	16	3	450	2	flexor
foetal	9	3	1188	2	foetal
foetid	10	5	1051	2	foetid
foetus	9	5	852	2	foetus
footer	9	43	2077	2	footer
foretop	12	11	789	2	foretop
foster	9	43	2222	2	foster
motor	7	53	1729	2	mo_tor
pretor	8	3	1575	2	pretor
rhetor	9	3	806	2	rhetor
rotor	5	55	1973	2	ro_tor
abator	8	45	1271	3	abator
abettor	9	5	619	3	abettor
actor	7	11	1607	3	_actor
beton	7	60	2206	3	_beton
bettor	8	36	1222	3	bettor
bevor	10	15	1081	3	_bevor
boater	8	46	2209	3	boater
bolter	8	39	2075	3	bolter
boor	6	61	3068	3	bo__or
boston	8	5	1304	3	boston
bottom	10	4	872	3	bottom
bouton	8	3	1153	3	bouton
cantor	8	56	2152	3	cantor
captor	10	49	1460	3	captor
castor	8	44	1853	3	castor
coactor	11	3	912	3	coactor
coater	8	43	2957	3	coater
codebtor	13	4	397	3	codebtor
coeditor	11	4	572	3	coeditor
coelom	10	3	1043	3	coelom
color	7	61	2374	3	co_lor
colter	8	46	2509	3	colter
condor	9	46	1697	3	condor
conto	7	60	2717	3	conto_
contort	9	14	2234	3	contort
contos	8	49	2323	3	contos
contour	9	3	997	3	contour
cooter	8	51	2861	3	cooter
copter	10	98	2201	3	copter
costar	8	55	1861	3	costar
coster	8	43	3129	3	coster
cottar	8	46	1381	3	cottar
cotter	8	49	2667	3	cotter
cotton	8	3	1299	3	cotton
couter	8	49	3022	3	couter
coveter	12	29	1206	3	coveter
creator	9	37	1444	3	creator
debtor	9	3	833	3	debtor
decor	8	47	1757	3	_decor
deter	6	50	2804	3	_deter
detour	7	7	819	3	_detour
detox	13	3	1095	3	_detox
dieter	7	35	1677	3	dieter
doctors	10	3	999	3	doctors
doer	5	77	3470	3	doe__r
doeth	9	4	1198	3	doet_h
dolor	6	76	1796	3	do_lor
donator	8	3	1026	3	donator
donor	6	44	1819	3	do_nor
door	5	69	2851	3	do__or
doter	6	54	2862	3	do_ter
dotter	7	44	1934	3	dotter
editor	7	3	866	3	editor
effector	16	4	487	3	effector
ejector	16	37	860	3	ejector
elector	9	33	1325	3	elector
erector	9	35	1381	3	erector
evertor	10	3	872	3	evertor
factors	12	9	1212	3	factors
factory	15	10	834	3	factory
faitour	10	3	488	3	faitour
falter	9	45	1905	3	falter
fantod	10	20	1003	3	fantod
fantom	11	21	1080	3	fantom
faster	9	46	2577	3	faster
fatter	9	45	2321	3	fatter
favor	11	47	1245	3	f_avor
fear	7	53	3779	3	f_e_ar
feater	9	52	2405	3	feater
fedora	10	3	859	3	f_edora
feeder	10	35	1384	3	feeder
feeler	9	32	1517	3	feeler
feet	7	53	5221	3	feet__
felon	8	46	1929	3	f_elon
femora	11	4	958	3	f_emora
femur	10	3	868	3	f_emur
feod	8	155	2300	3	f_e_od
feoffor	12	4	178	3	feoffor
fer	6	66	4612	3	f_e__r
feretory	14	4	751	3	feretory
fervor	12	3	564	3	fervor
fester	9	47	2351	3	fester
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
feted	9	44	2093	3	f_eted
fetes	8	56	3014	3	f_etes
fetid	9	37	1598	3	f_etid
fets	7	53	4594	3	f_et_s
fetter	9	41	2038	3	fetter
fetus	8	58	1654	3	f_etus
feuar	8	3	1024	3	f_euar
fever	11	56	1795	3	f_ever
fewer	11	52	1612	3	f_ewer
feyer	11	50	1452	3	f_eyer
filter	9	45	1763	3	filter
fitter	9	41	2003	3	fitter
flavor	12	3	666	3	flavor
fleer	8	60	2077	3	fle_er
fleeter	10	32	1036	3	fleeter
fletch	14	38	819	3	fletch
flexors	17	3	477	3	flexors
floater	10	44	1335	3	floater
floor	8	42	1523	3	f_loor
flouter	10	43	1134	3	flouter
fluor	8	45	1277	3	f_luor
fluter	9	53	1686	3	fluter
foamer	11	47	1431	3	foamer
fodder	11	47	1211	3	fodder
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
fogbow	15	4	478	3	fogbow
fogdog	12	3	422	3	fogdog
fogger	11	44	1478	3	fogger
foghorn	14	4	543	3	foghorn
foison	9	4	893	3	foison
folder	10	43	1754	3	folder
foliar	9	32	1097	3	foliar
folio	8	38	2088	3	folio_
folios	9	39	1546	3	folios
follow	12	40	1035	3	follow
fomenter	13	3	926	3	fomenter
fonder	10	41	2006	3	fonder
font	7	71	4375	3	font__
fontal	9	3	1314	3	fontal
fonts	8	61	2475	3	font_s
food	8	68	3057	3	fo__od
fool	7	53	3059	3	fo__ol
foot	7	62	4801	3	fo__ot
footboy	15	4	491	3	footboy
footed	10	44	1862	3	footed
footers	10	46	1833	3	footers
footie	9	47	1814	3	footie
footier	10	41	1511	3	footier
footle	9	39	1438	3	footle
footler	10	40	1187	3	footler
foots	8	55	2828	3	foot_s
footsore	11	4	606	3	footsore
footsy	12	58	793	3	footsy
footwork	18	4	581	3	footwork
footworn	14	4	516	3	footworn
footy	11	58	2053	3	foot_y
for	6	69	5207	3	f___or
forbore	12	24	967	3	forbore
forcer	11	49	1734	3	forcer
fordo	9	72	1865	3	fordo_
foredo	10	5	1082	3	foredo_
forego	10	3	890	3	forego_
foregoer	12	3	725	3	foregoer
forester	11	3	1367	3	forester
foretold	12	5	649	3	foretold
foretops	13	13	748	3	foretops
forever	13	3	895	3	forever
foreword	15	11	896	3	foreword
foreworn	14	10	886	3	foreworn
forger	10	48	2077	3	forger
forgo	9	44	1833	3	forgo_
forgoer	11	3	769	3	forgoer
forgot	10	43	1813	3	forgot
forker	13	47	1790	3	forker
forlorn	10	9	642	3	forlorn
former	11	42	2140	3	former
formol	11	29	1033	3	formol
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
fortis	9	54	1861	3	fortis
forts	8	60	3445	3	fort_s
forty	11	48	2427	3	fort_y
forworn	13	10	779	3	forworn
fosters	10	42	2010	3	fosters
fouette	10	3	821	3	fouette
fouler	9	36	1490	3	fouler
four	7	62	2686	3	fo__ur
fowler	12	37	1258	3	fowler
foxier	16	39	1003	3	foxier
foxtrot	17	4	630	3	foxtrot
foyer	11	64	1655	3	fo_yer
fozier	18	37	1066	3	fozier
frater	9	45	2059	3	frater
freer	8	60	2124	3	fre_er
fret	7	58	4504	3	fret__
frets	8	55	2340	3	fret_s
fretter	10	34	1275	3	fretter
fretty	12	4	922	3	fretty
fretwork	18	4	569	3	fretwork
fronter	10	36	1158	3	fronter
fronton	10	3	720	3	fronton
fueler	9	43	1393	3	fueler
functor	12	3	520	3	functor
furor	8	3	1239	3	f_uror
futon	8	31	1377	3	f_uton
gator	6	44	1603	3	_gator
goer	5	68	2710	3	goe__r
goiter	7	41	1620	3	goiter
hector	11	33	1265	3	hector
hoer	7	65	3398	3	hoe__r
honor	8	57	1862	3	ho_nor
hooter	9	41	2393	3	hooter
horror	9	8	872	3	horror
hotter	9	47	2008	3	hotter
jeton	12	48	1540	3	_jeton
jolter	13	35	1309	3	jolter
jotter	13	43	1563	3	jotter
keto	8	62	2345	3	_keto_
ketol	9	54	1400	3	_ketol
koto	8	63	2347	3	ko_to_
kotos	9	57	1770	3	ko_tos
kotow	12	52	871	3	ko_tow
kowtow	16	4	346	3	kowtow
lector	8	35	1498	3	lector
lictor	8	36	1085	3	lictor
locator	9	31	1042	3	locator
lofter	9	46	1472	3	lofter
loiter	6	46	1917	3	loiter
looter	6	42	2232	3	looter
lotos	5	47	2463	3	lo_tos
lotter	6	40	2560	3	lotter
lotto	5	52	1757	3	lotto_
lottos	6	46	1310	3	lottos
meeter	8	36	1650	3	meeter
mentor	8	4	1436	3	mentor
meteor	8	49	1007	3	_meteor
meter	7	51	3032	3	_meter
metol	7	59	1781	3	_metol
metro	7	47	1880	3	_metro
molter	8	41	1942	3	molter
molto	7	56	1960	3	molto_
monitor	9	3	1072	3	monitor
moor	6	66	2855	3	mo__or
mooter	8	39	2109	3	mooter
mortar	8	38	1204	3	mortar
motors	8	46	1660	3	mo_tors
motto	7	61	1951	3	motto_
mottos	8	46	1524	3	mottos
mouton	8	4	1085	3	mouton
nestor	6	37	1342	3	nestor
netop	7	3	1234	3	_netop
noetic	8	5	1404	3	noetic
nostoc	8	6	819	3	nostoc
noter	5	50	2564	3	no_ter
oater	5	54	3373	3	_oater
odor	5	57	1809	3	_o_dor
offeror	13	4	294	3	offeror
ofter	8	41	1687	3	_ofter
onto	4	61	2766	3	_onto_
orator	6	3	1453	3	orator
ottar	5	43	1399	3	_ottar
otter	5	44	2397	3	_otter
otto	4	52	2064	3	_otto_
ottos	5	47	1432	3	_ottos
outer	5	56	3330	3	_outer
oxter	12	34	1409	3	_oxter
pastor	8	48	1748	3	pastor
peter	7	44	2759	3	_peter
plexor	15	3	525	3	plexor
poet	6	55	5290	3	poet__
poetic	10	4	1684	3	poetic
poetry	11	3	938	3	poetry
poets	7	60	2444	3	poet_s
ponton	8	32	1764	3	ponton
poor	6	56	3022	3	po__or
porter	8	42	2441	3	porter
poster	8	41	2917	3	poster
postop	10	5	1194	3	postop
potter	8	39	2698	3	potter
potto	7	53	2094	3	potto_
pottos	8	46	1587	3	pottos
pouter	8	39	2398	3	pouter
powter	11	41	1603	3	powter
praetor	9	3	897	3	praetor
pretors	9	3	1681	3	pretors
proctor	11	3	1043	3	proctor
questor	16	14	663	3	questor
raptor	8	39	1282	3	raptor
rector	8	40	1975	3	rector
retore	6	76	3077	3	_retore
retorn	6	109	2343	3	_retorn
retort	6	68	3115	3	_retort
retro	5	50	2095	3	_retro
rhetors	10	3	851	3	rhetors
rooter	6	49	2603	3	rooter
roster	6	43	2908	3	roster
rotator	7	3	1083	3	rotator
roto	4	59	3505	3	ro_to_
rotors	6	49	1795	3	ro_tors
rotos	5	60	2788	3	ro_tos
rotter	6	43	2546	3	rotter
router	6	50	2584	3	router
sartor	6	3	1388	3	sartor
sector	8	34	1593	3	sector
senor	5	38	2280	3	_senor
seton	5	52	2354	3	_seton
soever	9	44	1209	3	soever
softer	9	40	1531	3	softer
sopor	7	40	1649	3	so_por
sordor	7	3	1022	3	sordor
sorter	6	44	2509	3	sorter
sotol	5	49	1765	3	so_tol
souter	6	42	2592	3	souter
stator	6	40	1548	3	stator
stentor	7	3	938	3	stentor
stertor	7	3	1009	3	stertor
suitor	6	33	1105	3	suitor
teeter	6	54	2031	3	teeter
tenor	5	36	2025	3	_tenor
tooter	6	44	2080	3	tooter
tor	3	92	6168	3	___tor
torpor	8	3	919	3	torpor
toter	5	59	3213	3	to_ter
totter	6	50	2146	3	totter
touter	6	38	2103	3	touter
tremor	8	42	1040	3	tremor
tutor	5	7	1249	3	_tutor
ureter	6	3	1320	3	ureter
vector	11	32	1206	3	vector
veto	7	66	2299	3	_veto_
vetoer	9	34	1006	3	_vetoer
viator	9	32	1183	3	viator
victor	11	32	1067	3	victor
voter	8	51	2105	3	vo_ter
wonton	9	34	1096	3	wonton
zoster	15	37	1585	3	zoster

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	348	5.343	21096.0
3	Display Results	348	348	0.110	3163.6
	(SQL Overall)	178691	348	5.829	30655.5