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

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

280 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
ratteen	7	32	911	(None)
ratteens	8	25	605	1	ratteens
ratten	6	42	1738	1	ratt_en
atween	9	16	661	2	_atween
batten	8	52	1712	2	batt_en
canteen	9	4	1108	2	canteen
fatten	9	43	1490	2	fatt_en
lateen	6	40	1486	2	la_teen
latten	6	50	1820	2	latt_en
pattee	8	43	2338	2	pattee_
patten	8	44	1819	2	patt_en
pattern	9	37	1205	2	pattern
potteen	9	31	967	2	potteen
rattan	6	36	1360	2	ratt_an
ratted	7	49	2334	2	ratt_ed
rattened	9	21	862	2	rattened
rattener	8	23	853	2	rattener
rattens	7	42	1340	2	rattens
ratter	6	43	2631	2	ratt_er
ratters	7	44	2247	2	ratters
rattier	7	40	1559	2	rattier
rattle	6	47	1761	2	rattle_
rattled	8	40	1295	2	rattled
rattler	7	40	1274	2	rattler
rattles	7	32	1730	2	rattles
ratton	6	41	1612	2	ratt_on
rattoon	7	35	924	2	rattoon
rotten	6	41	1543	2	rott_en
sateen	6	38	1501	2	sa_teen
anteed	7	56	1611	3	_anteed
astern	6	48	1581	3	_astern
attain	6	3	1175	3	_attain
attend	7	25	897	3	_attend
attent	6	28	1832	3	_attent
attest	6	26	1861	3	_attest
attorn	6	3	1079	3	_attorn
attune	6	3	798	3	_attune
baleen	8	6	1305	3	ba_leen
batmen	10	44	1430	3	ba_tmen
batsmen	11	4	688	3	batsmen
batteau	9	3	634	3	batteau
batted	9	56	2365	3	batt_ed
battement	13	5	777	3	battement
battened	11	25	957	3	battened
battener	10	36	939	3	battener
battens	9	53	1326	3	battens
batter	8	49	2887	3	batt_er
battered	11	33	1505	3	battered
batterer	10	27	1321	3	batterer
batters	9	46	2601	3	batters
battery	12	49	1181	3	battery
battier	9	35	1571	3	battier
battle	8	52	1786	3	battle_
battled	10	42	1312	3	battled
battler	9	41	1338	3	battler
battles	9	45	1768	3	battles
battue	8	43	1100	3	battue_
battues	9	46	1019	3	battues
between	12	3	469	3	between
bitten	8	47	1512	3	bitt_en
bittern	9	48	1068	3	bittern
brattier	10	4	766	3	brattier
brattle	9	24	925	3	brattle_
brattled	11	19	672	3	brattled
brattles	10	19	933	3	brattles
canteens	10	3	857	3	canteens
careen	8	41	1949	3	ca_reen
catted	9	54	2247	3	catt_ed
cattery	12	38	1160	3	cattery
cattie	8	52	2102	3	cattie_
cattier	9	33	1707	3	cattier
catties	9	40	2305	3	catties
cattle	8	51	1890	3	cattle_
cattlemen	13	4	433	3	cattlemen
cittern	9	33	914	3	cittern
dasheen	11	3	639	3	dasheen
draftee	11	37	952	3	draftee_
draftees	12	22	525	3	draftees
dratted	9	35	859	3	dratt_ed
earthen	10	3	925	3	earthen
eastern	7	44	1253	3	eastern
eaten	5	53	2305	3	ea_t_en
fasten	9	51	1489	3	fast_en
fatted	10	54	1984	3	fatt_ed
fattened	12	26	828	3	fattened
fattener	11	26	811	3	fattener
fattens	10	51	1171	3	fattens
fatter	9	45	2321	3	fatt_er
fattest	10	29	1306	3	fattest
fattier	10	35	1346	3	fattier
fatties	10	30	1820	3	fatties
fifteen	13	4	392	3	fifteen
flatten	10	42	965	3	flatt_en
gatemen	10	4	760	3	gatemen
gittern	8	33	750	3	gittern
gotten	7	34	1011	3	gott_en
grantee	8	32	1713	3	grantee_
grantees	9	25	1097	3	grantees
grutten	8	8	528	3	grutt_en
hapten	11	53	1298	3	hapt_en
haptene	12	38	1093	3	haptene
hasten	9	57	1856	3	hast_en
hatted	10	49	2151	3	hatt_ed
hatter	9	47	2487	3	hatt_er
hatters	10	42	2152	3	hatters
kamseen	13	4	401	3	kamseen
kitten	10	46	1148	3	kitt_en
lactean	9	5	647	3	lactean
lantern	7	3	1001	3	lantern
lateens	7	42	1055	3	la_teens
laten	5	43	2834	3	la_t_en
latte	5	54	2630	3	latt_e_
lattens	7	50	1467	3	lattens
latter	6	50	2789	3	latt_er
lattes	6	53	2420	3	latt_es
lattin	6	43	1622	3	latt_in
litten	6	40	1487	3	litt_en
marten	8	45	1826	3	mart_en
matte	7	56	2684	3	matt_e_
matted	9	45	2141	3	matt_ed
matter	8	43	2534	3	matt_er
mattered	11	24	1290	3	mattered
matters	9	44	2175	3	matters
mattery	12	38	1071	3	mattery
mattes	8	56	2453	3	matt_es
mattin	8	44	1663	3	matt_in
mitten	8	39	1409	3	mitt_en
nankeen	11	3	504	3	nankeen
natter	6	44	2074	3	natt_er
nattered	9	20	1162	3	nattered
natters	7	37	1806	3	natters
nattier	7	36	1462	3	nattier
oaten	5	52	2240	3	oa_t_en
outseen	7	27	1233	3	outseen
pastern	9	44	1506	3	pastern
paten	7	48	2734	3	pa_t_en
patted	9	47	2468	3	patt_ed
pattened	11	29	939	3	pattened
pattens	9	54	1492	3	pattens
patter	8	46	2826	3	patt_er
pattered	11	27	1420	3	pattered
patterer	10	31	1217	3	patterer
patterns	10	43	994	3	patterns
patters	9	48	2519	3	patters
pattie	8	40	2096	3	pattie_
patties	9	34	2514	3	patties
posteen	9	35	1262	3	posteen
postteen	10	5	569	3	postteen
poteen	8	35	1426	3	_poteen
potheen	12	25	789	3	potheen
potteens	10	25	679	3	potteens
prattle	9	20	883	3	prattle_
prattled	11	24	653	3	prattled
prattler	10	16	634	3	prattler
prattles	10	18	940	3	prattles
preteen	9	3	987	3	preteen
puttee	8	59	1972	3	puttee_
puttees	9	36	1291	3	puttees
rafted	10	47	1470	3	raft_ed
rafter	9	45	1758	3	raft_er
raftered	12	3	766	3	raftered
rafters	10	37	1563	3	rafters
raftsmen	13	4	395	3	raftsmen
ragee	6	54	3266	3	ra_gee_
ragees	7	46	1866	3	ra_gees
raggee	8	42	1760	3	raggee_
raggees	9	37	1091	3	raggees
ragmen	9	37	1218	3	ra_gmen
ragweed	12	3	507	3	ragweed
rakee	9	60	3117	3	ra_kee_
rakees	10	45	1697	3	ra_kees
ramee	7	46	3385	3	ra_mee_
ramees	8	46	2089	3	ra_mees
ramen	7	56	2519	3	ra__men
ranee	5	54	3810	3	ra_nee_
ranees	6	46	2396	3	ra_nees
ranted	7	43	2470	3	rant_ed
ranter	6	38	2682	3	rant_er
ranters	7	33	2364	3	ranters
rappee	10	36	1867	3	rappee_
rappees	11	36	1145	3	rappees
rappen	10	35	1271	3	ra_ppen
raster	6	47	3144	3	rast_er
rasters	7	46	2902	3	rasters
ratafee	10	4	752	3	ratafee
ratafees	11	4	414	3	ratafees
ratan	5	37	2266	3	ra_t_an
ratches	12	36	2046	3	ratches
ratchet	12	42	1833	3	ratchet
rate	4	54	5876	3	ra_t_e_
rated	6	54	4138	3	ra_t_ed
ratel	5	42	2488	3	ra_t_el
ratels	6	45	1821	3	ra_tels
rater	5	49	4328	3	ra_t_er
raters	6	39	3658	3	ra_ters
rates	5	53	5201	3	ra_t_es
rathe	8	58	2192	3	ra_the_
rather	9	43	1974	3	ra_ther
ratine	6	51	3182	3	ratine_
ratines	7	53	2858	3	ratines
ration	6	42	2601	3	ra_tion
ratite	6	50	2242	3	ratite_
ratites	7	49	2068	3	ratites
ratlin	6	41	1652	3	ra_tlin
ratline	7	45	1780	3	ratline
ratoon	6	44	1737	3	ra_toon
rattail	7	3	780	3	rattail
rattans	7	34	1195	3	rattans
ratteners	9	23	726	3	ratteners
rattening	10	28	876	3	rattening
rattiest	8	35	1611	3	rattiest
ratting	8	38	2236	3	ratting
rattish	10	5	1082	3	rattish
rattlers	8	35	1029	3	rattlers
rattling	9	25	1087	3	rattling
rattly	9	41	1154	3	ratt_ly
rattons	7	38	1532	3	rattons
rattoons	8	32	751	3	rattoons
rattrap	9	4	526	3	rattrap
ratty	8	48	1959	3	ratt__y
raven	8	47	2344	3	ra__ven
razee	14	58	2780	3	ra_zee_
razeed	16	37	1001	3	ra_zeed
razees	15	43	1476	3	ra_zees
reattain	8	4	673	3	reattain
regreen	8	30	904	3	regreen
repattern	11	4	366	3	repattern
reseen	6	43	1841	3	r_eseen
retaken	11	39	1180	3	retaken
retene	6	92	2427	3	r_etene
retted	7	48	2631	3	rett_ed
ritter	6	38	2242	3	ritt_er
ritters	7	40	2062	3	ritters
rontgen	8	3	517	3	rontgen
rotte	5	46	2593	3	rott_e_
rotted	7	45	2443	3	rott_ed
rottener	8	21	697	3	rottener
rotter	6	43	2546	3	rott_er
rotters	7	44	2139	3	rotters
rottes	6	45	2483	3	rott_es
routemen	10	10	581	3	routemen
rutted	7	45	1840	3	rutt_ed
ruttier	7	34	1228	3	ruttier
saltern	7	40	1065	3	saltern
sateens	7	37	1075	3	sa_teens
sauteed	8	34	961	3	sauteed
settee	6	37	2102	3	settee_
settees	7	35	1363	3	settees
sitten	6	41	1382	3	sitt_en
sixteen	14	3	411	3	sixteen
slattern	8	3	709	3	slattern
subteen	9	3	852	3	subteen
suttee	6	37	2154	3	suttee_
suttees	7	41	1406	3	suttees
tatted	7	49	2053	3	tatt_ed
tatter	6	40	2457	3	tatt_er
tattered	9	20	1144	3	tattered
tatters	7	45	2048	3	tatters
tattie	6	48	1751	3	tattie_
tattier	7	42	1624	3	tattier
tatties	7	41	2034	3	tatties
tattle	6	41	1565	3	tattle_
tattled	8	43	1148	3	tattled
tattler	7	31	1221	3	tattler
tattles	7	36	1628	3	tattles
tauten	6	43	1189	3	taut_en
teen	4	59	3820	3	___teen
treen	5	56	2275	3	__treen
tween	8	44	1374	3	__tween
umpteen	11	4	384	3	umpteen
vatted	10	42	1473	3	vatt_ed
watter	9	32	2198	3	watt_er
wattest	10	24	1215	3	wattest
wattle	9	43	1421	3	wattle_
wattled	11	36	1050	3	wattled
wattles	10	38	1407	3	wattles
written	10	33	634	3	writt_en
yatter	9	41	1621	3	yatt_er
yattered	12	23	953	3	yattered
yatters	10	39	1462	3	yatters

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	134027	0.423	422437.4
2	DLD Change Limit	134027	280	6.903	19415.8
3	Display Results	280	280	0.110	2545.5
	(SQL Overall)	178691	280	7.436	24030.5