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

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

59 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
sidesplitting	17	6	105	(None)
sidesplittingly	22	13	75	2	sidesplittingly
resplitting	14	4	494	3	__resplitting
sideslipping	18	5	148	3	sides_lipping
despiting	13	17	932	4	__desp_i_ting
earsplitting	15	5	138	4	_earsplitting
hairsplitting	19	8	128	4	hairsplitting
sidelining	12	4	457	4	side__li_ning
sideswiping	18	5	150	4	sides_wi_ping
splitting	12	3	656	4	____splitting
deadlifting	17	4	250	5	__deadlifting
debilitating	16	5	411	5	__debilitating
defoliating	16	4	582	5	__defoliating
delisting	11	27	1050	5	__de__listing
demitting	13	23	907	5	__de__mitting
depainting	14	15	615	5	__de_painting
depicting	15	3	781	5	__de_p_icting
depilating	14	3	919	5	__de_pilating
depleting	13	7	819	5	__de_pl_eting
desalinating	14	7	631	5	__desalinating
desalting	11	3	884	5	__desal__ting
deselecting	15	4	447	5	__deselecting
desisting	11	28	1038	5	__des__isting
desolating	12	3	946	5	__desol_ating
despairing	14	4	506	5	__despai_ring
despising	13	16	750	5	__desp_i_sing
despoiling	14	4	511	5	__despoi_ling
despumating	17	4	369	5	__despumating
destituting	13	15	516	5	__des_tituting
dieselizing	22	4	440	5	di_eseli_zing
displanting	15	4	604	5	__displanting
hairsplittings	20	12	91	5	hairsplittings
idealising	12	4	570	5	_ide_ali_sing
idealizing	21	4	729	5	_ide_ali_zing
misfitting	16	4	553	5	mi__s_fitting
mishitting	16	4	599	5	mi__s_hitting
mispainting	16	4	529	5	mi__spainting
misplanting	16	4	563	5	mi__splanting
mispointing	16	4	579	5	mi__spointing
misprinting	16	4	682	5	mi__sprinting
overplotting	18	4	504	5	_overplotting
replotting	13	5	704	5	__re_plotting
resitting	10	34	1487	5	__res__itting
respiting	12	19	1286	5	__resp_i_ting
resplicing	15	4	629	5	__respli_cing
respotting	13	4	711	5	__resp_otting
sealifting	14	4	463	5	s__e_alifting
shoplifting	20	5	214	5	s__hoplifting
sideling	10	10	1218	5	side__l___ing
sidespin	11	4	394	5	sidesp____in_
sidespins	12	4	438	5	sidesp____ins
sidestepping	18	5	146	5	sides_tepping
simplifying	22	4	302	5	si__mplifying
slitting	9	30	1258	5	____s_litting
spitting	11	30	1232	5	____sp_itting
splatting	12	3	598	5	____splatting
splinting	12	3	819	5	____splinting
underletting	14	5	418	5	unde_rletting
underpainting	17	6	355	5	underpainting

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.393	454684.5
2	DLD Change Limit	124790	59	8.670	14393.3
3	Display Results	59	59	0.033	1787.9
	(SQL Overall)	178691	59	9.096	19645.0