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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

325 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
lascars	9	7	901	(None)
lascar	8	6	857	1	lascar_
ascaris	9	36	1332	2	_ascaris
calcars	11	3	1265	2	calcars
cascara	11	3	831	2	cascara
cascaras	12	3	770	2	cascaras
escars	8	39	1313	2	_escars
flatcars	13	4	462	2	flatcars
lacers	8	52	2525	2	la_cers
lahars	9	40	1316	2	la_hars
lancers	9	36	1664	2	lancers
lasers	6	49	2570	2	las_ers
lashers	10	41	2183	2	lashers
lashkars	15	4	367	2	lashkars
lasters	7	56	2769	2	lasters
lazars	15	38	1239	2	la_zars
mascara	11	3	802	2	mascara
mascaras	12	3	769	2	mascaras
pascals	11	6	1001	2	pascals
rascals	9	5	966	2	rascals
scars	7	54	3353	2	__scars
acari	7	50	2028	3	_a_cari
acarus	8	3	1219	3	_a_carus
afars	8	57	1651	3	_a_fars
agars	6	61	2064	3	_a_gars
alaskas	11	3	668	3	alaska_s
alastors	8	3	1120	3	alastors
alegars	8	3	893	3	alegars
altars	6	45	1815	3	_altars
anears	6	37	1718	3	_anears
ascared	10	39	952	3	_ascared
ascarid	10	39	1072	3	_ascarid
ascarids	11	43	850	3	_ascarids
ascots	8	53	1251	3	_ascots
ascus	7	50	1358	3	_asc_us
ashcans	12	3	518	3	_ashcans
ashlars	10	29	706	3	_ashlars
askers	10	59	1540	3	_askers
aspers	8	62	2031	3	_aspers
assais	6	7	1196	3	_assais
assays	9	7	790	3	_assays
asters	6	56	3160	3	_asters
aswarm	11	10	791	3	_aswarm
attars	6	45	1531	3	_attars
baccara	13	4	714	3	baccara
baccaras	14	4	691	3	baccaras
barcas	10	10	1660	3	barca_s
bashaws	15	34	771	3	bashaws
bashers	12	48	2083	3	bashers
bastard	10	30	1242	3	bastard
bastards	11	33	1031	3	bastards
basters	9	49	3030	3	basters
bazaars	18	27	588	3	bazaars
bazars	17	46	1311	3	ba_zars
blasters	10	41	1614	3	blasters
boxcars	18	3	477	3	boxcars
busbars	11	3	815	3	busbars
cacaos	10	46	1618	3	ca_caos
cacas	9	56	2798	3	ca_ca_s
caesars	9	4	1073	3	caesars
calcar	10	3	1275	3	calcar_
cancans	11	3	1187	3	cancans
cancers	11	40	1858	3	cancers
carcass	11	3	1051	3	carcass
cars	6	73	6476	3	___cars
casas	7	53	2784	3	cas_a_s
casbahs	14	3	646	3	casbahs
cascade	12	11	860	3	cascade
cascades	13	12	855	3	cascades
cashaws	15	39	857	3	cashaws
casters	9	47	2990	3	casters
castors	9	49	1944	3	castors
casuals	9	14	1052	3	casuals
caviars	12	3	862	3	caviars
clashers	13	42	1399	3	clashers
claspers	12	44	1091	3	claspers
classers	10	41	1183	3	classers
costars	9	42	1801	3	costars
damars	9	38	1499	3	da_mars
dammars	12	30	819	3	dammars
dancers	10	34	1309	3	dancers
darbars	10	5	1009	3	darbars
dashers	11	50	1686	3	dashers
dastard	9	27	970	3	dastard
dastards	10	27	808	3	dastards
daycare	13	5	509	3	daycare
daycares	14	5	480	3	daycares
daystars	12	4	390	3	daystars
disbars	10	3	1032	3	disbars
discard	11	3	1021	3	discard
discards	12	3	891	3	discards
easters	7	51	2568	3	easters
escar	7	40	1199	3	_escar_
escarp	10	44	900	3	_escarp
escarps	11	39	737	3	_escarps
eschars	12	3	718	3	_eschars
eskars	10	35	759	3	_eskars
facers	11	55	1944	3	fa_cers
farcers	12	47	1344	3	farcers
fasces	11	49	1454	3	fasc_es
fascias	12	5	841	3	fascias
faucals	12	32	656	3	faucals
fiscals	12	3	800	3	fiscals
flancard	14	4	337	3	flancard
flancards	15	4	318	3	flancards
flashcard	18	4	204	3	flashcard
flashcards	19	5	185	3	flashcards
flashers	14	39	1265	3	flashers
flatcaps	15	6	340	3	flatcaps
flatcar	12	7	461	3	flatcar_
gasbags	11	3	547	3	gasbags
gascons	10	28	910	3	gascons
gaspers	10	50	1413	3	gaspers
gassers	8	47	1463	3	gassers
gasters	8	56	2429	3	gasters
gaydars	12	3	580	3	gaydars
gazars	16	48	1155	3	ga_zars
glancers	11	40	800	3	glancers
haars	8	56	2047	3	ha__ars
handcars	14	3	762	3	handcars
hangars	11	43	1349	3	hangars
hussars	10	32	698	3	hussars
instars	7	4	1113	3	instars
jacals	15	3	987	3	ja_cals
jaguars	15	3	523	3	jaguars
jaspers	16	43	1046	3	jaspers
kabars	12	45	1395	3	ka_bars
kantars	11	3	1003	3	kantars
kasbahs	16	3	436	3	kasbahs
kashas	13	33	1190	3	kasha_s
kashers	14	39	1402	3	kashers
laagers	8	34	1125	3	laagers
laari	5	44	1571	3	la__ari
labara	8	37	1289	3	la_bara
labials	9	29	987	3	labials
labors	8	40	1641	3	la_bors
labours	9	34	989	3	labours
lacer	7	58	3375	3	la_cer_
laces	7	61	4176	3	la_c_es
laches	11	65	2834	3	la_ches
lackers	13	41	2054	3	lackers
lacks	11	61	2920	3	la_c_ks
lacs	6	69	4248	3	la_c__s
lactams	11	3	695	3	lactams
lactary	12	3	784	3	lactary
lacunars	10	11	473	3	lacunars
ladders	9	41	1517	3	ladders
laders	7	49	2776	3	la_ders
ladlers	8	46	1357	3	ladlers
lagans	7	57	1778	3	la_gans
lagers	7	48	2614	3	la_gers
laggard	10	34	762	3	laggard
laggards	11	30	705	3	laggards
laggers	9	42	1624	3	laggers
lahar	8	31	1426	3	la_har_
laical	8	3	1232	3	laica_l
laichs	11	51	1089	3	laic_hs
laics	7	64	1925	3	laic__s
lairs	5	54	2587	3	la__irs
lakers	10	52	2515	3	la_kers
lallans	7	41	1353	3	lallans
lamas	7	55	3279	3	la_ma_s
lambers	11	38	1711	3	lambers
lamias	8	50	2061	3	lamia_s
lampads	12	47	762	3	lampads
lampas	10	66	1595	3	lampa_s
lampers	11	38	1733	3	lampers
lamsters	10	9	975	3	lamsters
lanais	6	3	1679	3	la_nais
lancer	8	43	1997	3	lancer_
lances	8	48	2410	3	lanc_es
lancets	9	34	1116	3	lancets
lanciers	10	30	854	3	lanciers
landaus	8	3	1034	3	landaus
landers	8	40	2621	3	landers
langurs	8	8	910	3	langurs
laniard	8	6	852	3	laniard
laniards	9	6	731	3	laniards
laniary	10	6	801	3	laniary
lanners	7	36	1833	3	lanners
lanyard	11	6	729	3	lanyard
lanyards	12	6	639	3	lanyards
laogais	8	4	581	3	laogais
lappers	11	37	1746	3	lappers
lapsers	9	39	1105	3	lapsers
larches	12	44	1644	3	larches
larders	8	35	1694	3	larders
lariats	7	6	1505	3	lariats
larkers	11	30	1451	3	larkers
lars	4	69	5657	3	l___ars
larvas	9	3	1023	3	larva_s
laser	5	46	3332	3	las_er_
lases	5	49	4476	3	las__es
lasher	9	48	2453	3	lasher_
lashes	9	48	3100	3	las_hes
lashins	10	39	1515	3	lashins
lashkar	14	4	370	3	lashkar_
lass	4	74	4454	3	las___s
lasses	6	48	2759	3	las_ses
lassies	7	44	2010	3	lassies
lassis	6	52	1670	3	las_sis
lassoers	8	33	851	3	lassoers
lassoes	7	46	1385	3	lassoes
lassos	6	49	1381	3	las_sos
laster	6	48	3063	3	laster_
lasts	5	77	3126	3	las__ts
latches	12	33	2012	3	latches
lathers	10	43	2188	3	lathers
lauans	6	51	1353	3	la_uans
lauders	8	40	1289	3	lauders
lauras	6	34	1433	3	laura_s
lavas	8	54	2222	3	la_va_s
laveers	10	32	936	3	laveers
lavers	9	45	2636	3	la_vers
lawyers	13	37	715	3	lawyers
layers	9	39	2118	3	la_yers
lazar	14	41	1364	3	la_zar_
lears	5	59	3873	3	l__ears
leasers	7	47	1784	3	leas_ers
lekvars	14	3	269	3	lekvars
lessors	7	36	1052	3	lessors
liars	5	47	2316	3	l__iars
lidars	7	3	1078	3	l_idars
lispers	9	45	1432	3	lispers
listers	7	40	2653	3	listers
loadstars	10	4	331	3	loadstars
locals	8	37	1450	3	l_ocals
losers	6	51	2358	3	los_ers
lumbars	11	28	976	3	lumbars
lunars	6	50	1281	3	l_unars
lusters	7	39	2144	3	lusters
lycras	11	28	725	3	l_ycras
lyssas	9	3	544	3	lyssa_s
maars	7	46	2163	3	ma__ars
macaws	13	3	702	3	ma_caws
macers	10	53	2127	3	ma_cers
madcaps	14	3	524	3	madcaps
makars	12	46	1263	3	ma_kars
malars	8	50	2068	3	ma_lars
masas	7	56	3041	3	mas_a_s
mascons	11	34	1158	3	mascons
mascots	11	39	1034	3	mascots
masers	8	46	2345	3	mas_ers
mashers	12	46	2105	3	mashers
maskers	13	39	1384	3	maskers
massas	8	51	1646	3	massa_s
masters	9	46	2892	3	masters
mescals	11	29	1156	3	mescals
muscats	11	3	893	3	muscats
nasals	6	33	1246	3	nas_als
navars	9	28	1057	3	na_vars
pacas	9	60	2940	3	pa_ca_s
pacers	10	51	2454	3	pa_cers
pascal	10	8	1237	3	pasca_l
paschals	15	6	647	3	paschals
pashas	11	51	1706	3	pasha_s
passers	9	47	1775	3	passers
pastas	8	54	2287	3	pasta_s
pasters	9	45	3173	3	pasters
pastors	9	41	1900	3	pastors
piscary	14	3	742	3	piscary
placard	12	3	678	3	pla_card
placards	13	4	581	3	pla_cards
placers	11	45	1526	3	pla_cers
plashers	13	38	1345	3	plashers
plasmas	11	30	1075	3	plasma_s
plasters	10	35	1813	3	plasters
quasars	16	4	690	3	quas_ars
racers	8	47	2543	3	ra_cers
radars	7	13	1467	3	ra_dars
railcars	10	4	531	3	railcars
rancors	9	8	1137	3	rancors
rascal	8	5	1112	3	rasca_l
rasers	6	45	2678	3	ras_ers
rashers	10	40	2091	3	rashers
raspers	9	44	1592	3	raspers
rasters	7	46	2902	3	rasters
saggars	9	36	1068	3	saggars
sambars	11	51	1384	3	sambars
sangars	8	31	1625	3	sangars
sansars	7	33	1391	3	sansars
sardars	8	31	1290	3	sardars
sarsars	7	35	1214	3	sarsars
sashays	13	3	633	3	sashays
saucers	9	37	1213	3	saucers
scabs	9	48	1864	3	__scabs
scads	8	54	1996	3	__scads
scags	8	55	2097	3	__scags
scams	9	44	2397	3	__scams
scans	7	46	2510	3	__scans
scar	6	64	3420	3	__scar_
scare	7	53	3446	3	__scare
scares	8	50	3300	3	__scares
scarf	10	54	2714	3	__scarf
scarfs	11	47	1468	3	__scarfs
scarp	9	57	2410	3	__scarp
scarps	10	47	1860	3	__scarps
scart	7	61	3977	3	__scart
scarts	8	53	2149	3	__scarts
scary	10	52	2259	3	__scary
scats	7	59	3060	3	__scats
scaurs	8	55	1205	3	__scaurs
sears	5	47	4491	3	__sears
slashers	11	33	1361	3	slashers
soars	5	47	3251	3	__soars
soucars	9	3	842	3	soucars
sowcars	12	3	601	3	sowcars
spars	7	54	3154	3	__spars
stars	5	58	3657	3	__stars
talars	6	60	2168	3	ta_lars
tartars	7	33	1340	3	tartars
taskbars	14	5	299	3	taskbars
tasters	7	42	2564	3	tasters
tatars	6	46	1979	3	ta_tars
tramcars	12	4	523	3	tramcars
trocars	9	5	904	3	trocars
tsars	5	67	1711	3	_ts_ars
tussars	7	35	925	3	tussars
upsoars	9	8	541	3	upsoars
vassals	10	5	795	3	vassals
vicars	11	7	1226	3	_vicars
washers	13	45	1752	3	washers
wasters	10	40	2659	3	wasters
yasmaks	16	3	365	3	yasmaks
zaffars	22	32	523	3	zaffars

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	325	6.000	22337.8
3	Display Results	325	325	0.110	2954.5
	(SQL Overall)	178691	325	6.516	27423.4