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

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

78 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
airports	10	4	646	(None)
airport	9	5	1138	1	airport_
airposts	10	4	592	1	airposts
airboats	10	4	728	2	airboats
airparks	14	4	391	2	airparks
airpost	9	3	924	2	airpost_
carports	12	3	894	2	carports
disports	11	11	1111	2	disports
imports	11	30	962	2	_imports
purports	12	6	578	2	purports
aborts	8	49	1618	3	a__borts
airboat	9	5	1213	3	airboat_
airborne	10	4	451	3	airborne
airburst	10	4	423	3	airburst
airbursts	11	4	257	3	airbursts
airdrops	11	4	434	3	airdrops
airers	6	49	2231	3	air_er_s
airfares	11	4	669	3	airfares
airfoils	11	4	400	3	airfoils
airholes	11	3	803	3	airholes
airlifts	11	4	363	3	airlifts
airpark	13	4	492	3	airpar_k
airplays	13	4	453	3	airplays
airpower	13	4	398	3	airpower
airpowers	14	4	347	3	airpowers
airproof	13	4	513	3	airproof
airproofs	14	4	335	3	airproofs
airshots	11	4	594	3	airshots
airts	5	56	2634	3	ai___rts
airworthy	18	5	182	3	airworthy
allsorts	8	4	492	3	allsorts
aport	7	54	3217	3	a__port_
arbores	9	40	1603	3	a_rbores
arbors	8	47	1788	3	a_rbor_s
ardors	7	44	1687	3	a_rdor_s
argots	7	41	1603	3	a_rgo_ts
armors	8	50	1781	3	a_rmor_s
arpents	9	36	1308	3	a_rpents
assorts	7	33	1015	3	a_ssorts
auroras	7	3	1170	3	aur_oras
awlworts	14	4	359	3	awlworts
bistorts	10	11	881	3	bistorts
carport	11	3	1603	3	carport_
comports	14	34	1198	3	comports
deports	10	50	1288	3	_deports
disparts	11	10	995	3	disparts
disport	10	10	1595	3	disport_
distorts	9	11	1235	3	distorts
exports	16	4	798	3	_exports
figworts	15	4	468	3	figworts
firepots	13	4	689	3	firepo_ts
gosports	11	8	591	3	gosports
hairworks	19	4	484	3	hairworks
hairworms	17	4	397	3	hairworms
imparts	11	29	853	3	_imparts
import	10	27	1376	3	_import_
imposts	11	26	900	3	_imposts
intorts	7	3	1097	3	_intorts
jetports	17	4	353	3	jetports
lakeports	15	4	338	3	lakeports
mirrors	9	3	862	3	mirror_s
misparts	12	10	817	3	misparts
misreports	14	4	394	3	misreports
missorts	10	3	832	3	missorts
outports	10	4	827	3	outports
passports	13	4	424	3	passports
pieforts	13	4	486	3	pieforts
ports	7	59	3459	3	___ports
purport	11	5	939	3	purport_
rapports	12	4	596	3	rapports
reimports	13	4	366	3	reimports
reports	9	49	1621	3	_reports
ribworts	13	4	509	3	ribworts
riposts	9	27	940	3	ri_posts
seaports	10	3	846	3	seaports
sports	8	46	1918	3	__sports
supports	12	4	651	3	supports
torpors	9	3	938	3	torpor_s

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	146162	0.170	1051123.5
2	DLD Change Limit	146162	78	7.423	19690.4
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.623	23441.0