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

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

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.

65 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
reappearances	19	6	177	(None)
reappearance	18	8	203	1	reappearance_
appearances	17	5	369	2	__appearances
appearance	16	5	406	3	__appearance_
disappearances	21	7	131	3	disappearances
nonappearances	20	7	137	3	nonappearances
disappearance	20	6	136	4	disappearance_
esperances	14	4	625	4	_e_spe_rances
nonappearance	19	7	167	4	nonappearance_
preclearances	19	6	205	4	pre_clearances
reappeared	15	4	301	4	reappear___ed
reappearing	16	4	394	4	reappearin__g
reappears	13	4	285	4	reappear____s
reappraises	15	5	309	4	reapp__raises
reassurances	14	11	260	4	rea_ssurances
repentances	15	5	611	4	re__pentances
temperances	17	5	473	4	te_mpe_rances
aberrances	14	7	542	5	__a_berrances
appetences	16	4	459	5	__appe_tences
appliances	16	4	397	5	__app_liances
clearances	14	4	479	5	___clearances
defeasances	17	5	228	5	de__feasances
deliverances	18	14	269	5	delive_rances
dependances	17	5	485	5	de__pendances
esperance	13	4	668	5	_e_spe_rance_
expectances	24	9	334	5	_e_xpectances
exuberances	22	5	245	5	_exube_rances
forbearances	19	5	193	5	_forbearances
happenchances	27	8	91	5	_happenchances
happenstances	22	6	115	5	_happenstances
inappetences	18	5	296	5	inappe_tences
malfeasances	19	6	142	5	_malfeasances
penetrances	15	4	480	5	pe__netrances
pleasances	14	4	419	5	___pleasances
preclearance	18	5	233	5	pre_clearance_
rapparees	13	4	395	5	r_app_ar__ees
reactances	14	4	614	5	rea___ctances
reappear	12	4	262	5	reappear_____
reappraise	14	5	332	5	reapp__raise_
reappraised	16	7	282	5	reapp__raised
reapproves	17	4	306	5	reapp__r_oves
rearranges	11	4	511	5	rea___rranges
reassurance	13	14	275	5	rea_ssurance_
rebalances	14	4	525	5	re___balances
recalcitrances	17	8	143	5	recalcitrances
recreances	14	4	650	5	re_cre__ances
recuperates	15	4	560	5	recupe_ra_tes
reentrances	13	4	517	5	re__entrances
reexperiences	24	7	229	5	reexperiences
references	15	8	935	5	re__fe_rences
reflectances	19	5	264	5	re_flectances
reinsurances	14	5	281	5	re_insurances
relevances	15	9	611	5	re__le_vances
remembrances	20	15	289	5	re_membrances
remonstrances	17	5	299	5	remonstrances
reoperates	12	4	966	5	re_ope_ra_tes
repentance	14	5	662	5	re__pentance_
reprobances	17	5	413	5	re__probances
repugnances	16	9	286	5	re__pugnances
rerebraces	14	4	503	5	re__rebra_ces
resplendences	18	12	238	5	resplendences
reverences	15	7	917	5	re__ve_rences
scapegraces	18	7	153	5	sca_pegra_ces
severances	15	4	678	5	se__ve_rances
temperance	16	4	480	5	te_mpe_rance_

Search took 10 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	124790	0.140	1276364.3
2	DLD Change Limit	124790	65	9.003	13860.9
3	Display Results	65	65	0.046	1413.0
	(SQL Overall)	178691	65	9.189	19446.2