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

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

310 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
threads	11	41	995	(None)
thread	10	50	1109	1	thread_
thready	14	43	590	1	thready
threaps	12	48	864	1	threaps
threats	10	43	1167	1	threats
treads	7	48	1792	1	t_reads
breads	9	54	1920	2	_breads
dreads	8	41	1502	2	_dreads
heads	9	51	2711	2	_h_eads
oreads	7	39	1577	2	_oreads
phreaks	16	3	454	2	phreaks
reads	6	48	3527	2	__reads
rereads	8	15	1229	2	rereads
rethreads	13	4	448	2	rethreads
shreds	10	56	1305	2	shre_ds
spreads	10	3	976	2	spreads
thraws	12	92	1110	2	thr_aws
threaded	13	6	632	2	threaded
threader	12	5	673	2	threader
threaders	13	6	574	2	threaders
threap	11	56	966	2	threa_p
threat	9	50	2046	2	threa_t
threeps	12	68	704	2	threeps
threes	9	71	1732	2	thre_es
throats	10	46	1219	2	throats
tread	6	48	2170	2	t_read_
treats	6	48	2169	2	t_reats
trends	7	55	1354	2	t_rends
triads	7	45	1353	2	t_riads
unthreads	13	4	363	2	unthreads
ahead	9	68	1705	3	ah_ead_
airheads	12	4	613	3	airheads
already	11	4	426	3	already
areas	5	59	3577	3	_area_s
arrears	7	3	884	3	arrears
beads	8	54	2950	3	__beads
beheads	13	3	852	3	beheads
boreas	8	54	2173	3	borea_s
brads	8	55	2829	3	_br_ads
bread	8	55	2311	3	_bread_
bready	12	45	1118	3	_bready
breaks	12	48	1642	3	_breaks
breams	10	48	1504	3	_breams
breeds	9	49	1488	3	_breeds
broads	9	45	1515	3	_broads
bureaus	9	7	929	3	bureaus
byroads	13	3	529	3	byroads
catheads	14	3	812	3	cath_eads
cereals	9	3	1317	3	cereals
chads	11	61	2223	3	ch__ads
cheaps	13	46	1368	3	ch_eaps
cheats	11	45	1954	3	ch_eats
chields	13	50	748	3	chields
choreas	12	44	1420	3	chorea_s
chresards	15	4	327	3	chresards
coheads	13	28	923	3	coheads
coleads	10	29	1142	3	coleads
creaks	12	43	1596	3	_creaks
creams	10	47	1525	3	_creams
creds	8	54	1877	3	_cre_ds
creeds	9	47	1477	3	_creeds
deads	7	57	2691	3	__deads
deleads	9	37	970	3	deleads
dread	7	44	1902	3	_dread_
dreams	9	45	1398	3	_dreams
drears	7	46	1425	3	_drears
dryads	11	43	662	3	_dryads
enneads	8	3	473	3	enneads
farads	10	47	1327	3	far_ads
fatheads	15	3	676	3	fath_eads
freaks	13	47	1306	3	_freaks
grads	7	56	2575	3	_gr_ads
greats	7	63	1839	3	_greats
greeds	8	43	1428	3	_greeds
head	8	71	3717	3	_h_ead_
heady	12	51	1726	3	_h_eady
heals	8	57	3345	3	_h_eals
heaps	10	52	2322	3	_h_eaps
hears	8	67	3737	3	_h_ears
heats	8	58	3840	3	_h_eats
heeds	9	54	2042	3	_h_eeds
heralds	11	3	771	3	_heralds
herds	9	64	2468	3	_h_erds
hexads	17	46	819	3	_hexads
hodads	11	4	796	3	_hodads
hotheads	15	31	801	3	hoth_eads
ihrams	11	3	717	3	ihr_ams
inroads	8	3	704	3	inroads
jarheads	19	4	479	3	jarheads
jereeds	15	32	639	3	jereeds
khedas	14	4	631	3	kh_edas
kneads	11	35	709	3	_kneads
leads	6	60	2849	3	__leads
lipreads	11	4	422	3	lipreads
meads	8	54	2532	3	__meads
misreads	11	26	892	3	misreads
myriads	13	3	435	3	myriads
nereids	8	3	874	3	nereids
oread	6	46	1960	3	_oread_
outreads	9	28	900	3	outreads
phreak	15	3	615	3	phrea_k
pitheads	14	33	814	3	pith_eads
pleads	9	46	1395	3	_pleads
potheads	14	29	854	3	poth_eads
rads	5	60	4660	3	__r_ads
read	5	59	4253	3	__read_
readd	7	46	1713	3	__readd
readds	8	41	1164	3	__readds
ready	9	48	2150	3	__ready
reals	5	50	3865	3	__reals
reams	7	57	2962	3	__reams
reaps	7	56	2619	3	__reaps
rears	5	47	3965	3	__rears
redds	7	46	1783	3	__redds
reds	5	60	4286	3	__re_ds
reeds	6	54	3090	3	__reeds
rends	6	51	2995	3	__rends
reread	7	17	1543	3	reread_
rethread	12	4	535	3	rethread_
retreads	9	3	782	3	retreads
rheas	8	48	1695	3	rh_ea_s
roads	6	65	2362	3	__roads
screaks	13	46	935	3	screaks
screams	11	48	1061	3	screams
screeds	10	62	1028	3	screeds
shads	9	51	2448	3	sh__ads
sheafs	12	49	1288	3	sh_eafs
sheals	9	44	2064	3	sh_eals
shears	9	38	2090	3	sh_ears
sheas	8	63	3179	3	sh_ea_s
sheds	9	61	2270	3	sh_e_ds
shends	10	53	1377	3	sh_ends
sherds	10	56	1472	3	sh_erds
shields	11	53	804	3	shields
shmears	12	7	707	3	shmears
shred	9	81	2561	3	shre_d_
shrewd	13	68	1077	3	shrewd_
shrews	12	93	1391	3	shre_ws
shrouds	11	3	602	3	shrouds
spread	9	3	1253	3	spread_
steads	7	41	1622	3	_steads
streaks	11	44	1127	3	streaks
streams	9	47	1337	3	streams
tads	5	71	4394	3	t___ads
tared	6	93	4005	3	tare_d_
tares	5	74	5656	3	tare__s
tarmacs	11	3	832	3	tarmacs
tarpans	9	25	1353	3	tarpans
tarsals	7	25	1260	3	tarsals
tartans	7	26	1582	3	tartans
tartars	7	33	1340	3	tartars
tarweeds	12	4	427	3	tarweeds
tarzans	16	32	992	3	tarzans
teaks	9	42	2290	3	t__eaks
teals	5	62	3413	3	t__eals
teams	7	57	2651	3	t__eams
tears	5	54	3646	3	t__ears
teas	4	58	5149	3	t__ea_s
teats	5	56	3681	3	t__eats
teds	5	49	3257	3	t__e_ds
tends	6	54	2558	3	t__ends
terais	6	40	2351	3	ter_ais
teredo	7	3	1078	3	tere_do
teredos	8	3	918	3	teredos
terras	6	35	1697	3	terra_s
tetrads	8	29	1019	3	tetrads
thaws	11	65	1546	3	th__aws
thebes	11	59	1449	3	th_ebes
thefts	12	38	792	3	th_efts
thegns	10	54	743	3	th_egns
theins	9	50	1542	3	th_eins
theirs	9	46	1035	3	th_eirs
themes	11	53	1925	3	th_emes
thenars	10	24	852	3	thenars
thens	8	59	2183	3	th_e_ns
therapy	15	3	661	3	therapy
thereat	10	43	1524	3	therea_t
theres	9	65	2547	3	th_eres
theriacs	13	3	654	3	theriacs
therians	11	3	831	3	therians
thermals	13	51	853	3	thermals
thermes	12	62	1461	3	thermes
thermos	12	46	1075	3	thermos
therms	11	59	1487	3	th_erms
theses	9	65	1797	3	th_eses
thesis	9	49	1373	3	th_esis
thesps	11	44	826	3	th_esps
thetas	9	30	1157	3	th_etas
thews	11	74	1619	3	th_e_ws
thieves	13	4	690	3	thieves
thirams	12	3	682	3	thirams
thirds	10	43	860	3	th_irds
thorias	10	23	1205	3	thoria_s
thrall	9	38	1029	3	thr_all
thralls	10	29	904	3	thralls
thrash	12	25	836	3	thr_ash
thrave	12	60	1027	3	thr_ave
thraves	13	46	971	3	thraves
thraw	11	105	1592	3	thr_a_w
thrawn	12	76	942	3	thr_awn
threadfin	16	4	195	3	threadfin
threadfins	17	4	197	3	thread~~fin~~s
threadier	13	5	447	3	threadier
threadiest	14	4	428	3	threadiest
threading	14	10	759	3	threading
threadless	14	4	247	3	thread~~les~~s
threaped	14	5	486	3	threaped
threaper	13	4	514	3	threaper
threapers	14	4	477	3	threapers
threated	12	5	920	3	threated
threaten	11	4	630	3	threaten
threatens	12	5	467	3	threatens
three	8	75	2691	3	thre__e
threep	11	59	1011	3	thre_ep
threnode	12	5	542	3	threnode
threnodes	13	5	496	3	threnodes
threnody	15	4	332	3	threnody
thresh	12	27	686	3	thre_sh
threshes	14	3	738	3	threshes
threw	11	173	1571	3	thre__w
thrifts	13	3	552	3	thrifts
thrills	10	39	878	3	thrills
thrips	11	29	901	3	thr_ips
thrives	13	46	1171	3	thrives
throat	9	48	1975	3	throa_t
throaty	13	42	848	3	throaty
throbs	11	83	1137	3	thr_obs
throes	9	75	1867	3	thr_oes
thrones	10	57	1584	3	thrones
throngs	11	50	816	3	throngs
throws	12	97	1523	3	thr_ows
thrums	11	42	912	3	thr_ums
thrusts	10	22	652	3	thrusts
thruways	17	4	250	3	thruways
thuds	9	51	1013	3	th__uds
thujas	16	3	443	3	thuja_s
thuyas	12	3	477	3	thuya_s
thyroids	15	4	600	3	thyroids
tineas	6	46	1648	3	tinea_s
tineids	8	33	787	3	tineids
tirade	7	3	1169	3	tir_ade
tirades	8	3	1172	3	tir_ades
tired	6	52	2890	3	tire_d_
tires	5	54	3749	3	tire__s
toads	6	56	2107	3	t__oads
toeas	5	57	2642	3	t_oea_s
torahs	9	51	1564	3	tor_ahs
toras	5	55	4037	3	tor_a_s
toreador	9	4	499	3	toreador
toreadors	10	4	514	3	toreadors
toreros	7	3	1134	3	toreros
tores	5	53	5267	3	tore__s
tornado	8	4	567	3	tornado
tornados	9	4	537	3	tornados
toroids	8	3	1064	3	toroids
torpids	10	3	737	3	torpids
torsade	8	3	759	3	torsade
torsades	9	3	721	3	torsades
tortas	6	49	1825	3	torta_s
towheads	15	4	481	3	towheads
trad	5	56	3091	3	t_r_ad_
trade	6	50	2604	3	t_r_ade
trades	7	57	2450	3	t_r_ades
trams	7	53	2767	3	t_r_ams
trans	5	49	3304	3	t_r_ans
traps	7	57	2748	3	t_r_aps
trass	5	62	2647	3	t_r_ass
trays	8	56	2343	3	t_r_ays
treaded	9	50	1428	3	t_readed
treader	8	41	1383	3	t_reader
treaders	9	33	1184	3	t_readers
treadle	8	3	1010	3	t_readle
treadles	9	3	970	3	t_readles
treat	5	62	4035	3	t_rea_t
treaty	9	44	1435	3	t_reaty
treed	6	56	2673	3	t_reed_
treens	6	53	1787	3	t_reens
trees	5	58	3576	3	t_re_es
treks	9	60	1685	3	t_re_ks
trend	6	48	1745	3	t_rend_
trendy	10	46	960	3	t_rendy
trepans	9	23	1159	3	t_repans
tres	4	65	4290	3	t_re__s
tress	5	54	2316	3	t_re_ss
trets	5	59	2802	3	t_re_ts
trews	8	61	1889	3	t_re_ws
treys	8	50	1821	3	t_re_ys
triacs	8	39	1322	3	t_riacs
triad	6	52	1772	3	t_riad_
trials	6	43	1988	3	t_rials
troaks	10	44	1060	3	t_roaks
turbans	9	3	956	3	turbans
turds	6	50	2169	3	tur__ds
tureens	7	28	987	3	tureens
tweaks	13	3	596	3	t_weaks
tweeds	10	49	843	3	t_weeds
tyred	9	58	1643	3	tyre_d_
tyres	8	47	2523	3	tyre__s
unleads	8	22	862	3	unleads
unread	7	34	1267	3	unread_
unready	11	21	594	3	unready
unthread	12	4	460	3	unthread_
untreads	9	3	622	3	untreads
uprears	9	10	749	3	uprears
ureas	5	58	2601	3	_urea_s
warheads	15	4	585	3	warheads
wheals	12	45	1252	3	wh_eals
wheats	12	50	1322	3	wh_eats
whereas	13	44	890	3	wherea_s
wreaks	13	47	1111	3	_wreaks

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	134027	0.393	454684.5
2	DLD Change Limit	134027	310	6.063	22105.7
3	Display Results	310	310	0.093	3333.3
	(SQL Overall)	178691	310	6.549	27285.2