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

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

326 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
sapota	8	3	1021	(None)
sapotas	9	3	961	1	sapotas
sapote	8	3	1436	1	sapote
capita	10	29	1377	2	capita
capote	10	3	1573	2	capote
sabot	7	9	3178	2	sabot_
sabots	8	3	1470	2	sabots
samosa	8	5	1020	2	samosa
sancta	8	3	983	2	sancta
sapor	7	51	1925	2	sapo_r
sapors	8	41	1881	2	sapors
sapotes	9	3	1394	2	sapotes
sapour	8	38	1237	2	sapour
scrota	8	3	1019	2	scrota
septa	7	55	1808	2	sep_ta
spot	6	55	4069	2	s_pot_
spots	7	44	2411	2	s_pots
sputa	7	46	1296	2	s_puta
tapeta	8	3	1069	2	tapeta
aboma	9	11	1460	3	_aboma
aceta	7	40	1735	3	_aceta
acta	6	95	2480	3	_a_cta
adyta	9	3	685	3	_adyta
agita	6	3	1542	3	_agita
agora	6	9	1433	3	_agora
aloha	8	5	1361	3	_aloha
anoa	4	56	3447	3	_ano_a
anta	4	68	3958	3	_a_nta
aorta	5	59	2257	3	_aorta
aphtha	14	4	448	3	_aphtha
apnea	7	34	1341	3	_apnea
apnoea	8	6	709	3	_apnoea
apo	5	111	4212	3	_apo__
apod	7	81	2318	3	_apo_d
apodal	9	28	983	3	_apodal
apods	8	63	1634	3	_apods
aporia	8	3	1586	3	_aporia
aport	7	54	3217	3	_aport
apos	6	54	3382	3	_apo_s
apt	5	73	5254	3	_ap_t_
aroma	7	12	2014	3	_aroma
ascot	7	65	2251	3	ascot_
ascots	8	53	1251	3	ascots
azote	14	44	1634	3	_azote
azoth	17	38	990	3	_azoth
balata	8	6	1467	3	balata
baryta	11	43	1029	3	baryta
biota	7	45	1682	3	_biota
bota	6	62	3650	3	__bota
caeoma	10	3	903	3	caeoma
canola	8	3	1362	3	canola
capital	11	23	1152	3	capital
capo	8	58	2921	3	capo__
capon	9	52	2187	3	capo_n
caponata	12	4	516	3	caponata
capons	10	41	1950	3	capons
caporal	11	4	1094	3	caporal
capos	9	48	2607	3	capo_s
capotes	11	3	1464	3	capotes
capstan	11	3	790	3	capstan
captan	10	16	1334	3	cap_tan
captor	10	49	1460	3	captor
caput	9	8	2398	3	caput_
casita	8	29	1370	3	casita
crapola	11	3	691	3	crapola
cupola	10	31	769	3	cupola
dagoba	10	7	494	3	dagoba
data	5	60	2665	3	da__ta
depot	8	57	2792	3	depot_
depots	9	47	1634	3	depots
fagot	9	3	2340	3	fagot_
fagots	10	3	996	3	fagots
fajita	16	3	592	3	fajita
flota	8	53	1564	3	_flota
garote	7	7	1795	3	garote
gavot	9	3	2112	3	gavot_
gavots	10	3	811	3	gavots
iota	4	51	2783	3	__iota
jabot	14	3	2151	3	jabot_
jabots	15	3	888	3	jabots
jota	11	64	2362	3	__jota
kapa	10	60	2129	3	kap__a
kapok	10	44	878	3	kapo_k
kapoks	11	34	726	3	kapoks
kappa	13	46	974	3	kap_pa
kaput	11	7	1706	3	kaput_
kaputt	12	6	800	3	kaputt
kata	8	56	2602	3	ka__ta
laptop	10	7	681	3	laptop
lepta	7	57	1439	3	lep_ta
lipoma	10	4	675	3	lipoma
lota	4	72	3350	3	__lota
magot	8	3	2639	3	magot_
magots	9	3	1236	3	magots
makuta	12	3	639	3	makuta
maloti	8	3	1321	3	maloti
manta	7	56	2991	3	ma_nta
napa	6	69	2726	3	nap__a
naphtha	15	4	292	3	naphtha
nappa	9	85	1186	3	nap_pa
nepeta	8	3	789	3	nepeta
nota	4	68	3077	3	__nota
pagoda	10	48	787	3	pagoda
pakora	12	4	728	3	pakora
papa	8	58	2714	3	pap__a
papaya	13	3	750	3	papaya
papula	10	30	1111	3	papula
pasta	7	66	2453	3	pa_sta
payola	11	20	811	3	payola
pelota	8	6	1283	3	pelota
pita	6	54	3643	3	__pita
pot	5	80	7843	3	__pot_
pots	6	64	5236	3	__pots
quota	14	51	1196	3	_quota
raita	5	46	2307	3	ra_ita
ramona	8	4	1241	3	ramona
raphia	11	35	1126	3	raphia
rapt	6	72	4531	3	rap_t_
raptor	8	39	1282	3	raptor
repot	7	51	3262	3	repot_
repots	8	56	2100	3	repots
rota	4	58	3434	3	__rota
sabbat	10	3	1471	3	sabbat
sabotage	11	4	460	3	sabotage
sabra	7	53	1785	3	sa_bra
sacra	7	45	1699	3	sa_cra
safety	12	20	691	3	safety
saga	5	53	3117	3	sa__ga
sago	5	63	3267	3	sago__
sagos	6	61	2387	3	sago_s
saiga	6	47	1793	3	sa_iga
saint	5	51	4707	3	saint_
saints	6	51	2242	3	saints
saith	8	58	2655	3	sa_ith
sajou	12	3	1169	3	sajo_u
sajous	13	3	1058	3	sajous
salina	6	42	2112	3	salina
saliva	9	31	1074	3	saliva
salol	5	52	2214	3	salo_l
salols	6	40	1787	3	salols
salon	5	52	2855	3	salo_n
salons	6	38	2369	3	salons
saloon	6	44	1802	3	saloon
saloop	8	42	1258	3	saloop
salpa	7	50	1835	3	sa_lpa
salsa	5	67	1892	3	sa_lsa
salt	4	57	5852	3	sa_lt_
salts	5	54	3188	3	sa_lts
salty	8	55	2438	3	sa_lty
salute	6	44	1802	3	salute
salvia	9	33	1075	3	salvia
samara	8	3	1385	3	samara
samba	9	56	1877	3	sa_mba
samite	8	30	2060	3	samite
samosas	9	3	929	3	samosas
samovar	12	4	424	3	samovar
sanga	6	60	2379	3	sa_nga
sanity	9	3	1620	3	sanity
santo	5	62	2728	3	sa_nto
santol	6	45	1524	3	santol
santos	6	44	2183	3	santos
sap	5	64	6323	3	sap___
saphead	13	5	777	3	saphead
saphena	12	3	586	3	saphena
sapid	8	47	2093	3	sap_id
saponin	9	3	1026	3	saponin
saponite	10	4	1053	3	saponite
sapours	9	36	1062	3	sapours
sapped	11	44	2201	3	sapped
sapper	10	38	2235	3	sapper
sappy	12	54	1347	3	sap_py
saprobe	11	3	733	3	saprobe
saps	6	53	4637	3	sap__s
sapwood	13	6	691	3	sapwood
sarcoma	11	4	740	3	sarcoma
sarod	6	53	2587	3	saro_d
sarode	7	53	1751	3	sarode
sarods	7	49	1857	3	sarods
sarong	7	39	1487	3	sarong
saros	5	52	3806	3	saro_s
sartor	6	3	1387	3	sartor
sat	3	62	8848	3	sa__t_
satara	6	3	1553	3	satara
satay	8	47	1846	3	sa__tay
sate	4	55	5610	3	sa__te
sati	4	55	3933	3	sa__ti
satori	6	4	1584	3	satori
sault	5	58	3496	3	sault_
saults	6	58	1617	3	saults
sauna	5	41	1755	3	sa_una
saute	5	50	2808	3	sa_ute
savate	9	3	1378	3	savate
savor	8	54	1794	3	savo_r
savors	9	56	1610	3	savors
savory	12	43	1056	3	savory
savour	9	41	1070	3	savour
savoy	11	47	1388	3	savo_y
savoys	12	42	789	3	savoys
saxony	16	3	623	3	saxony
sayst	8	53	2200	3	sayst_
scapose	11	4	775	3	scapose
scapula	11	3	634	3	scapula
scoot	7	57	2915	3	scoot_
scoots	8	53	1594	3	scoots
scot	6	62	4261	3	s_cot_
scotia	8	3	1080	3	s_cotia
scots	7	40	2591	3	s_cots
scrotal	9	3	849	3	scrotal
scuta	7	58	1575	3	s_cuta
seaport	9	3	1559	3	seaport
seaports	10	3	846	3	seaports
senora	6	32	1615	3	senora
sepia	7	53	1867	3	sep_ia
sepoy	10	3	1430	3	sepo_y
sepoys	11	3	847	3	sepoys
sept	6	58	4436	3	sep_t_
septal	8	45	1338	3	sep_tal
septs	7	54	2060	3	sep_ts
serosa	6	3	1302	3	serosa
seta	4	56	3731	3	s__eta
sexpot	15	3	954	3	sexpot_
sexpots	16	3	629	3	sexpots
shelta	9	31	1179	3	shelta
shoat	8	56	3395	3	s_hoat
shoot	8	42	3591	3	shoot_
shoots	9	46	1936	3	shoots
shot	7	61	5026	3	s_hot_
shote	8	55	2610	3	s_hote
shots	8	47	3085	3	s_hots
shott	8	53	3219	3	s_hott
siesta	6	3	950	3	siesta
slot	4	60	4983	3	s_lot_
sloth	8	50	1945	3	s_loth
slots	5	48	3053	3	s_lots
smooth	11	25	920	3	smooth
smote	7	58	2028	3	s_mote
snoot	5	50	3014	3	snoot_
snoots	6	42	1668	3	snoots
snooty	9	42	1151	3	snooty
snot	4	47	4545	3	s_not_
snots	5	52	2512	3	s_nots
soba	6	49	2792	3	s__oba
soca	6	63	3005	3	s__oca
soda	5	63	2938	3	s__oda
sofa	7	56	2560	3	s__ofa
softa	8	64	1518	3	s_ofta
soja	11	56	1951	3	s__oja
sola	4	55	4186	3	s__ola
soma	6	56	3529	3	s__oma
somata	8	3	1238	3	somata
sonata	6	3	1322	3	sonata
soot	4	57	6106	3	s_oot_
sooth	8	59	2406	3	s_ooth
soots	5	55	3621	3	s_oots
sooty	8	49	2484	3	s_ooty
sopite	8	49	1771	3	sopite
sopor	7	40	1649	3	sopo_r
sopors	8	52	1520	3	sopors
sora	4	57	4691	3	s__ora
sorta	5	71	2541	3	s_orta
sot	3	103	8430	3	s__ot_
soth	7	59	3252	3	s__oth
sots	4	55	5245	3	s__ots
soya	7	57	2443	3	s__oya
spa	5	57	3081	3	s_p__a
spait	7	56	3160	3	spait_
spaits	8	50	1747	3	spaits
spartan	9	4	833	3	spartan
spat	6	65	4852	3	s_pat_
spate	7	47	3158	3	s_pate
spats	7	50	3138	3	s_pats
spica	9	47	1794	3	s_pica
spit	6	55	4508	3	s_pit_
spital	8	38	1387	3	s_pital
spite	7	54	3066	3	s_pite
spits	7	44	2955	3	s_pits
spitz	16	60	1797	3	s_pitz
splat	7	61	2934	3	s_plat
spode	8	46	1770	3	s_pode
spoil	7	58	1865	3	s_poil
spoke	11	48	1866	3	s_poke
spoof	10	50	1901	3	s_poof
spook	11	54	1604	3	s_pook
spool	7	52	1904	3	s_pool
spoon	7	47	1944	3	s_poon
spoor	7	50	1635	3	s_poor
sporal	8	29	1545	3	s_poral
spore	7	54	2859	3	s_pore
sport	7	59	3598	3	s_port
sports	8	46	1918	3	s_ports
sporty	11	51	1249	3	s_porty
spotty	11	44	858	3	s_potty
spout	7	50	2963	3	s_pout
spouts	8	51	1511	3	s_pouts
sprat	7	66	3597	3	s_prat
stoa	4	54	2591	3	s_to_a
stoat	5	71	3595	3	s_toat
stoma	7	59	1827	3	s_toma
stopt	7	65	2835	3	stopt_
stot	4	63	4733	3	s_tot_
stots	5	48	2855	3	s_tots
stott	5	69	2979	3	s_tott
strata	6	36	1628	3	strata
stroma	8	43	1307	3	stroma
supra	7	36	1425	3	sup_ra
sutta	5	40	1533	3	s_utta
swot	7	51	3466	3	s_wot_
swots	8	55	1843	3	s_wots
tapa	6	51	2914	3	tap__a
tapetal	9	3	827	3	tapetal
tapioca	11	4	463	3	tapioca
tarot	5	59	4393	3	tarot_
tarots	6	64	2299	3	tarots
teapot	8	4	1676	3	teapot_
teapots	9	3	905	3	teapots
valuta	9	3	874	3	valuta
vapor	10	40	1309	3	vapo_r
vapors	11	38	1269	3	vapors
vapory	14	39	876	3	vapory
vapour	11	37	887	3	vapour
wapiti	11	3	836	3	wapiti
yapock	17	36	538	3	yapock
yapok	14	46	815	3	yapo_k
yapoks	15	34	678	3	yapoks
yapon	10	46	1358	3	yapo_n
yapons	11	44	1177	3	yapons

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.140	1276364.3
2	DLD Change Limit	112716	326	6.266	17988.5
3	Display Results	326	326	0.110	2963.6
	(SQL Overall)	178691	326	6.516	27423.4