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

Here are the results of your fuzzy-string dictionary search for “topiary” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

98 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
topiary	12	4	581	(None)
apiary	11	39	1038	2	_apiary
ariary	9	41	1420	3	_ariary
aviary	12	33	841	3	_aviary
biliary	12	3	821	3	biliary
briary	11	49	1200	3	_briary
ciliary	12	4	792	3	ciliary
copay	12	65	1631	3	cop_a_y
copier	10	37	2289	3	copier_
copiers	11	42	1596	3	copiers
coppery	16	40	939	3	coppery
covary	14	3	874	3	co_vary
diary	9	50	1697	3	__diary
dopier	9	35	1592	3	dopier_
dopily	12	35	1046	3	dopi_ly
expiry	18	3	465	3	expi_ry
foliar	9	32	1097	3	foliar_
foppery	17	38	562	3	foppery
friary	12	40	1009	3	_friary
goliard	9	3	607	3	goliard
hoary	11	45	1676	3	ho__ary
horary	12	3	1038	3	ho_rary
hosiery	13	33	718	3	hosiery
laniary	10	6	801	3	laniary
lapidary	14	5	409	3	lapidary
miliary	12	4	946	3	miliary
mopery	13	52	1097	3	mop_ery
mopier	10	39	1478	3	mopier_
mortary	12	36	904	3	mortary
notary	9	23	1071	3	no_tary
olivary	13	4	516	3	_olivary
opiate	8	5	1346	3	_opiate
ostiary	10	3	646	3	ostiary
ovary	11	4	911	3	_o_vary
podiatry	14	4	435	3	podiatry
poniard	10	3	758	3	poniard
popery	13	45	1170	3	pop_ery
poplar	10	36	1111	3	poplar_
poplars	11	39	1033	3	poplars
pupilary	15	10	412	3	pupilary
retiary	10	3	833	3	retiary
ropery	11	43	1387	3	rop_ery
ropier	8	41	1880	3	ropier_
ropily	11	33	1244	3	ropi_ly
rosary	9	28	1035	3	ro_sary
rotary	9	24	1130	3	ro_tary
solidary	12	4	510	3	solidary
solitary	11	4	650	3	solitary
spiry	10	50	1735	3	_spi_ry
tapir	7	59	1706	3	tapi_r_
tapirs	8	41	1317	3	tapi_rs
teary	8	51	2405	3	t__eary
tepidly	13	3	440	3	tepidly
ternary	10	3	834	3	ternary
tertiary	11	4	543	3	tertiary
tiara	5	3	1591	3	t__iara
tipcart	11	4	883	3	tipcart
toady	9	68	1434	3	to__ady
today	9	64	1695	3	to_da_y
toggery	12	50	592	3	toggery
tokay	12	55	1305	3	to_ka_y
tolar	5	55	2411	3	to_lar_
tolars	6	48	1794	3	to_lars
tonearm	9	3	744	3	tonearm
tonier	6	55	2071	3	tonier_
topaz	16	3	1532	3	top_a_z
toper	7	52	3102	3	top_er_
topers	8	50	2532	3	top_ers
topi	6	78	3039	3	topi___
topiaries	11	4	711	3	topiaries
topic	9	57	2150	3	topi__c
topical	11	3	995	3	topical
topically	16	4	953	3	topically
topics	10	47	1458	3	topi_cs
toping	9	41	2299	3	topi_ng
topis	7	60	2583	3	topi__s
topmast	11	3	812	3	topmast
topper	10	38	1760	3	topper_
toppers	11	39	1460	3	toppers
topsail	9	7	652	3	topsail
topwork	16	4	634	3	topwork
torpidly	14	8	364	3	torpidly
tory	7	58	4054	3	to___ry
tottery	10	38	848	3	tottery
toward	10	3	1106	3	to_ward
towery	12	40	1209	3	to_wery
trinary	10	3	917	3	trinary
tripart	9	3	1143	3	tripart
turbary	12	3	638	3	turbary
typier	11	3	733	3	typier_
typify	17	3	452	3	typi_fy
utopia	8	10	788	3	utopia__
utopian	9	12	627	3	utopia_n
utopians	10	9	490	3	utopians
utopias	9	11	772	3	utopia_s
vespiary	16	4	274	3	vespiary
votary	12	24	833	3	vo_tary
zonary	18	3	879	3	zo_nary

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.186	960704.3
2	DLD Change Limit	134027	98	7.190	18640.8
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	7.406	24127.9