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

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

113 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
aardvarks	17	185	561	(None)
aardvark	16	231	597	1	aardvark_
airparks	14	4	390	3	air_parks
baresarks	15	4	343	3	baresarks
earmarks	14	4	478	3	ear_marks
hardbacks	21	4	535	3	hardbacks
hardhacks	22	4	369	3	hardhacks
hardpacks	21	4	361	3	hardpacks
hardtacks	19	4	378	3	hardtacks
hardwares	16	4	656	3	hardwares
landmarks	16	4	360	3	landmarks
sardars	8	31	1286	3	sard_ar_s
yardarms	14	12	331	3	yard_arms
yardworks	20	4	448	3	yardworks
adverbs	13	25	427	4	_a_dverbs
adverts	11	30	850	4	_a_dverts
airdates	9	3	970	4	aird_ates
airfares	11	4	668	4	air_fares
airpark	13	4	492	4	air_park_
araks	9	48	2088	4	_ar__a_ks
ardors	7	44	1686	4	_ard_or_s
ardours	8	36	886	4	_ardour_s
arracks	13	8	771	4	_ar_racks
arrears	7	3	883	4	_arrear_s
arrivals	11	4	590	4	arriva_ls
arrivers	11	13	700	4	arriver_s
artworks	15	4	652	4	_artworks
awarders	12	4	507	4	award_er_s
baidarka	15	4	248	4	baid_arka
baidarkas	16	4	211	4	baid_arkas
ballparks	17	4	320	4	ballparks
baresark	14	4	387	4	baresark_
barnyards	15	4	347	4	barnyards
barracks	16	3	685	4	bar_racks
barwares	13	6	1009	4	bar_wares
birdfarms	17	4	185	4	birdfarms
boardwalks	20	5	134	4	boardwalks
boshvarks	21	4	198	4	boshvarks
caracaras	13	4	681	4	caracaras
caracks	15	22	1153	4	car__acks
caravans	13	3	858	4	carava_ns
carbarns	12	3	854	4	car_barns
cardboards	16	4	531	4	cardboards
cardcases	14	4	645	4	cardcases
carders	10	48	2033	4	card_er_s
cardiacs	13	7	687	4	cardia_cs
cardias	10	7	1503	4	cardia__s
cardsharps	18	5	188	4	cardsharps
carfares	13	3	1029	4	car_fares
carjacks	23	4	553	4	car_jacks
carracks	16	3	768	4	car_racks
carvers	12	48	1751	4	car_ver_s
charivaris	18	5	303	4	charivaris
darbars	10	5	1007	4	dar_bar_s
darks	10	67	2787	4	___d_arks
earmark	13	4	564	4	ear_mark_
farmworks	21	4	384	4	farmworks
farmyards	18	4	280	4	farmyards
garboards	13	4	634	4	garboards
gaydars	12	3	579	4	gayd_ar_s
hallmarks	18	4	353	4	hallmarks
handcars	14	3	761	4	handcar_s
handcarts	15	4	552	4	handcarts
handworks	20	4	669	4	handworks
hardass	11	3	974	4	hard_a_ss
hardback	20	4	562	4	hardback_
hardballs	15	11	552	4	hardballs
hardboards	17	4	514	4	hardboards
hardcores	15	4	593	4	hardcores
hardhack	21	4	383	4	hardhack_
hardhats	15	4	682	4	hardha_ts
hardpack	20	4	392	4	hardpack_
hardpans	14	3	644	4	hardpa_ns
hardtack	18	4	399	4	hardtack_
hardware	15	4	628	4	hardwar_e
hardwires	16	4	464	4	hardwires
landmark	15	4	414	4	landmark_
landwards	14	4	548	4	landwards
larboards	12	4	696	4	larboards
larders	8	35	1693	4	lard_er_s
larvas	9	3	1023	4	lar_va__s
marinaras	11	4	551	4	marinaras
mudlarks	15	4	288	4	_mudlarks
navars	9	28	1057	4	na__var_s
padauks	14	4	393	4	pa_d_auks
paravanes	14	4	825	4	paravanes
pardahs	13	28	965	4	pard_a_hs
pardners	11	26	919	4	pardner_s
radars	7	13	1464	4	ra_d_ar_s
remarks	13	32	998	4	__remarks
reparks	13	24	951	4	__reparks
samovars	13	4	369	4	samovar_s
sandbanks	16	4	418	4	sandbanks
sandbars	11	10	876	4	sandbar_s
sardanas	9	3	777	4	sard_anas
sardar	7	30	1316	4	sard_ar__
sarsars	7	35	1211	4	sar_sar_s
serovars	11	4	522	4	serovar_s
sirdars	8	22	819	4	sird_ar_s
tanbarks	14	4	555	4	ta_nbarks
tartars	7	33	1340	4	tar_tar_s
trademarks	17	5	169	4	trademarks
warders	11	34	1679	4	ward_er_s
warfares	14	3	668	4	war_fares
warworks	18	7	704	4	war_works
woodlarks	17	10	313	4	woodlarks
yardages	13	3	618	4	yard_ages
yardarm	13	11	452	4	yard_ar_m
yardbirds	16	4	214	4	yardbirds
yarders	11	32	1158	4	yard_er_s
yardlands	14	4	355	4	yardlands
yardwands	17	4	266	4	yardwands
yardwork	19	4	450	4	yardwork_

Search took 11 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	165329	0.200	893455.0
2	DLD Change Limit	165329	113	10.720	15422.5
3	Display Results	113	113	0.063	1793.7
	(SQL Overall)	178691	113	10.983	16269.8