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

Here are the results of your fuzzy-string dictionary search for “classify” 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
classify	16	4	469	(None)
classily	13	3	662	1	classily
clarify	15	3	609	2	cla_rify
classic	11	37	1011	2	classi_c
classico	12	38	630	2	classico
classics	12	41	887	2	classics
classier	10	35	908	2	classier
classing	11	32	1179	2	classing
classis	9	37	1272	2	classi_s
classism	12	40	717	2	classism
classist	10	40	1038	2	classist
classy	11	37	904	2	class__y
declassify	19	5	223	2	declassify
glassily	12	3	546	2	glassily
reclassify	18	5	246	2	reclassify
basify	14	3	751	3	_ba_sify
brassily	13	3	662	3	brassily
calcify	17	3	587	3	c_alcify
carnify	15	5	588	3	c_arnify
casefy	14	3	627	3	c_a_sefy
cassia	8	37	1476	3	c_assi_a
cassias	9	35	1434	3	c_assias
cassina	9	41	1316	3	c_assina
cassine	9	38	1728	3	c_assine
cassino	9	35	1243	3	c_assino
cassis	8	48	1885	3	c_assi_s
chassis	12	39	1066	3	chassi_s
chastity	16	4	527	3	chastity
clammily	17	4	363	3	clammily
clarity	12	3	1091	3	cla_rity
clashing	14	38	1219	3	clashing
clasping	13	33	1026	3	clasping
class	7	55	2548	3	class___
classed	10	41	1365	3	class_ed
classer	9	36	1461	3	class_er
classers	10	41	1183	3	classers
classes	9	47	1794	3	class_es
classical	13	4	529	3	classical
classiest	11	30	955	3	classiest
classified	16	4	428	3	classified
classifier	15	4	385	3	classifier
classifies	15	5	500	3	classifies
classifying	20	5	320	3	classify~~ing~~
classisms	13	29	552	3	classisms
classists	11	29	624	3	classists
classon	9	3	769	3	class_on
classons	10	3	770	3	classons
clastic	11	30	1396	3	clasti_c
clastics	12	28	1141	3	clastics
clumsily	15	4	400	3	clumsily
coalify	15	3	668	3	coa_lify
coassist	10	29	880	3	coassist
crassly	12	7	665	3	crass_ly
falsify	16	4	361	3	_falsify
flashily	17	3	547	3	flashily
flossily	14	3	452	3	flossily
gasify	13	3	633	3	_ga_sify
gassily	11	3	781	3	_gassily
glassie	8	32	949	3	glassi_e
glassier	9	28	908	3	glassier
glassies	9	40	1227	3	glassies
glassine	9	32	931	3	glassine
glassing	10	32	997	3	glassing
glassy	10	52	775	3	glass__y
glossily	12	3	509	3	glossily
grassily	12	3	643	3	grassily
lassi	5	63	1685	3	_lassi__
lassie	6	49	1774	3	_lassi_e
lassies	7	44	2010	3	_lassies
lassis	6	52	1670	3	_lassi_s
massif	11	4	1253	3	_massif_
massifs	12	3	774	3	_massifs
misclassify	21	6	157	3	~~mis~~classify
ossify	12	4	497	3	__ossify
russify	13	3	406	3	_russify
salsify	13	3	470	3	_salsify
sassily	10	3	872	3	_sassily
subclassify	21	6	184	3	~~sub~~classify

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.403	443402.0
2	DLD Change Limit	146162	78	7.190	20328.5
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.623	23441.0