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

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

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.

50 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
deairing	10	3	1189	(None)
desiring	10	3	1214	1	desiring
airing	7	49	2750	2	__airing
bearing	10	36	2477	2	bea_ring
bemiring	13	23	960	2	bemiring
chairing	14	31	1077	2	chairing
dairying	13	3	635	2	d_airying
daring	8	49	2868	2	d_a_ring
dealing	9	43	2323	2	dea_ling
deaning	9	40	2047	2	dea_ning
deashing	13	42	1095	2	deashing
deaving	12	38	1475	2	dea_ving
debarring	13	3	571	2	debarring
debiting	12	25	1120	2	debiting
deciding	13	22	1083	2	deciding
defiling	13	28	1246	2	defiling
defining	13	37	1180	2	defining
deicing	11	3	1219	2	de_icing
deliming	12	3	1037	2	deliming
demising	12	20	1252	2	demising
derailing	11	20	1131	2	derailing
deriding	11	25	1293	2	deriding
deriving	13	25	1074	2	deriving
despairing	14	4	506	2	despairing
detailing	11	25	1041	2	detailing
detaining	11	25	1047	2	detaining
deviling	13	118	1285	2	deviling
devising	13	31	1152	2	devising
draining	10	33	1267	2	draining
earing	7	52	3548	2	_ea_ring
earring	8	35	1901	2	_earring
fairing	11	36	1401	2	_fairing
fearing	11	35	2003	2	fea_ring
gearing	9	28	1884	2	gea_ring
glairing	10	4	728	2	glairing
hearing	11	33	2416	2	hea_ring
heiring	11	33	1290	2	he_iring
lairing	8	37	1534	2	_lairing
nearing	8	30	2033	2	nea_ring
pairing	10	37	1673	2	_pairing
rearing	8	31	2878	2	rea_ring
refiring	12	35	1392	2	refiring
rehiring	12	29	1188	2	rehiring
repairing	12	3	1001	2	repairing
retiring	9	27	1741	2	retiring
rewiring	12	29	1122	2	rewiring
searing	8	33	3092	2	sea_ring
tearing	8	40	2149	2	tea_ring
wairing	11	34	1431	2	_wairing
wearing	11	33	1886	2	wea_ring

Search took 4 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	121059	0.373	479064.3
2	DLD Change Limit	121059	50	3.593	33693.0
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	3.982	44874.7