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

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

337 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
fantom	11	21	1080	(None)
fandom	12	21	1089	1	fandom
fantod	10	20	1003	1	fantod
fantoms	12	18	915	1	fantoms
atom	6	78	2452	2	_a_tom
bantam	10	3	1406	2	bantam
canto	7	49	3101	2	canto_
canton	8	57	2299	2	canton
cantor	8	56	2152	2	cantor
cantos	8	48	2697	2	cantos
factor	11	9	1145	2	factor
fandoms	13	22	947	2	fandoms
fanion	9	45	1432	2	fanion
fano	7	58	3169	2	fan_o_
fanon	8	46	1901	2	fan_on
fanos	8	59	2650	2	fan_os
fantasm	12	3	659	2	fantasm
fantods	11	17	762	2	fantods
fanum	10	3	1344	2	fan_um
fathom	14	3	747	2	fathom
hansom	11	21	915	2	hansom
madtom	11	3	802	2	madtom
panto	7	61	2941	2	panto_
pantos	8	52	2274	2	pantos
pantoum	11	3	870	2	pantoum
phantom	14	3	669	2	phantom
random	9	25	1355	2	random
ransom	8	24	1094	2	ransom
santo	5	62	2728	2	santo_
santol	6	45	1524	2	santol
santos	6	44	2183	2	santos
tanto	5	57	2494	2	tanto_
wanton	9	44	1381	2	wanton
actor	7	11	1607	3	_actor
alto	4	78	3126	3	_alto_
altos	5	58	2295	3	_altos
anatomy	12	4	623	3	_anatomy
ancon	7	57	1823	3	_ancon
anion	5	50	2881	3	_anion
annoy	8	6	971	3	_annoy
anoa	4	56	3447	3	_an_oa
anomy	10	51	1339	3	_an_omy
anon	4	61	3485	3	_an_on
ant	3	72	7079	3	_ant__
anta	4	68	3958	3	_ant_a
antae	5	68	2829	3	_antae
antas	5	54	3203	3	_antas
ante	4	65	3890	3	_ant_e
anted	6	63	2824	3	_anted
antes	5	63	3432	3	_antes
anthem	11	34	1034	3	_anthem
anti	4	55	3636	3	_ant_i
antic	7	57	2886	3	_antic
antis	5	50	3331	3	_antis
antonym	12	4	651	3	_antonym
antra	5	65	2192	3	_antra
antre	5	52	2452	3	_antre
antrum	8	6	1131	3	_antrum
ants	4	72	4347	3	_ant_s
antsy	8	57	1279	3	_antsy
anyon	8	56	1522	3	_anyon
atoms	7	68	1756	3	_a_toms
atomy	10	74	1519	3	_a_tomy
atop	6	61	2475	3	_a_top
auto	4	74	3208	3	_auto_
autos	5	65	2332	3	_autos
axiom	14	39	1359	3	_axiom
banco	9	40	1939	3	banco_
bancos	10	47	1389	3	bancos
bandog	10	3	872	3	bandog
banjo	14	38	1244	3	banjo_
banjos	15	37	889	3	banjos
bantams	11	4	906	3	bantams
banter	8	48	2533	3	banter
banty	10	66	2400	3	bant_y
baton	7	58	2242	3	ba_ton
bento	7	59	2295	3	bento_
bentos	8	62	1830	3	bentos
bottom	10	4	872	3	bottom
candor	9	45	1642	3	candor
cannon	8	45	1444	3	cannon
cannot	8	36	1677	3	cannot
canoe	7	56	2725	3	can_oe
canon	7	47	2530	3	can_on
canso	7	50	1940	3	canso_
cansos	8	49	1538	3	cansos
cant	6	63	6203	3	cant__
cantal	8	41	2203	3	cantal
cantdog	11	3	457	3	cantdog
canted	9	48	2578	3	canted
canter	8	52	3011	3	canter
canthi	11	3	1097	3	canthi
cantic	10	39	2054	3	cantic
cantle	8	45	2215	3	cantle
cantons	9	52	2120	3	cantons
cantors	9	46	2075	3	cantors
cants	7	70	3694	3	cant_s
cantus	8	51	1776	3	cantus
canty	10	52	2680	3	cant_y
canyon	11	45	1203	3	canyon
captor	10	49	1460	3	captor
carom	9	50	2556	3	ca_rom
carrom	10	5	1340	3	carrom
carton	8	45	2266	3	carton
cartop	10	42	1356	3	cartop
castor	8	44	1853	3	castor
cento	7	66	2517	3	cento_
centos	8	59	2046	3	centos
centum	10	40	1236	3	centum
chantor	12	37	1031	3	chantor
condom	11	42	1536	3	condom
conto	7	60	2717	3	conto_
contos	8	49	2323	3	contos
custom	10	40	1027	3	custom
dalton	7	3	1127	3	dalton
danio	6	3	1978	3	danio_
danios	7	3	1460	3	danios
dato	5	61	2994	3	da_to_
datos	6	52	2278	3	da_tos
datto	6	54	1642	3	datto_
dattos	7	43	1190	3	dattos
datum	8	3	1063	3	da_tum
diatom	9	3	945	3	diatom
entomb	10	3	736	3	_entomb
fact	9	71	4254	3	fact__
faction	12	26	1333	3	faction
factoid	13	3	869	3	factoid
factors	12	9	1212	3	factors
factory	15	10	834	3	factory
factotum	15	4	244	3	factotum
facts	10	70	2189	3	fact_s
fado	8	72	2646	3	fa_do_
fados	9	56	2073	3	fa_dos
faggot	11	3	905	3	faggot
fagot	9	3	2340	3	fa_got
fagots	10	3	996	3	fagots
faint	8	58	3706	3	faint__
fainted	11	42	1172	3	fainted
fainter	10	36	1105	3	fainter
faintly	13	3	708	3	faintly
faints	9	48	1878	3	faint_s
faith	11	56	2085	3	fait_h
faiths	12	46	1027	3	faiths
faitour	10	3	488	3	faitour
falcon	11	3	1029	3	falcon
fallow	12	47	1385	3	fallow
falter	9	45	1905	3	falter
fan	6	71	5886	3	fan___
fanatic	12	6	1069	3	fanatic
fancy	13	46	1548	3	fan_cy
fane	7	53	4357	3	fan__e
fanega	10	5	578	3	fanega
fanes	8	46	3989	3	fan_es
fanfic	14	3	631	3	fanfic
fanfold	14	8	537	3	fanfold
fang	8	54	3255	3	fan__g
fanga	9	61	1962	3	fan_ga
fangas	10	50	1719	3	fangas
fanged	11	43	1822	3	fanged
fangs	9	62	2407	3	fan_gs
fanions	10	37	1307	3	fanions
fanjet	16	3	1139	3	fanjet
fanned	10	41	1747	3	fanned
fanner	9	42	1818	3	fanner
fanny	11	48	1604	3	fan_ny
fanons	9	61	1521	3	fanons
fans	7	62	4737	3	fan__s
fantail	10	3	1023	3	fantail
fantasms	13	4	563	3	fantasms
fantast	10	3	1170	3	fantast
fantasy	13	3	615	3	fantasy
fanums	11	3	726	3	fanums
fanwort	13	3	1073	3	fanwort
farm	9	59	3453	3	fa__rm
faro	7	61	3692	3	fa_ro_
faros	8	55	3202	3	fa_ros
farrow	12	30	997	3	farrow
fart	7	68	6056	3	fart__
farted	10	51	2178	3	farted
farts	8	83	3684	3	fart_s
fast	7	70	5231	3	fast__
fasted	10	53	2095	3	fasted
fasten	9	51	1489	3	fasten
faster	9	46	2577	3	faster
fasts	8	64	2968	3	fast_s
fat	6	81	7808	3	fa_t__
fatal	8	48	1937	3	fa_tal
fate	7	54	4428	3	fa_t_e
fated	9	56	3213	3	fa_ted
fates	8	51	3923	3	fa_tes
fathoms	15	3	752	3	fathoms
fatly	11	57	1680	3	fa_tly
fats	7	62	5250	3	fa_t_s
fatso	8	51	1349	3	fa_tso
fatsos	9	38	942	3	fatsos
fatted	10	54	1984	3	fatted
fatten	9	43	1490	3	fatten
fatter	9	45	2321	3	fatter
fatty	11	51	1741	3	fa_tty
fatwa	11	6	806	3	fa_twa
favism	14	3	791	3	favism
favor	11	47	1245	3	fa_vor
fetor	8	12	1453	3	f_etor
finito	9	3	1030	3	finito_
fino	7	60	3469	3	fin_o_
finos	8	62	2695	3	fin_os
flattop	12	4	440	3	flattop
foetor	9	3	956	3	foetor
font	7	71	4375	3	font__
fontal	9	3	1314	3	fontal
fonts	8	61	2475	3	font_s
frantic	12	3	1036	3	frantic
from	9	69	2392	3	f__rom
fronton	10	3	720	3	fronton
functor	12	3	520	3	functor
fungo	9	44	1313	3	fungo_
futon	8	31	1377	3	f_uton
fynbos	14	3	328	3	fynbos
ganof	9	54	2036	3	gan_of
gantry	10	38	1011	3	gantry
gator	6	44	1603	3	ga_tor
genom	8	37	1684	3	gen_om
gentoo	7	3	1131	3	gentoo
grantor	8	40	1093	3	grantor
hansoms	12	23	852	3	hansoms
hant	7	54	6159	3	hant__
hanted	10	41	2431	3	hanted
hantle	9	43	1820	3	hantle
hants	8	63	3540	3	hant_s
into	4	50	2615	3	_into_
intomb	10	3	640	3	_intomb
janitor	14	3	648	3	janitor
janty	15	68	1696	3	jant_y
jato	11	58	2268	3	ja_to_
jatos	12	51	1682	3	ja_tos
junto	12	51	1456	3	junto_
juntos	13	41	1084	3	juntos
kantar	10	3	1115	3	kantar
lactam	10	3	1094	3	lactam
laptop	10	7	681	3	laptop
lento	5	72	2339	3	lento_
lentos	6	53	1740	3	lentos
lintol	6	36	947	3	lintol
madtoms	12	3	692	3	madtoms
maintop	11	3	514	3	maintop
maltol	8	3	1084	3	maltol
mango	8	57	2432	3	mango_
mangos	9	43	1933	3	mangos
manioc	10	39	1482	3	manioc
manito	8	5	1869	3	manito_
manitos	9	3	1405	3	manitos
manitou	9	3	846	3	manitou
mano	6	65	3681	3	man_o_
manor	7	80	2393	3	man_or
manos	7	49	3362	3	man_os
manta	7	56	2991	3	mant_a
mantas	8	57	2536	3	mantas
mantel	8	43	1797	3	mantel
mantes	8	44	3078	3	mantes
mantic	10	41	2090	3	mantic
mantid	9	38	2038	3	mantid
mantis	8	39	2603	3	mantis
mantle	8	44	2092	3	mantle
mantra	8	41	1609	3	mantra
mantram	11	40	1160	3	mantram
mantua	8	44	1202	3	mantua
mentor	8	4	1436	3	mentor
mentum	10	45	1171	3	mentum
nanism	8	3	1120	3	nanism
nom	5	104	5064	3	__n_om
noncom	10	3	968	3	noncom
onto	4	61	2766	3	_onto_
pant	6	60	6126	3	pant__
panted	9	50	2482	3	panted
pantie	8	43	2647	3	pantie
pantoums	12	3	671	3	pantoums
pantry	11	50	1410	3	pantry
pants	7	65	3692	3	pant_s
panty	10	59	2930	3	pant_y
parton	8	47	2099	3	parton
pastor	8	48	1748	3	pastor
phantoms	15	4	597	3	phantoms
pinto	7	56	2575	3	pinto_
pintos	8	60	2129	3	pintos
ponton	8	32	1764	3	ponton
punto	7	51	2132	3	punto_
puntos	8	59	1579	3	puntos
quantum	18	4	510	3	quantum
ragtop	9	3	668	3	ragtop
rancor	8	8	1037	3	rancor
randoms	10	21	1243	3	randoms
ransoms	9	24	1016	3	ransoms
rant	4	58	6468	3	rant__
ranted	7	43	2470	3	ranted
ranter	6	38	2682	3	ranter
rants	5	59	3534	3	rant_s
raptor	8	39	1282	3	raptor
rato	4	54	3697	3	ra_to_
ratos	5	55	2876	3	ra_tos
ratton	6	41	1612	3	ratton
saintdom	11	4	246	3	saintdom
sanctum	11	4	529	3	sanctum
sannop	8	3	737	3	sannop
santimi	9	3	879	3	santimi
santims	9	3	1260	3	santims
santimu	9	3	856	3	santimu
santir	6	3	1525	3	santir
santols	7	35	1332	3	santols
santoor	7	3	743	3	santoor
santour	7	3	737	3	santour
santur	6	3	1127	3	santur
sartor	6	3	1388	3	sartor
satem	7	60	2146	3	sa_tem
syncom	13	3	609	3	syncom
tandem	9	3	1140	3	tandem
tango	6	69	2117	3	tango_
tangos	7	42	1630	3	tangos
tannoy	9	5	835	3	tannoy
tantra	6	37	1335	3	tantra
tantrum	9	4	668	3	tantrum
tattoo	6	3	1097	3	tattoo
tautog	7	6	571	3	tautog
tom	5	143	5805	3	___tom
transom	9	4	882	3	transom
unto	4	58	2428	3	_unto_
vagrom	12	3	594	3	vagrom
varoom	11	4	1141	3	varoom
venom	10	39	1486	3	ven_om
wanion	9	32	1306	3	wanion
want	7	61	5617	3	want__
wanted	10	43	1972	3	wanted
wanter	9	44	2305	3	wanter
wantons	10	37	1301	3	wantons
wants	8	79	3221	3	want_s
wonton	9	34	1096	3	wonton
xanthoma	20	4	397	3	xanthoma
yantra	9	44	962	3	yantra

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.423	422437.4
2	DLD Change Limit	112716	337	4.796	23502.1
3	Display Results	337	337	0.093	3623.7
	(SQL Overall)	178691	337	5.312	33639.1