Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

442 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lienal6391278(None) 
lineal65616021lineal
binal75323822bi_nal
cliental1045352cliental
clinal8311552cli_nal
final83922032fi_nal
hiemal11339502hiemal
ileal56118082ile_al
leal46043272l_e_al
legal65715942l_egal
liana53915892liana_
lianas63713382lianas
liberal9310192liberal
lien45339802lien__
lienable10188692lienable
liens56525502lien_s
lignan75510322lignan
liminal93810672liminal
linac7315412li_nac
linear65113342linear
literal7613272literal
lumenal9307272lumenal
penal75228372_penal
pineal84817682pineal
pinnal84814272pinnal
renal55929502_renal
signal73711482signal
thenal92712422thenal
tineal66216162tineal
veinal93812962veinal
venal85523212_venal
vinal85725812vi_nal
vineal94814742vineal
acetal84314903acetal
adenyl1035023adenyl
adrenal838263adrenal
agonal7410053agonal
albinal937813albinal
alien56425583alien__
alienable1146933alienable
alienage945583alienage
alienate8311553alienate
aliened81011743aliened
alienee71013153alienee
aliener71011193aliener
alienly1037503alienly
alienor7116303alienor
aliens65619213alien_s
alimental1155863alimental
anal48037523__anal
annal56520763_annal
anneal64812293anneal
apneal83411123apneal
areal55928733are_al
arena55323813arena_
arenas65021993arenas
arsenal739383arsenal
atonal6514023atonal
axonal1347653axonal
azonal1568273azonal
banal75925993_banal
benzal1739643_benzal
biaxal1536093biaxal
bidental1146583bidental
biennale1044093biennale
biennial1065093biennial
bimensal1244093bimensal
bimetal1138433bimetal
bipedal1245683bipedal
bizonal1845563bizonal
caecal103713733caecal
canal75428043_canal
carnal83919203carnal
cecal94619113_cecal
cental84420963_cental
cineol8108203cineol
citral81113893citral
client8316343clien_t
clients938093clients
clonal8310913clonal
coeval1138893coeval
credal9311673credal
crenel84213063crenel
cuneal8611513cuneal
daedal849083daedal
deal56347413_de_al
decal85523233_decal
dedal75719023_dedal
denar65223293_denar
denial74720513_denial
dental74319173_dental
dial55935063di__al
diel59034603die__l
diene65720133dien_e
dienes75719903dienes
diesel74410403diesel
dinar66319893di_nar
dirndl834253dirndl
dismal92412243dismal
distal73615773distal
diurnal844883diurnal
egal55119433__egal
enol45823823__enol
eternal72910893eternal
faecal11359813faecal
faena85014203faena_
faenas94412763faenas
faunal94711593faunal
feal713940423_fe_al
fecal105119213_fecal
feral85424653_feral
fetal85623373_fetal
fiend95312983fien_d
fiends104110293fiends
filial93013253filial
finale94116763fi_nale
finals94316163fi_nals
finial92814183finial
fiscal1139333fiscal
foetal9311883foetal
frena85915273frena_
genial74917613_genial
gien56330023gien__
gimbal11228813gimbal
gimmal11247513gimmal
gingal81010153gingal
glial66715433gli__al
haemal113811643haemal
heal75645693_he_al
hemal104419803_hemal
hiatal9310203hiatal
hibernal1344403hibernal
hyena11810253hyena_
hyenas1288953hyenas
hyetal1236543hyetal
hymenal1545183hymenal
hymnal1434913hymnal
ideal65716393_ideal
ilea45931463ile_a_
ileac75814173ile_ac
ilial55317843_ilial
illegal854763illegal
jingal1498593jingal
juvenal1743393juvenal
kenaf12316033_kenaf
kidnap1334193kidnap
kina85631993ki_na_
kinas95626913ki_nas
labial84714343labial
lacunal9136553lacunal
laical8312323laical
laminal94113633laminal
lanai5319573l_anai
larval948503larval
lateral7313573lateral
lea37660183l_e_a_
lead56038853l_e_ad
leaf76441033l_e_af
leak86233713l_e_ak
lean46345243l_e_an
leanly93811503l_eanly
leans55536253l_eans
leant56737783l_eant
leap66032683l_e_ap
lear47045953l_e_ar
leas45954183l_e_as
leeway1255883leeway
legals73412733l_egals
leman75622603l_eman
lend56233673l_en_d
lends65326253l_ends
lenes54738523l_enes
lenis56326863l_enis
leno47331393l_en_o
lenos56024863l_enos
lens46146493l_en_s
lense54523433l_ense
lent46360533l_en_t
lentil64315393l_entil
lento57223393l_ento
lethal939803lethal
leva77020713l_eva_
level84116553l_evel
liane54720663lian_e
lianes63819323lianes
liang64914413lian_g
liangs74410593liangs
liar47229683li__ar
libel74116103li_bel
liberals1039413liberals
liblab1035083liblab
libra74712423libra_
librae84310173librae
libras83711703libras
licence11119363licence
license9148423license
licente91210893licente
lidar6312723li_dar
lie38264523lie___
lied55838093lie__d
lieder74912323lieder
lief76036993lie__f
liefer9529573liefer
liefly1266363liefly
liege65314433lie_ge
lieges74113443lieges
lier45942463lie__r
lierne638023lierne
liernes739623liernes
liers55130403lie_rs
lies46454193lie__s
lieu46534363lie__u
lieus56218483lie_us
lieve86315473lie_ve
liever94611863liever
lifeful1344613lifeful
lifeway1644273lifeway
ligan67920283li_gan
ligand85011293ligand
ligans76817733ligans
lignans8398853lignans
lignin74911193lignin
ligula7359673ligula
liken911818843liken__
likened12267353likened
likens105613703liken_s
lilac7311073li_lac
lima65734133li_ma_
liman75921603li_man
limans84816303limans
limas75627633li_mas
limba95414983limba_
limbas105313203limbas
limen75426033limen__
limens84618033limen_s
limina83514503limina_
limn66527693limn__
limned94811473limned
limner84112873limner
limnic10418843limnic
limns75718393limn_s
limpa97014463limpa_
limpas105513083limpas
lin37967373li_n__
linable92214343li_nable
linacs8310813li_nacs
linage7713403li_nage
linalol745093li_nalol
lindy96918313li_ndy
line46965573li_n_e
lineable101811083lineable
lineage878983lineage
lineally1137793lineally
linearly1146793linearly
lineate7815153lineate
lined64934643li_ned
lineman939123lineman
linen55728723li_nen
linens64818393linens
lineny94011443lineny
liner55938923li_ner
liners65428853liners
lines57054573li_nes
lineup835983lineup
liney87029633li_ney
ling57447963li_n_g
linga66820823li_nga
lingam95112353lingam
lingas75116573lingas
lingo66022113li_ngo
lings67135773li_ngs
lingual8379083lingual
lingy96925143li_ngy
linin58025523li_nin
link86943443li_n_k
links96430193li_nks
linky127622383li_nky
linn46034593li_n_n
linnet6419423linnet
linns56123333li_nns
lino46343373li_n_o
linos55631503li_nos
lins47059053li_n_s
lint416266233li_n_t
lintel64013993lintel
lintol6369473lintol
lints57137193li_nts
linty87126563li_nty
linum7313823li_num
liny78141323li_n_y
lion46334443lion__
lions55923213lion_s
lipa68425923li_pa_
lira46928683li_ra_
liras56021983li_ras
lisente71210703lisente
listel64214743listel
litai55216363li_tai
litany939053litany
litas54923773li_tas
literals8312293literals
litoral7610763litoral
liven85021733liven__
livened11238933livened
livener10278943livener
livens94314893liven_s
local74820273l_ocal
loessal744393loessal
loral55927823l_oral
loreal63814313loreal
loyal84513483l_oyal
luminal93711003luminal
luna46229853l_una_
lunar57017313l_unar
lunas55025013l_unas
luteal64411483luteal
maenad939413maenad
meal65643173_me_al
medal86221333_medal
menad85918983_menad
menial84223033_menial
mensal84615653_mensal
mental84521603_mental
metal75427383_metal
mien65028363mien__
miens76118303mien_s
mina65136923mi_na_
minae75627723mi_nae
minas75434113mi_nas
mineral9312733mineral
miskal123710263miskal
missal84314903missal
mitral81314323mitral
nidal65217103ni_dal
nival84915773ni_val
nounal639813nounal
omental93210413omental
oriental848483oriental
peal68648103_pe_al
pedal86022503_pedal
penial84120893_penial
petal76526893_petal
phenol1149253phenol
phenyl1435323phenyl
phonal11310383phonal
pial65636703pi__al
pibal95217323pi_bal
pical95524373pi_cal
piebald1245503piebald
pieta75421753pieta_
pietas84516503pietas
pina65842633pi_na_
pinas75434453pi_nas
pineals93212843pineals
pinna75320183pinna_
pinnae84414643pinnae
pinnas85315513pinnas
pipal95118353pi_pal
plena75816393plena_
pleonal937243pleonal
plexal1536833plexal
plical10411683pli_cal
preanal9310713preanal
quezal2435143quezal
real45750293_re_al
regal65023793_regal
regnal74812933regnal
renail65020763_renail
rental63922023_rental
rhinal9510193rhinal
rial45938093ri__al
rictal83113183rictal
riel46432383rie__l
ritual6310623ritual
rival85216503ri_val
riyal84413433ri_yal
scena74815783scena_
scenas84114703scenas
seal45654373_se_al
sendal73314993_sendal
sepal77723003_sepal
seral56336383_seral
setal56430903_setal
sheal84927703she_al
sial45938833si__al
sienna647193sienna
siennas736123siennas
signa66114703signa_
signals8359163signals
simnel857023simnel
sisal54217733si_sal
spinal84915313spinal
steal56125473ste_al
sternal73411913sternal
tarnal63716503tarnal
teal45546503_te_al
tenail64516113_tenail
tepal76319583_tepal
thecal113310303thecal
thenar92610003thenar
tibial849843tibial
tical76021493ti_cal
tidal64516443ti_dal
timbal102510753timbal
tincal83913363tincal
tinea54923163tinea_
tineas64616483tineas
toenail738783toenail
tonal53724303_tonal
trenail7410813trenail
trinal6516963trinal
ureal56722683ure_al
urinal6614123urinal
uveal84411073uve_al
veal76936813_ve_al
veena81912323veena_
veenas91410413veenas
vena76126293_vena_
venae85920983_venae
venial94218283_venial
vernal93514213vernal
vial76731093vi__al
vicinal12268543vicinal
viminal12288823viminal
vina76331803vi_na_
vinals94716483vi_nals
vinas85126343vi_nas
vinyl115311623vi_nyl
viral86419593vi_ral
visual938803visual
vital84819673vi_tal
weal75838683_we_al
wheal115716183whe_al
whenas124610463whenas
wiener94513543wiener
wienie9229973wienie
withal1238933withal
xenial133414903_xenial
zeal135530333_ze_al
zoeal144813783zoe_al
zonal145116853_zonal
zoonal1558083zoonal

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1431249587.4
2DLD Change Limit1127164425.71619719.4
3Display Results4424420.1403157.1
 (SQL Overall)1786914425.99929786.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.