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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

165 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
aardvark	16	231	597	(None)
aardvarks	17	185	561	1	aardvarks
airpark	13	4	492	3	air_park
baresark	14	4	387	3	baresark
earmark	13	4	564	3	ear_mark
hardback	20	4	562	3	hardback
hardhack	21	4	383	3	hardhack
hardpack	20	4	392	3	hardpack
hardtack	18	4	399	3	hardtack
hardware	15	4	628	3	hardware
landmark	15	4	414	3	landmark
sardar	7	30	1316	3	sard_ar_
sardars	8	31	1286	3	sard_ars
yardarm	13	11	452	3	yard_arm
yardwork	19	4	450	3	yardwork
aardwolf	15	4	213	4	aardwolf
adverb	12	26	541	4	_a_dverb
advert	10	32	1577	4	_a_dvert
airdate	8	3	1132	4	aird_ate
airfare	10	4	724	4	air_fare
airparks	14	4	390	4	air_parks
airward	11	4	811	4	air_ward
arak	8	69	2957	4	_ar__a_k
ardor	6	46	1786	4	_ard_or_
ardors	7	44	1686	4	_ard_ors
ardour	7	41	1089	4	_ardour_
ardours	8	36	886	4	_ardours
ariary	9	41	1420	4	_ar_iary
arrack	12	11	1021	4	_ar_rack
arrear	6	3	1024	4	_arrear_
arrears	7	3	883	4	_arrears
arrival	10	3	753	4	arriva_l
arrivals	11	4	590	4	arrivals
arriver	10	11	779	4	arriver_
arrivers	11	13	700	4	arrivers
artwork	14	4	707	4	_artwork
arval	8	60	1700	4	_ar_va_l
aurar	5	44	2025	4	aur__ar_
awarder	11	3	588	4	award_er_
awarders	12	4	507	4	award_ers
baidarka	15	4	248	4	baid_arka
ballpark	16	4	375	4	ballpark
bareback	18	4	607	4	bareback
baresarks	15	4	343	4	baresarks
barnyard	14	4	378	4	barnyard
barrack	15	3	821	4	bar_rack
barware	12	6	1070	4	bar_ware
birdfarm	16	4	287	4	birdfarm
boardwalk	19	5	171	4	boardwalk
boshvark	20	4	227	4	boshvark
calvary	15	3	718	4	ca_lvary
caracara	12	4	721	4	caracara
carack	14	21	1313	4	car__ack
caravan	12	3	920	4	carava_n
caravans	13	3	858	4	caravans
carbarn	11	3	945	4	car_barn
cardboard	15	4	584	4	cardboard
cardcase	13	4	594	4	cardcase
carder	9	45	2417	4	card_er_
carders	10	48	2033	4	card_ers
cardia	9	9	1632	4	cardia__
cardiac	12	7	877	4	cardia_c
cardiacs	13	7	687	4	cardiacs
cardiae	10	7	1366	4	cardia_e
cardias	10	7	1503	4	cardia_s
cardsharp	17	5	253	4	cardsharp
carfare	12	3	1006	4	car_fare
carjack	22	4	612	4	car_jack
carrack	15	4	871	4	car_rack
carver	11	44	2014	4	car_ver_
carvers	12	48	1751	4	car_vers
charivari	17	4	255	4	charivari
darbar	9	5	993	4	dar_bar_
darbars	10	5	1007	4	dar_bars
dark	9	51	3321	4	___d_ark
earmarks	14	4	478	4	ear_marks
farmwork	20	4	418	4	farmwork
farmyard	17	4	283	4	farmyard
garboard	12	4	723	4	garboard
garda	7	3	1676	4	gard_a__
gardai	8	3	965	4	gard_a_i
gardant	9	3	1446	4	gard_ant
gaydar	11	3	550	4	gayd_ar_
gaydars	12	3	579	4	gayd_ars
hallmark	17	4	421	4	hallmark
handcar	13	3	737	4	handcar_
handcars	14	3	761	4	handcars
handcart	14	4	932	4	handcart
handwork	19	4	690	4	handwork
hardass	11	3	974	4	hard_ass
hardbacks	21	4	535	4	hardbacks
hardball	14	11	629	4	hardball
hardboard	16	4	556	4	hardboard
hardcase	14	4	560	4	hardcase
hardcore	14	4	600	4	hardcore
harder	10	50	2239	4	hard_er_
hardhacks	22	4	369	4	hardhacks
hardhat	14	4	1101	4	hardha_t
hardhats	15	4	682	4	hardhats
hardier	11	47	2152	4	hardier_
hardpacks	21	4	361	4	hardpacks
hardpan	13	3	644	4	hardpa_n
hardpans	14	3	644	4	hardpans
hardtacks	19	4	378	4	hardtacks
hardwares	16	4	656	4	hardwares
hardwire	15	4	462	4	hardwire
landmarks	16	4	360	4	landmarks
landward	13	4	580	4	landward
larboard	11	5	765	4	larboard
larder	7	37	2097	4	lard_er_
larders	8	35	1693	4	lard_ers
lardier	8	35	1831	4	lardier_
larva	8	3	1248	4	lar_va__
larvae	9	3	882	4	lar_va_e
larval	9	4	849	4	lar_va_l
larvas	9	3	1023	4	lar_va_s
marinara	10	4	646	4	marinara
mudlark	14	6	391	4	_mudlark
navar	8	39	1273	4	na__var_
navars	9	28	1057	4	na__vars
padauk	13	3	563	4	pa_d_auk
paravane	13	4	806	4	paravane
pardah	12	34	1281	4	pard_a_h
pardahs	13	28	965	4	pard_ahs
pardner	10	23	946	4	pardner_
pardners	11	26	919	4	pardners
radar	6	13	1671	4	ra_d_ar_
radars	7	13	1464	4	ra_d_ars
remark	12	35	1236	4	__remark
repark	12	35	1171	4	__repark
salivary	14	4	472	4	salivary
samovar	12	4	423	4	samovar_
samovars	13	4	369	4	samovars
sandbank	15	4	485	4	sandbank
sandbar	10	10	818	4	sandbar_
sandbars	11	10	876	4	sandbars
sardana	8	3	863	4	sard_ana
sarsar	6	30	1183	4	sar_sar_
sarsars	7	35	1211	4	sar_sars
serovar	10	4	613	4	serovar_
serovars	11	4	522	4	serovars
sirdar	7	26	908	4	sird_ar_
sirdars	8	22	819	4	sird_ars
tanbark	13	3	737	4	ta_nbark
tardier	8	597	1994	4	tardier_
tartar	6	32	1474	4	tar_tar_
tartare	7	30	1267	4	tar_tare
tartars	7	33	1340	4	tar_tars
trademark	16	5	189	4	trademark
valvar	12	38	865	4	va_lvar_
wardenry	15	4	297	4	wardenry
warder	10	40	2026	4	ward_er_
warders	11	34	1679	4	ward_ers
warfare	13	3	673	4	war_fare
warwork	17	5	756	4	war_work
woodlark	16	9	330	4	woodlark
yardage	12	3	573	4	yard_age
yardarms	14	12	331	4	yard_arms
yardbird	15	4	231	4	yardbird
yarder	10	38	1396	4	yard_er_
yarders	11	32	1158	4	yard_ers
yardland	13	4	374	4	yardland
yardman	13	3	590	4	yardma_n
yardwand	16	4	272	4	yardwand
yardworks	20	4	448	4	yardworks

Search took 12 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	161609	0.143	1249587.4
2	DLD Change Limit	161609	165	10.920	14799.4
3	Display Results	165	165	0.063	2619.0
	(SQL Overall)	178691	165	11.126	16060.7