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

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

324 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
trifid	10	3	906	(None)
bifid	11	9	1070	2	_bifid
frigid	11	3	692	2	frigid
rigid	7	9	1389	2	_rigid
teiid	6	3	1253	2	tei_id
timid	8	48	1573	2	t_imid
trepid	9	3	1008	2	trepid
triacid	10	3	859	2	triacid
triad	6	52	1772	2	tri_ad
triced	9	55	1867	2	triced
tried	6	50	2691	2	tri_ed
trifle	9	40	1288	2	trifle
trifled	11	37	1196	2	trifled
trifold	11	3	624	2	trifold
trined	7	49	2071	2	trined
trioxid	15	4	661	2	trioxid
tripod	9	39	985	2	tripod
trivia	9	3	850	2	trivia
aerified	12	13	1013	3	aerified
aramid	9	33	1561	3	aramid
arid	5	76	4271	3	ar__id
ariled	7	56	2032	3	ariled
aroid	6	54	2834	3	ar_oid
braid	8	58	2226	3	br_aid
briard	9	43	1129	3	briard
bribed	11	53	1284	3	bribed
briefed	13	3	574	3	briefed
brined	9	51	1841	3	brined
bromid	11	26	1289	3	bromid
coifed	12	41	1306	3	coifed
cricoid	12	3	924	3	cricoid
cried	8	46	2428	3	cri_ed
crinoid	10	3	994	3	crinoid
crisic	10	36	1184	3	crisic
crisis	8	37	1634	3	crisis
critic	10	36	1681	3	critic
deific	12	3	731	3	deific
deified	12	31	1241	3	deified
dried	7	53	2138	3	dri_ed
drift	9	57	2284	3	drif_t
drifted	12	36	795	3	drifted
drifts	10	49	989	3	drifts
drifty	13	41	822	3	drifty
droid	7	42	1854	3	dr_oid
druid	7	41	1132	3	dr_uid
edified	12	33	971	3	edified
ericoid	10	4	989	3	ericoid
fid	7	68	4768	3	___fid
fifed	12	51	1597	3	_fifed
fried	9	53	2291	3	fri_ed
friend	10	38	893	3	friend
frized	19	35	1068	3	frized
gravid	11	37	1098	3	gravid
grid	6	58	2961	3	gr__id
grided	9	51	1704	3	grided
griff	12	44	1646	3	grif_f
griffe	13	43	809	3	griffe
griffin	14	3	451	3	griffin
griffs	13	39	899	3	griffs
grift	9	59	2446	3	grif_t
grifted	12	37	958	3	grifted
grifts	10	45	1168	3	grifts
grimed	10	47	1409	3	grimed
grind	7	59	1756	3	gri_nd
griped	10	41	1471	3	griped
imid	7	61	2229	3	__imid
irid	5	59	2717	3	__irid
iridic	9	32	874	3	iridic
irised	7	39	1315	3	irised
iritic	8	32	1382	3	iritic
iritis	6	31	1373	3	iritis
knifed	14	52	812	3	knifed
lipid	8	59	1617	3	_lipid
livid	9	67	1442	3	_livid
metrified	15	4	785	3	metrified
nitid	6	18	1783	3	_nitid
nitrified	13	4	672	3	nitrified
opioid	9	3	1008	3	opioid
orchid	12	8	957	3	orchid
oribi	7	3	1109	3	oribi_
oribis	8	3	883	3	oribis
orifice	12	4	634	3	orifice
origin	7	3	1103	3	origin
petrified	15	4	833	3	petrified
prebid	11	35	1284	3	prebid
prefix	18	35	685	3	prefix
priced	11	50	1888	3	priced
prided	10	36	1803	3	prided
pried	8	44	2686	3	pri_ed
primed	11	51	1891	3	primed
primi	9	50	1740	3	primi_
prised	9	43	2220	3	prised
prized	18	44	1539	3	prized
profit	11	30	1627	3	profit
purified	14	3	874	3	purified
rabid	8	45	2078	3	_rabid
raid	5	52	4307	3	_r_aid
ranid	6	64	2933	3	_ranid
rapid	8	64	2203	3	_rapid
rarified	12	3	905	3	rarified
rebid	8	51	2136	3	_rebid
redid	7	49	2239	3	_redid
refed	9	39	2192	3	_refed
refind	10	47	1707	3	_refind
refit	8	42	3006	3	_refit
refix	15	52	1248	3	_refix
reified	11	29	1378	3	reified
resid	6	41	2409	3	_resid
riced	8	58	2554	3	_riced
ricin	7	46	2021	3	_ricin
rid	4	67	5462	3	_r__id
rif	6	59	5156	3	_rif__
rife	7	46	3232	3	_rif_e
rifer	8	47	2198	3	_rifer
riff	10	44	3010	3	_rif_f
riffed	13	38	1156	3	_riffed
riffs	11	51	1461	3	_riffs
rifle	8	55	1833	3	_rifle
rifled	10	41	1500	3	_rifled
riflip	11	3	472	3	_riflip
rifs	7	49	2900	3	_rif_s
rift	7	56	4233	3	_rif_t
rifted	10	41	1531	3	_rifted
rifts	8	57	1864	3	_rifts
riled	6	58	3325	3	_riled
rimed	8	48	2637	3	_rimed
rind	5	65	3560	3	_ri_nd
riped	8	52	2643	3	_riped
rived	9	48	2561	3	_rived
saiyid	10	16	741	3	saiyid
serifed	11	8	1146	3	serifed
strafed	11	44	1333	3	strafed
strife	9	53	1836	3	strif_e
strifes	10	47	1658	3	strifes
strigil	8	3	726	3	strigil
striped	10	52	1436	3	striped
strived	11	47	1366	3	strived
sulfid	10	3	906	3	sulfid
tabid	8	44	1826	3	t_abid
taffia	12	28	690	3	taffia
tafia	8	42	1549	3	t_afia
tailed	7	44	2466	3	tailed
tailfin	10	3	569	3	tailfin
tariff	12	7	1136	3	tarif_f
tariffed	15	3	372	3	tariffed
tariffs	13	3	459	3	tariffs
teiids	7	3	669	3	tei_ids
teind	6	2	1361	3	tei_nd
tepid	8	3	1431	3	t_epid
terrific	13	4	480	3	terrific
terrified	13	14	757	3	terrified
third	9	59	1249	3	thi_rd
thrift	12	4	1204	3	thrif_t
thrifts	13	3	552	3	thrifts
thrifty	16	3	419	3	thrifty
thrived	14	45	818	3	thrived
tibia	7	3	1240	3	t_ibia
tided	7	63	2251	3	t_ided
tidied	8	36	1327	3	t_idied
tied	5	55	3521	3	t_i_ed
tiff	10	47	2772	3	t_if_f
tiffed	13	36	839	3	tiffed
tiffin	12	32	793	3	tiffin
tiffs	11	44	1488	3	t_iffs
tiki	8	76	2084	3	t_iki_
tikis	9	56	1597	3	t_ikis
tiled	6	48	3294	3	t_iled
timed	8	52	2361	3	t_imed
tined	6	54	3453	3	t_ined
tineid	7	44	1202	3	tineid
tipi	6	99	2443	3	t_ipi_
tipis	7	60	1992	3	t_ipis
tired	6	52	2890	3	t_ired
tirled	7	47	1436	3	tirled
titi	4	71	3061	3	t_iti_
titis	5	60	2381	3	t_itis
toiled	7	44	2032	3	toiled
toited	7	40	1675	3	toited
toluid	7	3	821	3	toluid
torii	5	55	2159	3	tori_i_
toroid	7	4	1601	3	toroid
torpid	9	3	1091	3	torpid
torrid	7	3	1185	3	torrid
torrified	13	12	559	3	torrified
toxoid	14	3	815	3	toxoid
traced	9	48	2158	3	traced
trad	5	56	3091	3	tr__ad
traded	8	57	1768	3	traded
traffic	15	4	473	3	traffic
tragi	6	47	1717	3	tragi_
tragic	9	38	1154	3	tragic
traik	9	54	1820	3	tr_aik
traiked	12	33	1045	3	traiked
trail	5	51	2677	3	tr_ail
trailed	8	34	1567	3	trailed
train	5	65	2911	3	tr_ain
trained	8	41	1720	3	trained
trait	5	69	4084	3	tr_ait
tread	6	48	2170	3	tr_ead
treed	6	56	2673	3	tr_eed
tref	7	70	3099	3	tref__
trefah	12	3	509	3	trefah
trefoil	10	6	606	3	trefoil
trend	6	48	1745	3	tr_end
triac	7	41	1637	3	tri_ac
triacids	11	4	672	3	triacids
triacs	8	39	1322	3	triacs
triadic	10	3	783	3	triadic
triads	7	45	1353	3	triads
triage	7	28	1289	3	triage
triaged	9	28	1044	3	triaged
trial	5	49	2635	3	tri_al
trials	6	43	1988	3	trials
triazin	16	3	820	3	triazin
tribade	10	3	729	3	tribade
tribal	8	6	1113	3	tribal
tribe	7	44	2027	3	tri_be
tribes	8	51	1902	3	tribes
trice	7	51	2749	3	tri_ce
tricep	10	39	1107	3	tricep
trices	8	48	2633	3	trices
trichoid	14	5	781	3	trichoid
tricing	10	34	1735	3	tricing
trick	11	54	2069	3	tri_ck
tricked	14	40	1616	3	tricked
trickie	13	26	1103	3	trickie
tricks	12	53	1901	3	tricks
tricky	15	42	1147	3	tricky
triclad	10	3	744	3	triclad
tricot	8	3	1775	3	tricot
triene	6	43	1638	3	triene
triens	6	54	1754	3	triens
trier	5	43	2853	3	tri_er
triers	6	43	2152	3	triers
tries	5	57	4281	3	tri_es
trifler	10	39	1215	3	trifler
trifles	10	38	1482	3	trifles
trifling	12	24	1150	3	trifling
triforia	11	4	564	3	triforia
triform	12	3	784	3	triform
trig	5	55	2816	3	tr__ig
trigged	10	35	985	3	trigged
trigly	10	38	1094	3	trigly
trigo	6	57	1605	3	tri_go
trigon	7	45	1310	3	trigon
trigos	7	42	1417	3	trigos
trigs	6	54	2306	3	tri_gs
trijet	13	39	1655	3	trijet
trike	9	53	2016	3	tri_ke
trikes	10	54	1949	3	trikes
trilby	11	4	497	3	trilby
trilith	10	3	1051	3	trilith
trill	5	51	2293	3	tri_ll
trilled	8	41	1631	3	trilled
trills	6	43	1985	3	trills
trim	6	53	2951	3	tr__im
trimer	8	57	1715	3	trimer
trimly	11	44	1089	3	trimly
trimmed	12	34	893	3	trimmed
trims	7	50	2147	3	tri_ms
trinal	6	5	1696	3	trinal
trine	5	47	3460	3	tri_ne
trines	6	41	3256	3	trines
trining	8	29	1921	3	trining
trinity	10	3	1084	3	trinity
trio	4	52	3334	3	tr__io
triode	7	53	1189	3	triode
triol	5	55	2136	3	tri_ol
triols	6	61	1780	3	triols
trios	5	55	2809	3	tri_os
triose	6	47	1538	3	triose
trioxide	16	4	479	3	trioxide
trioxids	16	4	444	3	trioxids
trip	6	68	3039	3	tr__ip
tripe	7	54	2538	3	tri_pe
tripes	8	53	2487	3	tripes
triple	8	42	1592	3	triple
tripled	10	41	1383	3	tripled
triploid	11	4	736	3	triploid
triply	11	42	1102	3	triply
tripods	10	35	905	3	tripods
tripody	13	39	598	3	tripody
tripos	8	40	1492	3	tripos
tripped	12	39	1169	3	tripped
trippy	13	45	780	3	trippy
trips	7	49	2336	3	tri_ps
trismic	11	3	748	3	trismic
triste	6	38	1864	3	triste
trite	5	47	3003	3	tri_te
triter	6	51	2059	3	triter
tritium	9	6	901	3	tritium
triton	6	39	1489	3	triton
triune	6	42	1018	3	triune
trivet	9	37	2188	3	trivet
trivial	10	3	871	3	trivial
trivium	12	5	614	3	trivium
trod	5	76	2795	3	tr__od
trois	5	72	2609	3	tr_ois
troked	11	41	1458	3	troked
tropic	10	30	1419	3	tropic
tropin	8	33	1675	3	tropin
trowed	10	47	1465	3	trowed
truced	9	53	1205	3	truced
trued	6	51	1769	3	tr_ued
truffe	12	7	623	3	truffe
tumid	8	41	1402	3	t_umid
turbid	9	7	971	3	turbid
turfed	10	31	1096	3	turfed
turgid	8	6	801	3	turgid
twibil	11	3	356	3	twibil
twilit	9	4	955	3	twilit
twined	10	44	1312	3	twined
typified	17	4	392	3	typified
unific	11	3	746	3	unific
unified	11	24	1357	3	unified
ursid	6	3	1148	3	ur_sid
verified	15	15	1039	3	verified
virid	9	41	1604	3	_virid
viroid	10	4	1152	3	viroid
vitrified	16	4	598	3	vitrified
vivid	12	51	1231	3	_vivid
waifed	13	40	1103	3	waifed
wifed	12	51	1774	3	_wifed
wried	9	55	1856	3	wri_ed

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	112716	0.266	671770.7
2	DLD Change Limit	112716	324	6.796	16585.6
3	Display Results	324	324	0.190	1705.3
	(SQL Overall)	178691	324	7.252	24640.2