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

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

333 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
tracery	12	39	979	(None)
tracer	8	48	2023	1	tracer_
tracers	9	49	1784	1	tracers
bracer	10	46	2058	2	bracer_
bracero	11	42	874	2	bracero
bracers	11	46	1670	2	bracers
bravery	15	42	813	2	bravery
drapery	13	38	794	2	drapery
grapery	13	45	795	2	grapery
grocery	13	33	676	2	grocery
racer	7	52	3302	2	_racer_
racers	8	47	2543	2	_racers
trace	7	58	2961	2	trace__
traced	9	48	2158	2	trace_d
traces	8	53	2993	2	trace_s
tracheary	17	4	480	2	tracheary
tracker	13	35	1517	2	tracker_
trackers	14	35	1285	2	trackers
trader	7	52	1876	2	trader_
traders	8	43	1695	2	traders
tragedy	12	3	479	2	tragedy
treachery	17	4	469	2	treachery
trickery	17	29	734	2	trickery
acerb	9	3	1276	3	__acerb
aery	7	72	3168	3	__a_ery
apery	10	65	1790	3	__apery
archery	15	47	806	3	archery
artery	9	9	1145	3	ar_tery
bakery	15	59	1100	3	_bakery
beanery	12	3	756	3	beanery
brace	9	56	2927	3	brace__
braced	11	54	2060	3	brace_d
braceros	12	39	772	3	braceros
braces	10	84	2777	3	brace_s
bravely	15	42	823	3	bravely
braver	11	47	1904	3	braver_
bravers	12	47	1552	3	bravers
brawer	11	42	1633	3	brawer_
brayer	11	53	1531	3	brayer_
brayers	12	45	1190	3	brayers
brazer	17	49	1753	3	brazer_
brazers	18	45	1394	3	brazers
brewery	15	37	695	3	brewery
bribery	14	42	648	3	bribery
briery	11	45	1077	3	br_iery
chancery	18	36	665	3	chancery
cracker	15	31	1417	3	cracker_
crackers	16	41	1172	3	crackers
crackly	18	39	770	3	crackly
cracky	17	50	1022	3	crac_ky
crater	8	50	2664	3	crater_
craters	9	50	2189	3	craters
craver	11	46	1846	3	craver_
cravers	12	44	1655	3	cravers
creamery	15	38	597	3	creamery
crockery	19	35	660	3	crockery
deanery	11	3	761	3	deanery
dracena	10	3	492	3	dracena
dramedy	14	3	324	3	dramedy
draper	9	43	1569	3	draper_
drapers	10	53	1335	3	drapers
drapey	12	50	1058	3	drape_y
drawer	10	47	1136	3	drawer_
drawers	11	36	1007	3	drawers
eatery	9	53	1635	3	_eatery
embracery	18	9	320	3	embracery
eraser	6	42	1633	3	eraser_
erasers	7	44	1394	3	erasers
facer	10	55	2505	3	_facer_
facers	11	55	1944	3	_facers
faery	11	60	1548	3	_fa_ery
fakery	16	50	926	3	_fakery
farcer	11	50	1608	3	farcer_
farcers	12	47	1344	3	farcers
flackery	20	29	524	3	flackery
framer	11	48	1744	3	framer_
framers	12	51	1382	3	framers
frater	9	45	2059	3	frater_
fraters	10	35	1721	3	fraters
grace	8	51	2454	3	grace__
graced	10	52	1790	3	grace_d
graces	9	45	2349	3	grace_s
grader	8	49	1969	3	grader_
graders	9	47	1601	3	graders
gramary	13	5	590	3	gramary
gramercy	16	4	192	3	gramercy
granary	11	5	779	3	granary
grapey	12	60	1230	3	grape_y
grater	7	46	2544	3	grater_
graters	8	54	1974	3	graters
gravely	14	46	906	3	gravely
graver	10	50	1859	3	graver_
gravers	11	45	1527	3	gravers
grayer	10	60	1454	3	grayer_
grazer	16	48	1576	3	grazer_
grazers	17	51	1245	3	grazers
grocer	9	42	1214	3	grocer_
grocers	10	35	1125	3	grocers
imagery	13	12	420	3	imagery
irately	10	4	768	3	irately
irater	6	52	1835	3	irater_
japery	18	43	914	3	_japery
knackery	16	28	366	3	knackery
knavery	17	3	312	3	knavery
krater	10	40	1431	3	krater_
kraters	11	42	1234	3	kraters
lacer	7	58	3375	3	_lacer_
lacers	8	52	2525	3	_lacers
lacey	10	58	2091	3	_lace_y
larceny	12	3	485	3	larceny
macer	9	121	2694	3	_macer_
macers	10	53	2127	3	_macers
mercery	14	39	762	3	mercery
napery	11	48	981	3	_napery
orangery	12	30	554	3	orangery
oratory	10	3	940	3	oratory
ornery	9	3	846	3	or_nery
orrery	9	3	678	3	or_rery
pacer	9	61	3161	3	_pacer_
pacers	10	51	2454	3	_pacers
pacey	12	67	2028	3	_pace_y
papery	13	48	1274	3	_papery
placer	10	51	1774	3	placer_
placers	11	45	1526	3	placers
prancer	11	36	1338	3	prancer_
prancers	12	32	1033	3	prancers
prater	8	48	2535	3	prater_
praters	9	49	2165	3	praters
prayer	11	48	1529	3	prayer_
prayers	12	42	1285	3	prayers
pricer	10	39	1829	3	pricer_
pricers	11	39	1506	3	pricers
pricey	13	44	1263	3	price_y
prudery	13	3	524	3	prudery
quackery	26	3	311	3	quackery
quavery	22	22	548	3	quavery
race	6	67	4626	3	_race__
raced	8	76	3531	3	_race_d
raceme	10	3	973	3	_raceme
races	7	49	4324	3	_race_s
raceway	15	4	613	3	_raceway
racier	8	51	2097	3	_racier_
racily	11	7	1517	3	_racily
racker	12	48	2455	3	_racker_
rackers	13	43	2045	3	_rackers
rackety	16	49	911	3	_rackety
racy	9	58	2568	3	_rac__y
raker	9	45	2979	3	_raker_
rakers	10	41	2357	3	_rakers
raper	7	49	3275	3	_raper_
rapers	8	43	2718	3	_rapers
rarefy	12	29	634	3	_rarefy
rarely	9	35	1365	3	_rarely
rarer	5	47	3170	3	_rarer_
raser	5	56	3341	3	_raser_
rasers	6	45	2678	3	_rasers
rater	5	49	4328	3	_rater_
raters	6	39	3658	3	_raters
raver	8	56	3149	3	_raver_
ravers	9	46	2818	3	_ravers
rawer	8	46	2373	3	_rawer_
razer	14	48	2427	3	_razer_
razers	15	49	1961	3	_razers
retracer	10	14	1188	3	retracer_
retracers	11	14	955	3	retracers
revery	12	40	1421	3	_revery
ricer	7	47	2661	3	_ricer_
ricers	8	41	2099	3	_ricers
rockery	16	43	925	3	_rockery
ropery	11	43	1387	3	_ropery
rosery	9	38	1328	3	_rosery
rudery	10	41	903	3	_rudery
sealery	10	40	1105	3	sealery
slavery	13	40	789	3	slavery
sorcery	12	3	703	3	sorcery
spacer	10	49	1779	3	spacer_
spacers	11	38	1387	3	spacers
spacey	13	62	1253	3	space_y
spicery	14	49	901	3	spicery
strafer	10	39	1246	3	strafer_
strafers	11	37	991	3	strafers
strategy	12	4	436	3	strategy
strayer	10	43	1250	3	strayer_
strayers	11	35	1014	3	strayers
taber	7	38	2582	3	t_aber_
tabers	8	46	2157	3	t_abers
tace	6	53	4251	3	t_ace__
taces	7	62	3780	3	t_ace_s
tacet	7	58	4002	3	t_ace_t
tacker	12	42	2450	3	t_acker_
tackers	13	43	1962	3	t_ackers
tackey	15	46	1308	3	t_ackey
tacky	14	56	1744	3	t_ac_ky
taker	9	52	2900	3	t_aker_
takers	10	39	2374	3	t_akers
taler	5	60	3486	3	t_aler_
talers	6	46	2814	3	t_alers
tamely	11	37	1195	3	t_amely
tamer	7	52	3010	3	t_amer_
tamers	8	42	2403	3	t_amers
tannery	10	38	866	3	tannery
taper	7	48	2977	3	t_aper_
tapers	8	40	2581	3	t_apers
tarry	8	54	2251	3	t_a_rry
tarter	6	40	2356	3	tarter_
tater	5	41	3861	3	t_ater_
taters	6	49	3220	3	t_aters
tavern	9	42	893	3	t_avern
tawdry	13	39	525	3	t_awdry
tawer	8	52	2344	3	t_awer_
tawers	9	41	1860	3	t_awers
taxer	12	50	1936	3	t_axer_
taxers	13	40	1528	3	t_axers
teaberry	13	4	329	3	teaberry
teacart	9	11	1319	3	teacart
teacher	12	37	1483	3	teacher_
teacherly	17	4	351	3	teacherly
teachers	13	32	1239	3	teachers
tearer	6	48	2290	3	tearer_
tearers	7	52	1823	3	tearers
teary	8	51	2405	3	tea__ry
teaser	6	54	2152	3	teaser_
teasers	7	53	1724	3	teasers
thaler	9	46	1310	3	thaler_
thalers	10	62	1226	3	thalers
thawer	12	48	934	3	thawer_
thawers	13	42	848	3	thawers
timbery	14	25	689	3	timbery
tindery	11	38	936	3	tindery
toggery	12	50	592	3	toggery
tottery	10	38	848	3	tottery
towery	12	40	1209	3	t_owery
traceably	16	4	622	3	traceably
traceried	12	4	714	3	traceried
traceries	11	3	1286	3	traceries
trachea	12	3	1167	3	trachea
tracheae	13	4	911	3	tracheae
tracheal	13	4	825	3	tracheal
tracheas	13	4	1027	3	tracheas
tracheid	14	3	758	3	tracheid
trachle	12	3	1185	3	trachle
tracing	10	37	2015	3	tracing
track	11	48	2301	3	trac__k
tracked	14	37	1613	3	tracked
tracks	12	48	1884	3	trac_ks
trackway	20	11	378	3	trackway
tract	7	56	3571	3	trac__t
tractor	9	3	1133	3	tractor
tractors	10	3	1256	3	tractors
tracts	8	50	1907	3	trac_ts
trade	6	50	2604	3	trade__
traded	8	57	1768	3	trade_d
trades	7	57	2450	3	trade_s
traducer	11	4	458	3	traducer_
traducers	12	4	372	3	traducers
trailer	7	30	1539	3	trailer_
trailers	8	29	1292	3	trailers
trainer	7	33	1679	3	trainer_
trainers	8	31	1464	3	trainers
traject	16	3	704	3	traject
tramcar	11	3	559	3	tramcar_
tramcars	12	4	523	3	tramcars
tramel	8	41	1371	3	trame_l
tramell	9	39	870	3	tramell
tramels	9	38	1249	3	tramels
tramper	11	38	1216	3	tramper_
trampers	12	32	1039	3	trampers
trampy	13	49	925	3	tra_mpy
tramway	15	4	486	3	tramway
trance	8	47	1876	3	trance__
tranced	10	44	1417	3	trance_d
trances	9	39	1964	3	trance_s
tranny	9	42	1086	3	tra_nny
trapes	8	50	2446	3	trape_s
trapeze	18	3	625	3	trapeze
trapper	11	39	1280	3	trapper_
trappers	12	37	1104	3	trappers
trasher	10	44	1613	3	trasher_
trashers	11	30	1364	3	trashers
trashy	12	50	905	3	tra_shy
trave	8	52	2303	3	trave__
travel	9	41	1298	3	trave_l
travels	10	47	1129	3	travels
traverse	11	3	621	3	traverse
traves	9	42	2274	3	trave_s
travesty	14	4	448	3	travesty
trawler	10	40	1190	3	trawler_
trawlers	11	33	1020	3	trawlers
trawley	13	31	730	3	trawley
tray	7	76	3259	3	tra___y
treacly	12	3	709	3	treac_ly
treader	8	41	1383	3	treader_
treaders	9	33	1184	3	treaders
treasury	11	4	379	3	treasury
treater	7	42	1983	3	treater_
treaters	8	36	1584	3	treaters
trey	7	72	2879	3	tr__e_y
trice	7	51	2749	3	trice__
triced	9	55	1867	3	trice_d
tricep	10	39	1107	3	trice_p
triceps	11	26	734	3	triceps
trices	8	48	2633	3	trice_s
tricker	13	46	1552	3	tricker_
trickers	14	38	1281	3	trickers
trickly	16	36	989	3	trickly
tricksy	16	43	658	3	tricksy
tricky	15	42	1147	3	tric_ky
tricorn	9	3	796	3	tricorn
trier	5	43	2853	3	tr_ier_
triers	6	43	2152	3	tr_iers
trimer	8	57	1715	3	trimer_
trimers	9	46	1514	3	trimers
trinary	10	3	917	3	trinary
tritely	10	3	900	3	tritely
triter	6	51	2059	3	triter_
trocar	8	4	877	3	trocar_
trocars	9	5	904	3	trocars
trover	9	50	1466	3	trover_
trovers	10	37	1332	3	trovers
truantry	11	4	254	3	truantry
truce	7	51	1869	3	truce__
truced	9	53	1205	3	truce_d
truces	8	49	1633	3	truce_s
trucker	13	40	1073	3	trucker_
truckers	14	27	901	3	truckers
truer	5	49	1664	3	tr_uer_
trumpery	15	3	361	3	trumpery
tuatera	7	5	637	3	tuatera
turnery	10	35	742	3	turnery
tushery	13	3	563	3	tushery
wafery	15	39	869	3	_wafery
watery	12	39	1449	3	_watery
wavery	15	46	1005	3	_wavery

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.156	1145455.1
2	DLD Change Limit	134027	333	7.486	17903.7
3	Display Results	333	333	0.123	2707.3
	(SQL Overall)	178691	333	7.765	23012.4