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

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

303 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
retrain	7	6	1542	(None)
detrain	8	4	1225	1	detrain
pretrain	10	3	1092	1	pretrain
refrain	10	3	1004	1	refrain
restrain	8	3	1170	1	restrain
retain	6	45	2328	1	ret_ain
retrains	8	3	1453	1	retrains
certain	9	26	1221	2	certain
detain	7	46	1738	2	det_ain
detrains	9	4	1176	2	detrains
entrain	7	3	1307	2	entrain
pertain	9	27	1496	2	pertain
pretrains	11	4	1014	2	pretrains
reattain	8	4	673	2	reattain
redrawn	11	24	595	2	redrawn
refrains	11	3	959	2	refrains
regain	7	45	1776	2	re_gain
remain	8	59	1986	2	re_main
reordain	9	13	557	2	reordain
reran	5	73	2910	2	re_ra_n
restrains	9	3	1162	2	restrains
restraint	9	4	1275	2	restraint
retail	6	55	2207	2	ret_ail
retains	7	45	2225	2	ret_ains
retrace	9	14	1734	2	retrace
retracing	12	3	1329	2	retracing
retrack	13	13	1072	2	retrack
retract	9	13	1811	2	retract
retrained	10	4	1131	2	retrained
retrainee	9	5	1116	2	retrainee
retral	6	44	1974	2	retra_l
retrial	7	6	1555	2	retrial
retrim	8	35	1488	2	retr_im
retrying	12	24	1045	2	retrying
seatrain	8	4	792	2	seatrain
strain	6	49	1957	2	_strain
terrain	7	4	1085	2	terrain
train	5	65	2911	2	__train
vitrain	10	3	894	2	vitrain
attain	6	3	1175	3	_attain
atwain	9	3	781	3	_atwain
bedrail	10	3	725	3	bedrail
berlin	8	31	1637	3	be_rlin
betaine	9	4	1378	3	bet_aine
betray	11	15	1144	3	betra_y
betraying	15	3	771	3	betraying
betrays	12	12	782	3	betrays
brain	7	62	2938	3	__brain
ceratin	9	30	2016	3	ce_ratin
citrin	8	26	1541	3	citr_in
cretin	8	29	1791	3	cret__in
curtain	9	31	979	3	curtain
deraign	9	3	657	3	de_raign
derail	7	42	1881	3	de_rail
destain	8	4	1208	3	destain
detail	7	45	1643	3	det_ail
detains	8	37	1609	3	det_ains
detract	10	14	1463	3	detract
detrained	11	5	891	3	detrained
dextran	15	8	616	3	dextra_n
dextrin	15	8	754	3	dextr_in
distrain	9	4	1224	3	distrain
drain	6	52	2289	3	__drain
drivetrain	14	5	205	3	drivetrain
elain	5	53	2470	3	_e_lain
engrain	8	3	835	3	engrain
entrains	8	3	1296	3	entrains
estrin	6	3	1592	3	estr_in
etamin	8	13	1185	3	_etamin
eyestrain	12	4	343	3	eyestrain
forebrain	14	4	516	3	forebrain
grain	6	51	2625	3	__grain
heparin	12	4	1043	3	heparin
herein	9	37	1779	3	he_rein
heroin	9	44	2059	3	he_roin
hetman	11	25	1060	3	hetma_n
ingrain	8	3	952	3	ingrain
jerkin	17	25	811	3	je_rkin
keratin	11	33	1415	3	ke_ratin
merlin	8	39	1668	3	me_rlin
metric	10	3	1467	3	metr_ic
metring	10	32	1529	3	metr_ing
mistrain	10	3	1194	3	mistrain
murrain	9	3	776	3	murrain
obtain	8	3	918	3	obt_ain
oestrin	7	3	1224	3	oestr_in
outgain	8	10	1074	3	outgain
outlain	7	12	1261	3	outlain
outran	6	32	1889	3	outra_n
overtrain	12	5	978	3	overtrain
pearmain	12	4	583	3	pearmain
pertains	10	21	1342	3	pertains
petrale	9	3	1262	3	petrale
petsai	8	3	808	3	petsai_
petsais	9	3	843	3	petsais
preordain	12	12	449	3	preordain
pretorian	11	5	1155	3	pretorian
pretrained	13	5	706	3	pretrained
pretrial	10	5	1198	3	pretrial
pretrim	11	3	1078	3	pretr_im
pterin	8	10	1415	3	pter_in
quatrain	17	4	582	3	quatrain
rain	4	62	5173	3	___rain
ratan	5	37	2266	3	rat_a_n
ratlin	6	41	1652	3	rat_lin
rattail	7	3	780	3	rattail
rattan	6	36	1360	3	ratta_n
reagin	7	49	1553	3	re_agin
rearing	8	31	2878	3	rear_ing
rearming	11	14	1361	3	rearming
reattains	9	4	644	3	reattains
reavail	10	3	564	3	reavail
rebait	8	3	2040	3	re_bait
rebegin	10	3	621	3	rebegin
reclaim	11	3	775	3	reclaim
recoin	8	43	2029	3	re_coin
recrate	9	26	2166	3	recrate
recrating	12	13	1879	3	recrating
recrown	12	25	757	3	recrown
recruit	9	3	977	3	recruit
rectrix	16	4	536	3	rectr_ix
redan	6	61	2501	3	re_da_n
redbait	10	3	980	3	redbait
redfin	10	3	1022	3	re_dfin
redraft	11	3	1057	3	redraft
redraw	10	26	985	3	redra_w
redrawing	14	3	721	3	redrawing
redraws	11	21	847	3	redraws
redrying	13	20	902	3	redrying
redskin	12	8	602	3	redskin
redtail	8	5	871	3	redtail
reearn	6	6	1214	3	re_earn
refract	12	13	1160	3	refract
refrained	13	4	722	3	refrained
refrainer	12	4	584	3	refrainer
reframe	12	3	939	3	reframe
reframing	15	3	862	3	reframing
refrying	15	27	890	3	refrying
regains	8	43	1658	3	re_gains
regrade	9	26	1203	3	regrade
regrading	12	12	1020	3	regrading
regraft	11	3	1015	3	regraft
regrant	8	3	1732	3	regrant
regrate	8	26	1866	3	regrate
regrating	11	13	1621	3	regrating
regreen	8	30	904	3	regreen
regrind	9	3	898	3	regr_ind
regrown	11	23	736	3	regrown
rein	4	60	4089	3	re___in
rejoin	13	40	1224	3	re_join
relaid	7	55	1844	3	re_laid
relaxin	14	23	918	3	relaxin
relearn	7	4	797	3	relearn
reloan	6	4	1569	3	reloa_n
remail	8	50	1712	3	re_mail
remains	9	41	1791	3	re_mains
reman	7	57	3015	3	re_ma_n
renail	6	50	2076	3	re_nail
renin	5	48	3003	3	re__nin
rennin	6	39	1403	3	re_nnin
reobtain	10	4	462	3	reobtain
reordains	10	14	545	3	reordains
repaid	9	47	1632	3	re_paid
repaint	9	3	1836	3	re_paint
repair	8	40	1146	3	re_pair
repin	7	53	2470	3	re__pin
replan	8	32	1582	3	repla_n
reprint	9	3	1898	3	repr_int
requin	15	3	1071	3	re_quin
rerack	12	25	1316	3	re_rack
reraise	7	3	1631	3	re_raise
rerig	6	40	1848	3	re_r_ig
rerun	5	87	2215	3	re_r_un
resaid	7	45	1708	3	re_said
resail	6	44	1873	3	re_sail
resawn	9	39	995	3	re_sawn
resilin	7	29	1397	3	resilin
resin	5	41	3105	3	re__sin
resorcin	10	4	682	3	resorcin
restrained	11	4	841	3	restrained
restrainer	10	4	697	3	restrainer
restraints	10	5	660	3	restraints
restring	9	15	1878	3	restr_ing
retack	12	26	1282	3	ret_ack
retag	6	36	1841	3	ret_a_g
retags	7	34	1430	3	ret_ags
retails	7	47	1897	3	ret_ails
retained	9	30	1609	3	ret_ained
retainer	8	29	1381	3	ret_ainer
retake	10	47	1853	3	ret_ake
retaken	11	39	1180	3	retaken
retaking	13	31	1428	3	retaking
retape	8	39	1768	3	ret_ape
retaping	11	30	1255	3	retaping
retard	7	50	1893	3	ret_ard
retarding	11	11	1065	3	retarding
retards	8	50	1500	3	retards
retax	12	45	1797	3	ret_a_x
retaxing	16	23	1133	3	retaxing
retching	14	34	1217	3	retching
reteach	12	3	741	3	reteach
reteam	8	32	1453	3	retea_m
reteaming	12	21	1044	3	reteaming
reteams	9	33	956	3	reteams
retear	6	31	1548	3	retea_r
retearing	10	22	1425	3	retearing
retears	7	28	1492	3	retears
rethink	14	8	888	3	ret_hink
retia	5	53	2611	3	ret__ia
retial	6	47	2499	3	retia_l
retiarii	8	4	415	3	retiarii
retiary	10	3	833	3	retiary
retie	5	57	3530	3	ret__ie
retieing	9	29	1371	3	retieing
retiling	9	33	1948	3	retiling
retiming	11	30	1419	3	retiming
retina	6	50	2338	3	ret__ina
retine	6	62	3733	3	ret__ine
retint	6	56	3344	3	ret__int
retirant	8	3	1359	3	retirant
retiring	9	27	1741	3	retiring
retorn	6	109	2343	3	ret_orn
retorsion	9	4	650	3	retorsion
retorting	10	6	1327	3	retorting
retortion	9	4	967	3	retortion
retraced	11	14	1302	3	retraced
retracer	10	14	1188	3	retracer
retraces	10	14	1727	3	retraces
retracking	17	3	816	3	retracking
retracks	14	14	910	3	retracks
retracting	13	3	1193	3	retracting
retraction	12	13	1053	3	retraction
retracts	10	11	1131	3	retracts
retrainees	10	4	639	3	retrain~~ees~~
retraining	11	3	1024	3	retraining
retrally	11	3	1052	3	retrally
retread	8	4	900	3	retread
retreading	12	12	848	3	retreading
retreads	9	3	782	3	retreads
retreat	7	3	1753	3	retreat
retreating	11	14	1477	3	retreating
retreats	8	3	1141	3	retreats
retrials	8	5	1082	3	retrials
retried	8	44	1915	3	retried
retries	7	41	2907	3	retries
retrims	9	36	1237	3	retrims
retro	5	50	2095	3	retr__o
retroact	10	4	1000	3	retroact
retrofit	11	4	830	3	retrofit
retros	6	38	2019	3	retr_os
retry	8	47	1808	3	retr__y
retsina	7	47	1060	3	ret_sina
retting	8	34	2588	3	ret_ting
retuning	9	3	1158	3	retuning
return	6	232	2252	3	ret_urn
returning	10	3	813	3	returning
retying	11	32	1383	3	ret_ying
retyping	14	25	561	3	retyping
rewan	8	56	2366	3	re_wa_n
rewin	8	56	2396	3	re__win
rewrap	11	12	753	3	rewra_p
rewraps	12	13	656	3	rewraps
rewrapt	12	13	811	3	rewrapt
rutin	5	54	2134	3	rut__in
seatrains	9	4	760	3	seatrains
serai	5	68	3016	3	se_rai_
serail	6	42	2267	3	se_rail
serais	6	43	2613	3	se_rais
serein	6	33	1846	3	se_rein
serin	5	54	3444	3	se_r_in
sextain	14	25	710	3	sextain
sprain	8	36	1486	3	_sprain
stain	5	57	2794	3	_st_ain
stearin	7	3	1200	3	stearin
strains	7	42	1815	3	_strains
strait	6	40	2589	3	_strait
tain	4	55	4807	3	__t_ain
terai	5	35	2548	3	te_rai_
terais	6	40	2351	3	te_rais
terrains	8	4	1032	3	terrains
terrapin	10	4	620	3	terrapin
tertian	7	5	1119	3	tertian
tetra	5	34	1795	3	tetra__
tetracid	11	4	726	3	tetracid
tetrad	7	36	1205	3	tetra_d
tetradic	11	4	581	3	tetradic
tetrads	8	29	1019	3	tetrads
tetragon	9	4	527	3	tetragon
tetras	6	30	1762	3	tetra_s
tetri	5	27	1645	3	tetr_i_
tetris	6	28	1629	3	tetr_is
traik	9	54	1820	3	__traik
trail	5	51	2677	3	__trail
trains	6	47	2534	3	__trains
trait	5	69	4084	3	__trait
twain	8	63	1362	3	__twain
urethan	10	4	547	3	uretha_n
verdin	10	31	1302	3	ve_rdin
vermin	11	34	1452	3	ve_rmin
vervain	13	3	556	3	vervain
veteran	10	3	935	3	vetera_n
vitrains	11	3	828	3	vitrains
zebraic	20	4	429	3	zebraic

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.406	440125.6
2	DLD Change Limit	134027	303	6.360	21073.4
3	Display Results	303	303	0.106	2858.5
	(SQL Overall)	178691	303	6.872	26002.8