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

Here are the results of your fuzzy-string dictionary search for “thalli” 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
thalli	9	5	892	(None)
phalli	11	4	826	1	phalli
thallic	12	4	655	1	thallic
challa	11	40	1419	2	challa
challie	12	40	1285	2	challie
challis	12	46	1346	2	challis
chally	14	43	1429	2	chally
chilli	11	43	1277	2	chilli
hall	7	57	4116	2	_hall_
hallo	8	51	2755	2	_hallo
halls	8	56	3378	2	_halls
phallic	14	4	729	2	phallic
shall	8	50	2405	2	shall_
tali	4	68	3716	2	t_a_li
tall	4	72	4021	2	t_all_
tallis	6	33	1996	2	t_allis
tallit	6	34	2273	2	t_allit
talls	5	51	3343	2	t_alls
tally	8	45	2686	2	t_ally
thalami	12	4	608	2	thalami
thaler	9	46	1310	2	thaler
thallium	13	4	443	2	thallium
thalloid	12	4	628	2	thalloid
thallus	10	3	560	2	thallus
thill	8	59	1873	2	thill_
thills	9	55	1538	2	thills
tholoi	9	33	923	2	tholoi
thrall	9	38	1029	2	thrall_
thralls	10	29	904	2	thralls
aalii	5	3	1613	3	_aalii
ahull	8	40	1031	3	ahull_
all	3	61	4823	3	__all_
alls	4	67	4092	3	__alls
ally	7	69	3564	3	__ally
anally	9	5	1350	3	anally
ball	6	60	4332	3	_ball_
balls	7	62	3641	3	_balls
bally	10	55	3010	3	_bally
bhakti	15	4	433	3	bhakti
biali	7	34	1907	3	bia_li
call	6	68	3867	3	_call_
calla	7	48	2707	3	_calla
calls	7	56	3473	3	_calls
celli	7	67	1769	3	_celli
chablis	14	36	856	3	chablis
chadri	12	3	814	3	chadri
chai	9	59	2990	3	cha__i
chalah	14	35	1166	3	chalah
chalcid	15	3	788	3	chalcid
chaleh	14	37	1199	3	chaleh
chalet	11	38	2599	3	chalet
chalk	14	48	1460	3	cha_lk
chalks	15	54	1214	3	chalks
chalky	18	46	877	3	chalky
challah	15	45	832	3	challah
challas	12	44	1412	3	challas
challies	13	39	1564	3	challies
challot	12	36	1326	3	challot
chalot	11	30	2013	3	chalot
charlie	12	30	1192	3	charlie
chili	10	62	1848	3	ch_ili
chill	10	56	1987	3	chill_
chillis	12	44	1160	3	chillis
chills	11	47	1770	3	chills
chilly	14	41	1322	3	chilly
cholla	11	39	1102	3	cholla
dally	9	53	2474	3	_dally
dhal	8	67	1928	3	dha_l_
dhals	9	54	1544	3	dha_ls
dually	10	32	1006	3	dually
duelli	7	6	700	3	duelli
fall	7	55	3531	3	_fall_
falls	8	57	2765	3	_falls
gall	5	63	3599	3	_gall_
gallic	9	4	1164	3	_gallic
galls	6	47	2932	3	_galls
gally	9	50	2617	3	_gally
gharri	10	38	616	3	gharri
ghazi	18	3	744	3	gha_zi
ghibli	12	4	349	3	ghibli
ghillie	11	32	635	3	ghillie
ghyll	12	4	632	3	ghyll_
ghylls	13	3	514	3	ghylls
hadji	16	83	989	3	_hadji
hail	7	48	3906	3	_hail_
hails	8	52	3164	3	_hails
haji	14	85	2019	3	_ha_ji
hajji	14	67	746	3	_hajji
halal	8	56	2359	3	_halal
halala	9	47	1509	3	_halala
halals	9	50	1831	3	_halals
hale	7	60	5283	3	_ha_le
haled	9	53	3582	3	_haled
haler	8	50	3352	3	_haler
hales	8	54	4984	3	_hales
half	10	62	3845	3	_ha_lf
halid	9	44	2498	3	_halid
hallah	12	41	1540	3	_hallah
hallal	9	44	1556	3	_hallal
hallel	9	35	1409	3	_hallel
halloa	9	49	1812	3	_halloa
halloo	9	51	1897	3	_halloo
hallos	9	54	2510	3	_hallos
hallot	9	54	2678	3	_hallot
hallow	12	48	1832	3	_hallow
hallux	16	3	736	3	_hallux
halm	9	58	3497	3	_ha_lm
halma	10	82	1925	3	_halma
halms	10	52	2521	3	_halms
halo	7	64	3732	3	_ha_lo
haloid	10	43	1776	3	_haloid
halon	8	61	2486	3	_halon
halos	8	52	3025	3	_halos
halt	7	60	5630	3	_ha_lt
halts	8	52	3010	3	_halts
halva	11	54	1443	3	_halva
halve	11	48	1892	3	_halve
hamuli	11	3	706	3	_hamuli
haole	8	48	2008	3	_haole
haply	13	59	1506	3	_haply
harl	7	57	4000	3	_harl_
harls	8	56	3450	3	_harls
haul	7	55	3045	3	_haul_
haulm	10	44	1541	3	_haulm
hauls	8	61	2373	3	_hauls
hell	7	56	3789	3	_hell_
hello	8	65	2298	3	_hello
hells	8	50	3204	3	_hells
hili	7	56	2663	3	_h_ili
hill	7	64	3949	3	_hill_
hillo	8	47	2165	3	_hillo
hills	8	54	3135	3	_hills
hilly	11	44	2216	3	_hilly
holla	8	49	1849	3	_holla
hollo	8	48	2216	3	_hollo
holly	11	48	2443	3	_holly
hull	7	54	2878	3	_hull_
hullo	8	44	1745	3	_hullo
hulls	8	49	2356	3	_hulls
khadi	13	6	760	3	kha_di
khaki	11	5	764	3	kha_ki
khalif	16	5	783	3	khalif
lall	4	55	3131	3	_lall_
lalls	5	53	2413	3	_lalls
leally	9	40	1261	3	leally
lethally	14	4	592	3	lethally
mall	6	46	3937	3	_mall_
mallei	8	44	1463	3	_mallei
malls	7	62	3343	3	_malls
nielli	6	3	630	3	nielli
ocelli	8	3	684	3	ocelli
orally	9	31	1359	3	orally
ovally	12	27	844	3	ovally
pall	6	50	3934	3	_pall_
pallia	8	30	1559	3	_pallia
pallid	9	39	1528	3	_pallid
palls	7	43	3256	3	_palls
pally	10	57	2712	3	_pally
palpi	9	54	1455	3	_palpi
phallism	15	4	571	3	phallism
phallist	13	3	899	3	phallist
phallus	12	3	606	3	phallus
phyllo	14	3	587	3	phyllo
prothalli	14	4	477	3	~~pro~~thalli
rally	8	47	2590	3	_rally
really	9	33	1561	3	really
sall	4	45	4468	3	_sall_
sally	8	51	2971	3	_sally
salmi	7	8	1586	3	_salmi
scall	7	44	2037	3	scall_
scalls	8	42	1820	3	scalls
shale	8	53	3283	3	sha_le
shaled	10	50	2395	3	shaled
shales	9	47	3125	3	shales
shaley	12	37	1499	3	shaley
shallop	12	34	845	3	shallop
shallot	10	36	1413	3	shallot
shallow	13	38	887	3	shallow
shalom	11	8	1092	3	shalom
shalt	8	55	3449	3	sha_lt
shaly	11	43	2286	3	sha_ly
shanti	9	40	1409	3	shanti
shaslik	14	4	451	3	shaslik
shaul	8	54	1810	3	shaul_
shauls	9	49	1311	3	shauls
shawl	11	62	1757	3	shawl_
shawls	12	54	1197	3	shawls
shell	8	44	2412	3	shell_
shells	9	43	1952	3	shells
shelly	12	44	1447	3	shelly
shill	8	53	2533	3	shill_
shills	9	45	1961	3	shills
small	7	40	1626	3	small_
smalls	8	45	1412	3	smalls
smalti	8	41	1119	3	smalti
spall	7	49	1930	3	spall_
spalls	8	42	1734	3	spalls
stall	5	47	2235	3	stall_
stalls	6	40	1993	3	stalls
tabla	7	33	1836	3	t_abla
table	7	54	2960	3	t_able
tabuli	8	3	936	3	tabuli
tael	4	60	3071	3	t_ael_
taels	5	68	2207	3	t_aels
tahini	9	3	989	3	tahini
tahsil	9	3	634	3	tahsil
tail	4	54	4365	3	t_ail_
taille	6	31	1692	3	taille
tails	5	56	3419	3	t_ails
tala	4	59	3805	3	t_a_la
talar	5	62	2538	3	t_alar
talas	5	59	3589	3	t_alas
talc	6	62	2681	3	t_a_lc
talcs	7	48	1718	3	t_alcs
tale	4	61	5416	3	t_a_le
taler	5	60	3486	3	t_aler
tales	5	54	5137	3	t_ales
talk	8	62	3009	3	t_a_lk
talkie	10	39	1444	3	t_alkie
talks	9	43	2269	3	t_alks
talky	12	62	1568	3	t_alky
taller	6	37	2196	3	t_aller
tallied	8	33	1475	3	t_allied
tallier	7	28	1721	3	t_allier
tallies	7	36	2460	3	t_allies
tallish	10	33	1358	3	t_allish
tallith	10	29	1306	3	t_allith
tallits	7	32	1599	3	t_allits
tallol	6	36	1222	3	t_allol
tallow	9	37	1420	3	t_allow
talon	5	58	2411	3	t_alon
taluk	9	48	1287	3	t_aluk
talus	5	54	2326	3	t_alus
tarsi	5	52	2217	3	t_arsi
taxi	11	71	2476	3	t_a_xi
teal	4	55	4650	3	tea_l_
teals	5	62	3413	3	tea_ls
teazle	15	32	955	3	teazle
tell	4	49	3470	3	t_ell_
tells	5	58	2894	3	t_ells
telly	8	49	2082	3	t_elly
teloi	5	42	1738	3	t_eloi
teocalli	10	4	437	3	teocalli
thack	14	49	1517	3	tha_ck
thacks	15	43	1192	3	thacks
thae	7	68	2556	3	tha__e
thairm	11	5	696	3	thairm
thalamic	15	4	555	3	thalamic
thalers	10	62	1226	3	thalers
thallious	12	4	327	3	thalli~~ous~~
thalliums	14	4	325	3	thalli~~ums~~
thallous	11	3	652	3	thallous
thalweg	14	4	203	3	thalweg
than	7	61	2877	3	tha__n
thane	8	61	2253	3	tha_ne
thanes	9	49	1898	3	thanes
thank	12	58	1780	3	tha_nk
thanks	13	43	1313	3	thanks
tharm	10	59	1664	3	tha_rm
tharms	11	57	1224	3	tharms
that	7	56	3932	3	tha__t
thatch	14	3	561	3	thatch
thaw	10	75	2131	3	tha__w
thawed	13	45	846	3	thawed
thawer	12	48	934	3	thawer
thaws	11	65	1546	3	tha_ws
theelin	10	3	800	3	theelin
thinly	12	3	867	3	thinly
thiol	8	76	1604	3	thiol_
thiolic	12	4	732	3	thiolic
thiols	9	51	1276	3	thiols
thirl	8	54	1682	3	thirl_
thirls	9	50	1206	3	thirls
thole	8	56	2084	3	th_ole
tholed	10	51	1387	3	tholed
tholes	9	49	1978	3	tholes
tholos	9	42	1300	3	tholos
thralled	12	4	580	3	thralled
thralling	13	25	683	3	thralling
thrill	9	49	1059	3	thrill
thrills	10	39	878	3	thrills
thulia	9	3	611	3	thulia
thurl	8	49	1268	3	thurl_
thurls	9	41	871	3	thurls
thusly	12	3	513	3	thusly
thymi	13	41	863	3	th_ymi
thyrsi	12	3	445	3	thyrsi
tidally	11	3	793	3	tidally
till	4	59	4120	3	t_ill_
tills	5	46	3171	3	t_ills
toll	4	55	3526	3	t_oll_
tolls	5	47	2843	3	t_olls
tonally	10	3	1137	3	tonally
totally	10	3	989	3	totally
tragi	6	47	1717	3	tra_gi
trail	5	51	2677	3	trail_
trails	6	46	2251	3	trails
trawl	8	49	1587	3	trawl_
trawls	9	44	1239	3	trawls
trellis	7	3	987	3	trellis
trill	5	51	2293	3	trill_
trills	6	43	1985	3	trills
troll	5	44	1653	3	troll_
trolls	6	46	1394	3	trolls
trolly	9	40	1236	3	trolly
trull	5	40	1267	3	trull_
trulls	6	41	1028	3	trulls
tsadi	6	37	991	3	tsa_di
tufoli	9	3	397	3	tufoli
tuille	6	30	1264	3	tuille
tuladi	7	6	572	3	tuladi
tulle	5	40	1993	3	t_ulle
tumuli	8	3	593	3	tumuli
twill	8	56	1272	3	twill_
twills	9	48	979	3	twills
villi	8	65	1785	3	_villi
wall	7	62	3610	3	_wall_
walla	8	53	2103	3	_walla
wallie	9	32	1680	3	_wallie
walls	8	55	2938	3	_walls
wally	11	46	2509	3	_wally
whale	11	55	1743	3	wha_le
whaled	13	46	1203	3	whaled
whaler	12	46	1197	3	whaler
whales	12	47	1694	3	whales
wholly	15	36	657	3	wholly

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.390	458182.1
2	DLD Change Limit	112716	326	5.486	20546.1
3	Display Results	326	326	0.093	3505.4
	(SQL Overall)	178691	326	5.969	29936.5