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

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

74 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
lumbricals	16	11	229	(None)
lumbrical	15	11	338	1	lumbrical_
lubrical	12	11	609	2	lu_brical_
lubricant	13	4	452	3	lu_bricant
lubricants	14	5	293	3	lu_bricants
lubricate	13	4	644	3	lu_bricate
lubricates	14	4	605	3	lu_bricates
lubricous	13	4	395	3	lu_bricous
numerical	13	4	597	3	numerical_
rubrical	12	9	609	3	ru_brical_
tumbrils	12	25	537	3	tumbri__ls
umbilicals	16	8	189	3	_umbilicals
armorials	11	4	566	4	armori_als
bridals	10	3	862	4	___bridals
burials	9	36	1208	4	bu__ri_als
cambrics	16	4	525	4	cambric__s
clericals	13	4	535	4	_clericals
comprisals	16	4	371	4	comprisals
cubical	13	3	846	4	cu_b_ical_
cumbias	13	33	896	4	cumb_i_a_s
fimbrial	15	4	419	4	fimbri_al_
gumboils	13	4	389	4	gumboi__ls
humerals	13	4	718	4	humer__als
imbricate	15	4	566	4	_imbricate
imbricates	16	4	529	4	_imbricates
jumbals	18	10	653	4	jumb___als
labials	9	29	987	4	l_ab_i_als
lacrimals	13	4	291	4	l_acrimals
lambkills	17	4	182	4	lambki_lls
laminals	10	33	931	4	lam__inals
limericks	17	4	440	4	limeric_ks
lubric	10	9	798	4	lu_bric___
lubricated	15	4	503	4	lu_bricated
lubricator	14	4	417	4	lu_bricator
lubricators	15	5	388	4	lu_bricators
lubricious	14	5	367	4	lu_bricious
lubricity	16	4	436	4	lu_bricity
lumbars	11	28	976	4	lumb___ars
lumberings	15	10	378	4	lumberi_ngs
lumberjacks	28	5	128	4	lumberjacks
luminal	9	37	1100	4	lum__inal_
lunarians	9	4	551	4	lunari_ans
lyrical	12	3	649	4	l__yrical_
medicals	13	4	936	4	__medicals
memorials	13	4	656	4	memori_als
meticals	12	3	1076	4	__meticals
musicals	12	4	710	4	__musicals
myricas	14	3	675	4	__myrica_s
nombrils	12	4	451	4	nombri__ls
numerals	10	4	734	4	numer__als
numerically	18	4	590	4	numerically
numerics	12	6	628	4	numeric__s
outrivals	12	4	389	4	ou_trivals
plumerias	13	4	498	4	plumeri_a_s
publicans	15	4	411	4	pu_blicans
rubrically	17	7	481	4	ru_brically
rubricate	13	4	648	4	ru_bricate
rubricates	14	4	589	4	ru_bricates
rubricians	14	5	319	4	ru_bricians
rubrics	11	7	709	4	ru_bric__s
rusticals	11	4	535	4	ru_sticals
subvicars	16	4	383	4	su_bvicars
surprisals	12	5	243	4	surprisals
tumbrels	12	28	573	4	tumbr__els
tumbril	11	25	640	4	tumbri__l_
turbinals	11	4	426	4	turb_inals
turrical	10	4	620	4	tu_rrical_
tutorials	9	4	513	4	tutori_als
umbilical	15	11	316	4	_umbilical_
umbral	10	3	863	4	_umbr__al_
umbras	10	3	864	4	_umbr__a_s
umbrellas	13	4	309	4	_umbrellas
urials	6	44	1519	4	_u__ri_als
urinals	7	6	1026	4	_u__rinals

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	161450	0.436	409841.7
2	DLD Change Limit	161450	74	9.280	17397.6
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	9.749	18329.2