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

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

321 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
teopan	8	3	935	(None)
teopans	9	3	920	1	teopans
bedpan	11	3	758	2	bedpan
reopen	8	3	1157	2	reopen
stewpan	12	3	419	2	stewpan
taipan	8	24	1066	2	taipan
tampan	10	25	1232	2	tampan
tarpan	8	28	1429	2	tarpan
tenpin	8	3	1058	2	tenpin
tepa	6	60	2168	2	te_pa_
tepal	7	63	1958	2	te_pal
tepas	7	65	2168	2	te_pas
tolan	5	51	2401	2	t_olan
toman	7	57	2405	2	t_oman
topaz	16	3	1532	2	t_opaz
trapan	8	24	1297	2	trapan
trepan	8	25	1167	2	trepan
tropin	8	33	1675	2	tropin
tympan	13	25	701	2	tympan
yeoman	11	3	882	2	yeoman
aeolian	7	3	863	3	aeolian
aeon	4	56	3461	3	aeo__n
aeonian	7	3	835	3	aeonian
ajowan	16	3	489	3	ajowan
atropin	9	3	1158	3	atropin
bean	6	64	4386	3	be__an
bedpans	12	3	717	3	bedpans
began	8	63	1957	3	be_gan
bemean	10	4	1068	3	bemean
bemoan	10	3	1025	3	bemoan
bogan	8	75	1900	3	_bogan
brogan	9	3	1104	3	brogan
chopin	13	27	1219	3	chopin
copal	9	56	2178	3	_copal
copay	12	65	1631	3	_copay
copen	9	48	2643	3	_copen
cotan	7	15	2178	3	_cotan
deadpan	11	22	523	3	deadpan
dean	5	60	3948	3	de__an
deepen	9	33	919	3	deepen
deewan	10	26	755	3	deewan
demean	9	5	1056	3	demean
deodand	10	3	571	3	deodand
deodar	8	3	771	3	deodar
desman	9	3	1169	3	desman
dewan	9	57	1804	3	de_wan
dioxan	14	6	577	3	dioxan
dopa	7	72	2090	3	_dopa_
dopant	9	3	1613	3	_dopant
dopas	8	50	1906	3	_dopas
elan	4	67	3424	3	_e_lan
eolian	6	3	1259	3	_eolian
eon	3	60	5208	3	_eo__n
eonian	6	3	1183	3	_eonian
eosin	5	52	2092	3	_eosin
etesian	7	5	785	3	etesian
expand	16	23	657	3	_expand
expat	14	3	1381	3	_expat
foeman	11	3	1123	3	foeman
frypan	14	3	454	3	frypan
german	9	6	1198	3	german
goban	8	44	1407	3	_goban
gowan	9	54	1574	3	_gowan
groan	6	56	1842	3	gro_an
hempen	13	3	896	3	hempen
hetman	11	25	1060	3	hetman
hexosan	17	4	433	3	hexosan
hogan	9	78	1770	3	_hogan
honan	8	53	1977	3	_honan
inspan	8	3	751	3	inspan
japan	14	4	1123	3	_japan
jean	11	66	2928	3	je__an
jeon	11	68	2144	3	jeo__n
jeopard	17	4	411	3	jeopard
keppen	14	34	657	3	keppen
keypad	16	3	382	3	keypad
keypal	15	3	489	3	keypal
kneepan	13	7	263	3	kneepan
koan	8	54	2503	3	_ko_an
lean	4	63	4524	3	le__an
legman	9	4	965	3	legman
leman	7	56	2260	3	le_man
leopard	10	4	529	3	leopard
loan	4	74	3645	3	_lo_an
logan	6	81	2328	3	_logan
loran	5	59	2509	3	_loran
mean	6	55	3809	3	me__an
median	9	41	1754	3	median
merman	10	5	1386	3	merman
mesian	8	43	1550	3	mesian
messan	8	39	1206	3	messan
metopae	11	4	774	3	metopae
metopon	11	13	707	3	metopon
moan	6	58	3202	3	_mo_an
neocon	8	3	671	3	neocon
neon	4	70	2642	3	neo__n
nopal	7	55	1710	3	_nopal
opah	9	62	1840	3	__opah
opal	6	69	2352	3	__opal
open	6	64	2700	3	__open
ottoman	9	4	628	3	ottoman
pan	5	84	6645	3	___pan
pean	6	61	4717	3	pe__an
pecan	9	19	1903	3	pe_can
pechan	13	5	1154	3	pechan
pekan	11	16	1397	3	pe_kan
penman	10	3	1232	3	penman
peon	6	56	3524	3	peo__n
people	10	3	1019	3	people
prolan	8	4	1469	3	prolan
propane	11	27	1615	3	propane
propman	13	3	906	3	propman
redan	6	61	2501	3	re_dan
reloan	6	4	1569	3	reloan
reman	7	57	3015	3	re_man
reopens	9	3	937	3	reopens
repand	9	53	1606	3	re_pand
repay	10	48	1845	3	re_pay
repin	7	53	2470	3	re_pin
replan	8	32	1582	3	replan
reran	5	73	2910	3	re_ran
rewan	8	56	2366	3	re_wan
roan	4	72	3420	3	_ro_an
roman	7	54	2482	3	_roman
rowan	8	54	1873	3	_rowan
ryokan	13	5	375	3	ryokan
sampan	10	25	1189	3	sampan
seaman	8	40	1590	3	seaman
seawan	9	41	1122	3	seawan
secpar	10	3	792	3	secpar
sedan	6	56	2042	3	se_dan
seitan	6	26	1323	3	seitan
sepal	7	77	2300	3	se_pal
sewan	8	59	2129	3	se_wan
sextan	13	38	964	3	sextan
shopman	14	24	726	3	shopman
shoran	9	40	1604	3	shoran
slogan	7	53	922	3	slogan
solan	5	53	2815	3	_solan
soman	7	50	2490	3	_soman
span	6	52	3466	3	__span
steepen	9	34	865	3	steepen
stewpans	13	4	371	3	stewpans
taipans	9	26	955	3	taipans
tampans	11	33	1098	3	tampans
tampon	10	29	1123	3	tampon
tan	3	71	6758	3	t___an
tapa	6	51	2915	3	t_apa_
tapas	7	46	2771	3	t_apas
tarpans	9	25	1353	3	tarpans
tarpon	8	28	1280	3	tarpon
tartan	6	42	1751	3	tartan
tarzan	15	29	1075	3	tarzan
taxman	15	32	861	3	taxman
tea	3	73	5332	3	te__a_
teak	8	59	3084	3	te__ak
teal	4	55	4650	3	te__al
team	6	62	3865	3	te__am
teapot	8	4	1676	3	teapot
teapoy	11	3	811	3	teapoy
tear	4	52	4288	3	te__ar
teas	4	58	5149	3	te__as
teat	4	59	6363	3	te__at
tecta	7	42	1552	3	tecta_
tectal	8	37	1325	3	tectal
teen	4	59	3820	3	te__en
teepee	8	3	1436	3	teepee
teflon	9	3	745	3	teflon
tegmen	9	8	840	3	tegmen
tegua	6	10	956	3	tegua_
teguas	7	6	801	3	teguas
tela	4	55	3297	3	te_la_
telae	5	43	2329	3	te_lae
teleman	9	5	957	3	teleman
teleran	7	5	1018	3	teleran
telia	5	58	2114	3	telia_
telial	6	58	1536	3	telial
telson	6	3	1029	3	telson
temp	8	53	2333	3	temp__
temped	11	39	1289	3	temped
tempeh	13	35	746	3	tempeh
temper	10	39	1409	3	temper
tempi	9	49	1220	3	temp_i
temping	12	27	1069	3	temping
templar	11	4	564	3	templar
temple	10	28	1133	3	temple
tempo	9	52	1497	3	temp_o
tempos	10	38	1229	3	tempos
temps	9	54	1713	3	temp_s
tempt	9	51	2484	3	temp_t
tempts	10	43	945	3	tempts
ten	3	58	5611	3	te___n
tenant	6	3	2247	3	te_nant
tendon	7	3	1203	3	tendon
tenia	5	53	2448	3	tenia_
teniae	6	45	1735	3	teniae
tenias	6	47	2007	3	tenias
tenon	5	33	2051	3	te_non
tenpins	9	4	1007	3	tenpins
tepals	8	54	1504	3	te_pals
tepee	7	47	2421	3	te_pee
tepid	8	3	1431	3	te_pid
tepoy	10	3	1216	3	te_poy
tepoys	11	3	754	3	tepoys
terai	5	35	2548	3	te_rai
teraph	11	31	909	3	teraph
terga	6	33	1564	3	terga_
tergal	7	29	1283	3	tergal
tern	4	61	3480	3	te__rn
terpene	9	23	1086	3	terpene
terra	5	44	1967	3	terra_
terrae	6	29	1521	3	terrae
terrain	7	4	1085	3	terrain
terrane	7	28	1423	3	terrane
terras	6	35	1697	3	terras
tertian	7	5	1119	3	tertian
tesla	5	56	1260	3	tesla_
teslas	6	42	1217	3	teslas
testa	5	48	2204	3	testa_
testae	6	42	1625	3	testae
teston	6	3	1330	3	teston
tetany	9	5	984	3	te_tany
tetra	5	34	1795	3	tetra_
tetrad	7	36	1205	3	tetrad
tetras	6	30	1762	3	tetras
texas	12	65	1493	3	te_xas
than	7	61	2877	3	t__han
theophany	20	5	325	3	theophany
therian	10	3	1129	3	therian
thespian	13	4	320	3	thespian
thorax	16	3	825	3	thorax
thorn	8	53	1870	3	tho_rn
thoron	9	47	1390	3	thoron
tiepin	8	3	934	3	tiepin
timpana	11	22	613	3	timpana
timpani	11	26	615	3	timpani
timpano	11	23	586	3	timpano
tinman	8	24	1114	3	tinman
titan	5	33	1817	3	t_itan
titian	6	25	1266	3	titian
titman	8	27	1100	3	titman
toad	5	58	3018	3	t_o_ad
today	9	64	1695	3	t_oday
toea	4	67	3233	3	t_oea_
toeas	5	57	2642	3	t_oeas
toecap	10	3	732	3	toecap
toga	5	70	2741	3	t_oga_
togae	6	70	2011	3	t_ogae
togas	6	78	2300	3	t_ogas
tokay	12	55	1305	3	t_okay
token	9	54	1931	3	t_oken
tola	4	52	3633	3	t_ola_
tolane	6	43	1658	3	t_olane
tolans	6	43	1927	3	t_olans
tolar	5	55	2411	3	t_olar
tolas	5	45	3277	3	t_olas
tomans	8	54	1913	3	t_omans
ton	3	102	6510	3	t_o__n
tonal	5	37	2430	3	t_onal
toon	4	77	4063	3	t_o_on
top	5	105	6068	3	t_op__
tope	6	59	4638	3	t_op_e
toped	8	56	3131	3	t_oped
topee	7	60	2995	3	t_opee
toper	7	52	3102	3	t_oper
topes	7	69	4176	3	t_opes
toph	9	63	2687	3	t_op_h
tophe	10	67	1897	3	t_ophe
tophi	10	52	1530	3	t_ophi
tophs	10	52	2005	3	t_ophs
topi	6	78	3039	3	t_op_i
topic	9	57	2150	3	t_opic
toping	9	41	2299	3	t_oping
topis	7	60	2583	3	t_opis
topo	6	69	3240	3	t_op_o
topoi	7	60	1835	3	t_opoi
topos	7	57	2639	3	t_opos
tops	6	62	4812	3	t_op_s
tora	4	75	4599	3	t_ora_
torah	8	71	2527	3	t_orah
toras	5	55	4037	3	t_oras
torn	4	60	4425	3	t_o_rn
total	5	53	2182	3	t_otal
toucan	8	3	819	3	toucan
town	7	69	2870	3	t_o_wn
toxin	12	47	1671	3	t_oxin
toyon	8	67	1567	3	t_oyon
tragopan	11	4	434	3	tragopan
trapans	9	28	1246	3	trapans
trepang	10	25	729	3	trepang
trepans	9	23	1159	3	trepans
triptan	9	4	754	3	triptan
troak	9	52	1357	3	tro_ak
trocar	8	4	877	3	trocar
trogon	7	36	1175	3	trogon
troland	8	3	754	3	troland
trona	5	41	1895	3	trona_
tronas	6	38	1690	3	tronas
trop	6	68	3330	3	trop__
trope	7	57	2580	3	trop_e
tropes	8	48	2435	3	tropes
trophy	14	3	828	3	trophy
tropic	10	30	1419	3	tropic
tropine	9	31	1665	3	tropine
tropins	9	31	1631	3	tropins
turban	8	3	1048	3	turban
tympana	14	25	585	3	tympana
tympani	14	27	592	3	tympani
tympano	14	24	528	3	tympano
tympans	14	23	681	3	tympans
tympany	17	25	460	3	tympany
typal	10	53	1115	3	t_ypal
ulpan	7	3	1012	3	_ulpan
unopen	8	3	891	3	unopen
utopian	9	12	627	3	utopian
vegan	9	51	1415	3	ve_gan
wean	7	57	3435	3	we__an
weapon	11	28	811	3	weapon
woman	10	58	1800	3	_woman
yean	7	58	3458	3	ye__an
yeomen	11	3	818	3	yeomen

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.406	440125.6
2	DLD Change Limit	112716	321	5.686	19823.4
3	Display Results	321	321	0.096	3343.8
	(SQL Overall)	178691	321	6.188	28877.0