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

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

76 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
kleenex	18	4	238	(None)
keened	11	40	1363	2	k_eened
keener	10	40	1284	2	k_eener
kleenexes	20	4	109	2	kleenexes
aliened	8	10	1174	3	aliened
alienee	7	10	1315	3	alienee
aliener	7	10	1119	3	aliener
alkene	10	41	1400	3	alkene_
alkenes	11	42	1275	3	alkenes
bleeder	10	35	964	3	bleeder
bleeped	12	28	727	3	bleeped
bleeper	11	45	825	3	bleeper
cleaned	10	35	1200	3	cleaned
cleaner	9	37	1230	3	cleaner
cleeked	14	35	773	3	cleeked
fleece	11	36	990	3	fleece_
fleeced	13	35	815	3	fleeced
fleecer	12	36	803	3	fleecer
fleeces	12	39	964	3	fleeces
fleered	11	30	950	3	fleered
fleeted	11	33	1023	3	fleeted
fleeter	10	32	1036	3	fleeter
gleaned	9	34	942	3	gleaned
gleaner	8	37	977	3	gleaner
gleeked	13	34	633	3	gleeked
gleemen	10	3	572	3	gleemen
gleeted	9	37	932	3	gleeted
greened	9	31	1126	3	greened
greener	8	31	1171	3	greener
keeked	10	48	1012	3	k_eeked
keeled	11	44	1427	3	k_eeled
keen	8	48	3041	3	k_een__
keeners	11	36	1078	3	k_eeners
keenest	11	4	1096	3	k_eenest
keenly	13	3	637	3	k_eenly
keens	9	57	2118	3	k_een_s
keeper	12	38	1192	3	k_eeper
keeve	12	45	1213	3	k_eeve_
keeves	13	37	1199	3	k_eeves
kenned	11	44	1127	3	k_enned
kennel	10	36	922	3	k_ennel
kerne	9	47	1822	3	k_erne_
kerned	11	41	1293	3	k_erned
kernel	10	40	1059	3	k_ernel
kernes	10	47	1753	3	k_ernes
ketene	10	66	1300	3	ketene_
ketenes	11	48	1350	3	ketenes
klezmer	22	3	193	3	klezmer
kneeled	12	32	807	3	kneeled
kneeler	11	27	757	3	kneeler
leaned	7	34	2254	3	_leaned
leaner	6	40	2219	3	_leaner
leered	7	38	1622	3	_leered
lenes	5	47	3852	3	_l_enes
leone	5	50	1882	3	_leone_
leones	6	44	1772	3	_leones
oleine	6	3	1379	3	oleine_
oleines	7	3	1339	3	oleines
peened	9	43	1816	3	_peened
preened	10	32	1499	3	preened
preener	9	31	1483	3	preener
queened	17	10	586	3	queened
sheened	11	35	1170	3	sheened
sheeney	13	39	893	3	sheeney
sleeked	12	35	1088	3	sleeked
sleeken	11	32	680	3	sleeken
sleeker	11	33	982	3	sleeker
sleeper	9	32	1156	3	sleeper
sleeted	8	31	1322	3	sleeted
sleeve	9	34	1159	3	sleeve_
sleeved	11	41	991	3	sleeved
sleeves	10	33	1134	3	sleeves
sweeney	13	38	700	3	sweeney
teener	6	47	1750	3	_teener
tweener	10	30	683	3	tweener
weened	10	40	1373	3	_weened

Search took 7 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	134027	0.423	422437.4
2	DLD Change Limit	134027	76	6.093	21996.9
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	6.549	27285.2