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

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

73 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
finless	10	28	1078	(None)
kinless	11	33	1027	1	kinless
sinless	7	30	1421	1	sinless
winless	10	32	1228	1	winless
aidless	8	36	1207	2	aidless
aimless	9	36	1081	2	aimless
airless	7	37	1204	2	airless
awnless	10	3	592	2	awnless
bibless	11	43	917	2	bibless
chinless	13	3	749	2	chinless
fangless	12	3	766	2	fangless
fatless	10	32	1220	2	fatless
feeless	10	35	1110	2	feeless
fernless	11	3	606	2	fernless
filers	9	46	2372	2	fi_lers
files	8	54	4127	2	fi_le_s
filets	9	47	1895	2	fi_lets
fillers	10	43	2021	2	fillers
filles	9	42	2452	2	fille_s
fillets	10	34	1475	2	fillets
filmless	13	4	455	2	filmless
finales	10	40	1601	2	finale_s
finders	11	37	1787	2	finders
fineness	11	3	1064	2	fineness
fines	8	66	4426	2	fin_e_s
finesse	10	18	764	2	fin_esse
finest	9	43	2173	2	fin_est
fingers	11	34	1843	2	fingers
finises	10	3	1290	2	finises
fireless	11	28	1059	2	fireless
fishless	14	3	641	2	fishless
fitness	10	29	939	2	fitness
flyless	13	3	500	2	flyless
fogless	11	3	819	2	fogless
fulness	10	24	896	2	fulness
furless	10	32	1014	2	furless
gainless	9	11	740	2	gainless
gunless	8	29	963	2	gunless
hipless	12	39	992	2	hipless
hitless	10	32	1119	2	hitless
inkless	11	34	871	2	_inkless
inlets	6	39	1557	2	_inlets
innless	7	28	829	2	innless
kindless	13	28	924	2	kindless
kingless	13	28	869	2	kingless
lidless	8	30	927	2	lidless
lineless	8	27	1194	2	lineless
lintless	8	27	1001	2	lintless
lipless	9	25	955	2	lipless
manless	9	30	1293	2	manless
mindless	11	31	944	2	mindless
painless	10	10	834	2	painless
rainless	8	12	970	2	rainless
reinless	8	13	943	2	reinless
ribless	9	34	1034	2	ribless
rimless	9	36	936	2	rimless
rindless	9	25	1019	2	rindless
runless	7	28	1042	2	runless
skinless	12	21	697	2	skinless
sonless	7	26	1261	2	sonless
spinless	10	23	870	2	spinless
sunless	7	30	1369	2	sunless
tieless	7	25	1256	2	tieless
tintless	8	23	986	2	tintless
tipless	9	26	1006	2	tipless
unless	6	24	1307	2	_unless
veinless	11	13	626	2	veinless
wigless	11	35	967	2	wigless
windless	12	33	1086	2	windless
wineless	11	27	1117	2	wineless
wingless	12	29	1002	2	wingless
witless	10	33	1098	2	witless
zipless	18	27	630	2	zipless

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	107671	0.373	479064.3
2	DLD Change Limit	107671	73	2.923	36835.8
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	3.326	53725.5