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

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

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.

69 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
marathoning	17	5	283	(None)
marathonings	18	5	143	1	marathonings
cartoning	12	3	1111	3	car_t_oning
cartooning	13	4	588	3	car_tooning
marathon	13	4	682	3	maratho__n_
marathoner	15	5	289	3	marathon_er
marathoners	16	5	219	3	marathoners
marathons	14	4	642	3	maratho__ns
marooning	12	3	859	3	mar__ooning
megaphoning	20	5	256	3	megaphoning
misatoning	13	4	644	3	misat_oning
paragoning	14	4	595	3	para_goning
rationing	10	3	978	3	__rationing
ratooning	10	3	717	3	__ratooning
vacationing	17	5	304	3	vacationing
abandoning	14	7	258	4	_abandoning
ambitioning	16	5	278	4	ambitioning
atoning	8	35	1487	4	___at_oning
auctioning	13	4	489	4	_auctioning
authoring	13	4	858	4	_a_uthoring
burthening	16	4	346	4	bur_thening
cantoning	12	3	1088	4	ca_nt_oning
captioning	15	4	570	4	ca_ptioning
caracoling	15	4	563	4	cara_coling
caravaning	16	4	443	4	cara_vaning
caravanning	17	5	237	4	caravanning
cartoonings	14	4	266	4	car_toonings
cautioning	13	4	572	4	ca_utioning
crayoning	15	3	524	4	_cra_yoning
dragooning	13	4	288	4	_dragooning
earthing	12	3	1033	4	ear_th__ing
earthling	13	4	619	4	ear_th_ling
earthmoving	20	5	143	4	ear_thmoving
farthing	15	3	807	4	far_th__ing
fathoming	18	4	469	4	__fathoming
fractioning	17	4	433	4	fractioning
garrisoning	13	5	212	4	garrisoning
harpooning	16	4	448	4	har_pooning
harshening	17	4	417	4	har_shening
jargoning	18	4	598	4	jar__goning
machining	17	4	693	4	m__achining
maintaining	14	5	359	4	maintaining
marauding	13	4	498	4	mara__uding
marching	16	43	1219	4	mar_ch__ing
margining	13	3	760	4	mar__gining
marrowing	15	4	666	4	mar__rowing
marshaling	16	4	508	4	mar_shaling
marting	10	33	2501	4	mar_t___ing
martyring	15	3	578	4	mar_t_yring
masoning	11	3	976	4	m__a_soning
melatonin	11	4	634	4	melat_onin_
melatonins	12	4	564	4	melat_onins
mentioning	13	4	579	4	m_entioning
motioning	12	4	754	4	m__otioning
munitioning	14	5	303	4	munitioning
murthering	16	4	447	4	mur_thering
parachuting	19	5	251	4	parachuting
paraffining	20	5	235	4	paraffining
pardoning	13	3	876	4	par__doning
partitioning	15	5	297	4	partitioning
platooning	13	4	465	4	_platooning
portioning	13	4	719	4	por_tioning
rattening	10	28	876	4	__rattening
rattooning	11	4	395	4	ra_ttooning
sanctioning	14	5	399	4	sanctioning
smartening	13	4	499	4	smar_t_ening
stationing	11	4	528	4	_stationing
wantoning	13	3	708	4	wa_nt_oning
wrathing	15	24	892	4	_wrath__ing

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	148819	0.453	394461.4
2	DLD Change Limit	148819	69	8.986	16561.2
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	9.469	18871.2