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

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

334 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
attain	6	3	1175	(None)
attains	7	3	1098	1	attains
attaint	7	3	1347	1	attaint
atwain	9	3	781	1	atwain
abstain	9	4	725	2	abstain
actin	7	49	2255	2	act_in
again	6	52	1812	2	a_gain
amain	7	49	2291	2	a_main
atman	7	55	2014	2	atma_n
attach	11	11	839	2	attach
attack	12	14	815	2	attack
attained	9	9	735	2	attained
attainer	8	11	691	2	attainer
attaints	8	4	649	2	attaints
attar	5	65	1669	2	atta_r
attars	6	45	1531	2	attars
attic	7	56	1835	2	att_ic
attorn	6	3	1079	2	attorn
attrit	6	3	1575	2	attrit
captain	11	21	1106	2	captain
cattail	9	3	918	2	cattail
detain	7	46	1738	2	detain
lattin	6	43	1622	2	latt_in
mattin	8	44	1663	2	matt_in
obtain	8	3	918	2	obtain
rattail	7	3	780	2	rattail
rattan	6	36	1360	2	ratta_n
reattain	8	4	673	2	reattain
retain	6	45	2328	2	retain
stain	5	57	2794	2	_stain
statin	6	39	2147	2	statin
strain	6	49	1957	2	strain
tain	4	55	4807	2	__tain
train	5	65	2911	2	_train
twain	8	63	1362	2	_twain
abating	10	4	1397	3	abating
abatis	8	43	1793	3	abatis
abstains	10	4	732	3	abstains
acetin	8	3	1469	3	acetin
acrasin	9	3	1122	3	acrasin
acta	6	95	2480	3	acta__
acting	9	59	2098	3	act_ing
actins	8	63	2110	3	act_ins
action	8	47	1968	3	action
adjoin	14	10	729	3	adjoin
adman	8	45	1790	3	adma_n
affair	12	3	435	3	affair
afraid	10	4	972	3	afraid
agin	5	61	3271	3	a__gin
agnail	7	3	953	3	agnail
ain	3	75	7909	3	___ain
akin	8	63	2803	3	a__kin
alan	4	68	4408	3	a_la_n
alanin	6	3	1727	3	alanin
alation	7	29	2055	3	alation
alcaic	10	3	998	3	alcaic
aldrin	7	3	1124	3	aldrin
alevin	9	25	1151	3	alevin
alexin	13	23	1148	3	alexin
algin	6	57	1876	3	a_lgin
alkalin	11	17	818	3	alkalin
aloin	5	52	2742	3	a_loin
altar	5	55	2064	3	alta_r
altars	6	45	1815	3	altars
alumin	8	5	1354	3	alumin
amidin	9	40	1567	3	amidin
amin	6	60	4225	3	a__min
anilin	6	4	1779	3	anilin
anta	4	68	3958	3	anta__
antacid	10	3	1122	3	antacid
antae	5	68	2829	3	anta_e
antas	5	54	3203	3	anta_s
anteing	8	3	1281	3	anteing
anti	4	55	3636	3	ant_i_
antiair	7	3	1031	3	antiair
antiar	6	3	1717	3	antiar
antiarin	8	4	1390	3	antiarin
antic	7	57	2886	3	ant_ic
anting	7	58	2702	3	ant_ing
antis	5	50	3331	3	ant_is
antlion	7	3	1029	3	antlion
apian	7	50	1833	3	apia_n
arraign	8	4	506	3	arraign
arshin	9	3	1217	3	arshin
artal	5	55	2547	3	arta_l
assai	5	7	1154	3	assai_
assail	6	6	1015	3	assail
assais	6	7	1196	3	assais
astasia	7	3	1093	3	astasia
astatic	9	5	1419	3	astatic
astatine	8	3	1353	3	astatine
astern	6	48	1581	3	astern
astir	5	55	1709	3	ast_ir
ataman	8	10	1306	3	ataman
atap	6	67	2245	3	a_ta_p
ataps	7	64	1483	3	a_taps
atavic	11	18	929	3	atavic
ataxia	13	17	959	3	ataxia
ataxic	15	16	920	3	ataxic
ataxy	15	3	731	3	a_taxy
atelic	8	3	1370	3	atelic
atlas	5	58	2158	3	atla_s
atlatl	6	3	787	3	atlatl
atma	6	81	2177	3	atma__
atmans	8	44	1396	3	atmans
atmas	7	57	2101	3	atma_s
atomic	10	41	1560	3	atomic
atonia	6	38	1651	3	atonia
atonic	8	34	2047	3	atonic
atoning	8	35	1487	3	atoning
atopic	10	35	1414	3	atopic
atrazine	17	4	840	3	atrazine
atria	5	60	2234	3	a_tria
atrial	6	54	1894	3	atrial
atrip	7	53	1575	3	a_trip
atropin	9	3	1158	3	atropin
att	3	54	5465	3	att___
attaboy	12	6	430	3	attaboy
attache	12	10	669	3	attache
attaching	15	4	543	3	attaching
attacking	16	3	532	3	attacking
attacks	13	12	694	3	attacks
attagirl	9	4	203	3	attagirl
attainder	10	10	339	3	attain~~der~~
attainers	9	11	559	3	attain~~ers~~
attaining	10	4	722	3	attaining
attainted	10	4	469	3	attain~~ted~~
attend	7	25	897	3	attend
attent	6	28	1832	3	attent
attest	6	26	1861	3	attest
attics	8	44	1328	3	attics
attire	6	24	1238	3	attire
attiring	9	3	948	3	attiring
attorns	7	3	844	3	attorns
attract	9	5	1183	3	attract
attrite	7	3	1183	3	attrite
attrits	7	3	1061	3	attrits
attune	6	3	798	3	attune
attuning	9	3	590	3	attuning
atween	9	16	661	3	atween
atypic	13	33	765	3	atypic
autoing	8	3	1404	3	autoing
autumn	8	3	601	3	autumn
auxin	12	14	1191	3	a_uxin
avail	8	3	1388	3	a_vail
avian	8	46	1605	3	avia_n
avidin	10	35	1084	3	avidin
await	8	55	2449	3	a_wait
axman	14	48	1318	3	axma_n
ayin	7	63	3174	3	a__yin
azan	13	65	2178	3	a_za_n
bargain	10	7	906	3	bargain
batman	10	52	1406	3	batma_n
battalia	10	4	529	3	battalia
battalion	11	4	408	3	battalion
batten	8	52	1712	3	batt_en
battik	12	3	809	3	batt_ik
batting	10	44	2227	3	batt_ing
battling	11	31	1049	3	battling
betaine	9	4	1378	3	betaine
blain	7	54	2179	3	_blain
brain	7	62	2938	3	_brain
caftan	11	17	1012	3	cafta_n
cain	6	56	4391	3	__cain
calpain	11	3	1041	3	calpain
captains	12	18	1057	3	captains
captan	10	16	1334	3	capta_n
catkin	12	35	1238	3	catkin
catlin	8	38	1908	3	catlin
cattails	10	3	855	3	cattails
cattalo	9	3	842	3	cattalo
cattie	8	52	2102	3	catt_ie
catting	10	39	2264	3	catt_ing
certain	9	26	1221	3	certain
chain	10	57	2367	3	_chain
citrin	8	26	1541	3	citrin
coattail	10	4	531	3	coattail
cocain	10	13	1501	3	cocain
contain	9	3	1583	3	contain
cotan	7	15	2178	3	cota_n
curtain	9	31	979	3	curtain
cutin	7	50	2278	3	cut_in
destain	8	4	1208	3	destain
detail	7	45	1643	3	detail
detains	8	37	1609	3	detains
detrain	8	4	1225	3	detrain
distain	8	3	1378	3	distain
domain	9	5	1132	3	domain
drain	6	52	2289	3	_drain
elain	5	53	2470	3	_elain
entail	6	11	1434	3	entail
entrain	7	3	1307	3	entrain
estrin	6	3	1592	3	estrin
etamin	8	13	1185	3	etamin
fain	7	58	4056	3	__fain
fantail	10	3	1023	3	fantail
fatten	9	43	1490	3	fatt_en
fatting	11	38	1870	3	fatt_ing
fusain	9	5	864	3	fusain
gain	5	60	4216	3	__gain
gastrin	8	3	983	3	gastrin
gittin	7	29	1055	3	gittin
grain	6	51	2625	3	_grain
gratin	7	45	2058	3	gratin
hatpin	11	26	1061	3	hatpin
hatting	11	39	2023	3	hatt_ing
isatin	6	4	1221	3	isatin
kaftan	13	18	582	3	kafta_n
kain	8	53	3429	3	__kain
lain	4	61	4628	3	__lain
latten	6	50	1820	3	latt_en
lattins	7	41	1548	3	latt_ins
litai	5	52	1636	3	litai_
lutein	6	3	1126	3	lutein
main	6	53	4552	3	__main
maintain	10	7	772	3	maintain
martian	9	35	1468	3	martian
martin	8	41	2252	3	mart_in
matin	7	51	3285	3	mat_in
matting	10	36	2014	3	matt_ing
mattins	9	33	1614	3	matt_ins
mattoid	10	7	928	3	mattoid
natation	8	15	1393	3	natation
obtains	9	3	916	3	obtains
octan	7	13	1348	3	octa_n
ordain	7	8	1040	3	ordain
ottar	5	43	1399	3	otta_r
ottars	6	41	1222	3	ottars
ottava	9	6	368	3	ottava
outgain	8	10	1074	3	outgain
outlain	7	12	1261	3	outlain
outsin	6	36	1756	3	outsin
oxtail	13	3	765	3	oxtail
pain	6	56	4724	3	__pain
papain	10	3	1379	3	papain
partan	8	38	2056	3	parta_n
patin	7	68	3285	3	pat_in
patten	8	44	1819	3	patt_en
pattern	9	37	1205	3	pattern
pattie	8	40	2096	3	patt_ie
patting	10	37	2234	3	patt_ing
pertain	9	27	1496	3	pertain
plain	7	48	2330	3	_plain
plantain	10	4	790	3	plantain
pterin	8	10	1415	3	pterin
ptomain	11	4	696	3	ptomain
ptyalin	12	7	478	3	ptyalin
quatrain	17	4	582	3	quatrain
rain	4	62	5173	3	__rain
ratan	5	37	2266	3	rata_n
ratlin	6	41	1652	3	ratlin
rattails	8	3	713	3	rattails
rattans	7	34	1195	3	rattans
ratteen	7	32	911	3	ratteen
ratten	6	42	1738	3	ratt_en
ratting	8	38	2236	3	ratt_ing
rattling	9	25	1087	3	rattling
ratton	6	41	1612	3	ratt_on
rattoon	7	35	924	3	rattoon
reattains	9	4	644	3	reattains
regain	7	45	1776	3	regain
remain	8	59	1986	3	remain
retail	6	55	2207	3	retail
retains	7	45	2225	3	retains
retrain	7	6	1542	3	retrain
rutin	5	54	2134	3	rut_in
sain	4	55	5129	3	__sain
satin	5	59	3522	3	sat_in
seatrain	8	4	792	3	seatrain
sextain	14	25	710	3	sextain
slain	5	49	2357	3	_slain
sprain	8	36	1486	3	sprain
staid	6	67	2208	3	_staid
staig	6	55	1964	3	_staig
stains	6	49	2365	3	_stains
stair	5	47	1994	3	_stair
static	8	31	1868	3	static
stating	8	37	2516	3	stating
statins	7	37	1977	3	statins
station	7	27	1724	3	station
stearin	7	3	1200	3	stearin
stein	5	46	2054	3	_stein
stoai	5	54	1787	3	stoai_
stotin	6	32	1506	3	stotin
strains	7	42	1815	3	strains
strait	6	40	2589	3	strait
sustain	7	3	877	3	sustain
swain	8	49	1905	3	_swain
tail	4	54	4365	3	__tail
tains	5	49	3632	3	__tains
taint	5	55	4228	3	__taint
takin	9	49	2130	3	_takin
tamarin	9	3	1191	3	tamarin
tamein	8	3	1309	3	tamein
tan	3	71	6757	3	__ta_n
tannin	6	26	1392	3	tannin
tarn	4	68	4272	3	__tarn
tartan	6	42	1751	3	tarta_n
tatami	8	3	919	3	tatami
tatamis	9	3	972	3	tatamis
tatar	5	61	2206	3	tata_r
tatars	6	46	1979	3	tatars
tattie	6	48	1751	3	tattie
tatting	8	40	1952	3	tatting
tattling	9	25	947	3	tattling
than	7	61	2877	3	_tha_n
thein	8	59	1902	3	_thein
thin	7	67	3239	3	__thin
tin	3	63	6217	3	__t_in
titan	5	33	1817	3	tita_n
titian	6	25	1266	3	titian
toxin	12	47	1671	3	_toxin
traik	9	54	1820	3	_traik
trail	5	51	2677	3	_trail
trains	6	47	2534	3	_trains
trait	5	69	4084	3	_trait
twains	9	58	1118	3	_twains
twin	7	60	2308	3	__twin
tyin	7	64	2400	3	__tyin
vain	7	52	3300	3	__vain
vatting	11	36	1485	3	vatt_ing
vitamin	12	3	742	3	vitamin
vitrain	10	3	894	3	vitrain
wagtail	11	4	504	3	wagtail
wain	7	58	4020	3	__wain
wattage	11	8	698	3	wattage
wattape	12	13	538	3	wattape
wattling	12	25	878	3	wattling
witan	8	38	1650	3	wita_n
within	12	36	1138	3	within
xanthin	17	4	704	3	xanthin
yttria	9	5	480	3	yttria
yttric	11	4	543	3	yttric
zeatin	15	4	1282	3	zeatin

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.126	1418182.5
2	DLD Change Limit	112716	334	5.530	20382.6
3	Display Results	334	334	0.110	3036.4
	(SQL Overall)	178691	334	5.766	30990.5