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

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

58 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
roundtables	14	9	225	(None)
roundtable	13	8	320	1	roundtable_
boundable	14	4	484	3	bound_able_
constables	14	4	673	3	co_nstables
countable	13	4	885	3	coun_table_
mountable	13	4	630	3	moun_table_
roundballs	13	5	276	3	roundba_lls
soundable	12	4	598	3	sound_able_
bondable	13	16	927	4	bo_nd_able_
boundaries	13	4	511	4	bound_aries
constable	13	3	1100	4	co_nstable_
countably	16	4	629	4	coun_tabl_y
doubtable	14	4	516	4	dou_btable_
groundmasses	16	5	138	4	groundmasses
gustables	12	16	522	4	_gu_stables
huntable	13	3	809	4	_hun_table_
munchables	19	4	278	4	_munchables
nonstaples	12	4	432	4	no_nstaples
notables	10	17	824	4	___notables
outfables	14	8	556	4	_ou_tfables
pointable	13	3	734	4	poin_table_
portables	13	3	787	4	po__rtables
potables	12	17	970	4	po___tables
poundages	13	4	415	4	pound_a_ges
poundals	11	4	501	4	pound_a_l_s
poundcakes	19	10	213	4	poundca_kes
ratables	10	15	972	4	r___atables
refundable	16	4	380	4	refund_able_
renewables	15	4	340	4	r_enewables
rentable	10	17	1633	4	r_en_table_
restables	11	15	1142	4	r__estables
retables	10	17	1267	4	r___etables
reusables	11	7	522	4	reu__sables
rondelles	10	4	662	4	ro_nd_elles
rotatable	11	4	665	4	ro_tatable_
roubles	9	34	1351	4	rou____bles
roundabout	13	5	266	4	round_about
roundabouts	14	5	158	4	round_abouts
roundball	12	4	331	4	roundba_l_l
roundels	9	21	775	4	round__el_s
roundheels	14	5	202	4	roundheel_s
roundhouses	15	10	299	4	roundhouses
roundlet	9	20	922	4	round___let
roundlets	10	17	529	4	round___lets
roundnesses	12	4	704	4	roundnesses
roundtrips	13	5	189	4	roundt_rips
rundles	8	32	1471	4	r_und___les
rustable	10	15	1136	4	r_u_stable_
soundstages	13	5	151	4	soundsta_ges
turntables	12	4	226	4	_turntables
undatable	12	3	898	4	__undatable_
undoable	11	3	905	4	__undoable_
undoubles	12	4	392	4	__undoubles
unstable	10	3	1376	4	__unstable_
unstabler	11	4	562	4	__unstabler
unstablest	12	4	418	4	__unstablest
vendables	15	16	515	4	_vend_ables
worktables	19	4	261	4	wo_rktables

Search took 9 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.420	425454.8
2	DLD Change Limit	148819	58	8.376	17767.3
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	8.826	20246.0