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

Here are the results of your fuzzy-string dictionary search for “thalloid” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

84 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
thalloid	12	4	628	(None)
halloed	11	33	1491	2	_halloed
haloid	10	43	1776	2	_ha_loid
haploid	13	3	983	2	_haploid
phylloid	17	4	619	2	phylloid
tabloid	10	4	826	2	t_abloid
thalli	9	5	892	2	thall_i_
thallic	12	4	655	2	thall_ic
thallous	11	3	652	2	thallous
algoid	8	30	1147	3	__algoid
allod	6	44	1838	3	__allo_d
arilloid	9	4	662	3	arilloid
chalcid	15	3	788	3	cha_lcid
challie	12	40	1285	3	chall_ie
challis	12	46	1346	3	chall_is
challot	12	36	1326	3	challo_t
challoth	16	31	610	3	challoth
cheloid	13	3	1083	3	ch_eloid
colloid	10	3	1288	3	_colloid
coralloid	12	4	462	3	coralloid
haemoid	13	3	720	3	_haemoid
halid	9	44	2498	3	_ha_l_id
hallo	8	51	2755	3	_hallo__
halloa	9	49	1812	3	_hallo_a
halloaed	12	15	1015	3	_halloaed
halloas	10	43	1846	3	_halloas
halloes	10	40	2152	3	_halloes
halloing	12	15	1007	3	_halloing
halloo	9	51	1897	3	_hallo_o
hallooed	12	16	877	3	_hallooed
halloos	10	37	1674	3	_halloos
hallos	9	54	2510	3	_hallo_s
hallot	9	54	2678	3	_hallo_t
halloth	13	41	1125	3	_halloth
hallow	12	48	1832	3	_hallo_w
hallowed	15	17	949	3	_hallowed
hallows	13	44	1739	3	_hallows
haloed	10	47	1760	3	_ha_loed
haloids	11	30	1255	3	_ha_loids
haploids	14	3	736	3	_haploids
haploidy	17	5	427	3	_haploidy
helloed	11	35	1242	3	_helloed
hilloed	11	32	1129	3	_hilloed
holloed	11	38	1275	3	_holloed
hulloed	11	36	979	3	_hulloed
hyaloid	14	3	907	3	_hyaloid
metalloid	12	4	620	3	metalloid
pallid	9	39	1528	3	_pall_id
phalli	11	4	826	3	phall_i_
phallic	14	4	729	3	phall_ic
phylloids	18	4	452	3	phylloids
shalloon	11	4	568	3	shalloon
shallop	12	34	845	3	shallo_p
shallops	13	28	832	3	shallops
shallot	10	36	1413	3	shallo_t
shallots	11	31	950	3	shallots
shallow	13	38	887	3	shallo_w
shallowed	16	5	508	3	shallowed
shallows	14	38	886	3	shallows
sialoid	8	3	1096	3	sia_loid
tabloids	11	4	616	3	t_abloids
tallied	8	33	1475	3	t_allied
tallis	6	33	1996	3	t_all_is
tallit	6	34	2273	3	t_all_it
tallol	6	36	1222	3	t_allo_l
tallols	7	33	1136	3	t_allols
tallow	9	37	1420	3	t_allo_w
tallowed	12	15	771	3	t_allowed
tallows	10	33	1374	3	t_allows
tallowy	13	34	763	3	t_allowy
thalami	12	4	608	3	thalami_
thalamic	15	4	555	3	thalamic
thallious	12	4	327	3	thallious
thallium	13	4	443	3	thallium
thallus	10	3	560	3	thall_us
theroid	11	3	1340	3	th_eroid
tholoi	9	33	923	3	th_oloi_
thralled	12	4	580	3	thrall_ed
thylakoid	20	5	205	3	thylakoid
thyreoid	15	4	477	3	thyreoid
thyroid	14	3	825	3	th_yroid
thyrsoid	15	4	419	3	thyrsoid
triploid	11	4	736	3	triploid
valgoid	12	5	521	3	_valgoid

Search took 8 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	146162	0.170	1051123.5
2	DLD Change Limit	146162	84	7.486	19524.7
3	Display Results	84	84	0.046	1826.1
	(SQL Overall)	178691	84	7.702	23200.6