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 “lierne” 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.

439 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
lierne63802(None) 
liernes739621liernes
diene65720132die_ne
erne46727432__erne
eterne6311722eterne
fierce11348912fierce
kerne94718222_kerne
leone55018822l_eone
liane54720662li_ane
librae84310172librae
liege65314432lie_ge
lien45339802lie_n_
liens56525502lie_ns
lier45942462lier__
liers55130402lier_s
lieve86315472lie_ve
line46965572li__ne
lire47845292li_r_e
litre55421462litr_e
livre85613252livr_e
lucerne945752lucerne
pierce104010392pierce
terne56426152_terne
tierce8339842tierce
aerie54634603_aerie
agene65621583age_ne
airn46433833ai_rn_
airns55521033ai_rns
akene95818663ake_ne
algerine9810283algerine
alien56425583alie_n_
aliened81011743alie_ned
alienee71013153alienee
aliener71011193alie_ner
aliens65619213alie_ns
aline57243153ali__ne
alkene104114003alke_ne
amerce10310513amerce
arene55329413are_ne
averse95811183averse
beigne9148613beigne
bene66439493_be_ne
benne76521123_benne
berme96022943_berme
bicorne11297553bicorne
bier65531833bier__
biers76225223bier_s
bine66650863bi__ne
bireme10310143bireme
birle75023633bi_rle
birse74517403bi_rse
bizone1738603bizone
borne77926793_borne
bourne83714093bourne
caserne93710063caserne
cere66741473_cer_e
cicerone1247523cicerone
cine66242943ci__ne
cire65836373ci_r_e
citrine92514023citrine
client8316343clie_nt
cline76428533cli__ne
coerce10310403coerce
dene56643413_de_ne
dere56845903_der_e
dieing84018653dieing
dienes75719903die_nes
dine55555333di__ne
dire56644143di_r_e
dirge75117073di_rge
diverge12347643diverge
diverse11429993diverse
divine103514463divine
eerie55228533_eerie
emerge91510463emerge
epergne1046143epergne
ere36352773__er_e
ern35738363__ern_
ernes55224813__ernes
erns45428233__erns
eserine7415903eserine
esne47018793__esne
externe1438573externe
eyne76322463__eyne
faerie93514683faerie
feirie939553feirie
fere76342233_fer_e
ferine96422583_ferine
fern76129323_fern_
ferns85220083_ferns
ferny115816183_ferny
fibre104812843fibr_e
fiend95312983fie_nd
fiercer12356953fiercer
fierier103511193fierier
fiery114714793fier_y
fine75147953fi__ne
fire76245593fi_r_e
firn76927503fi_rn_
firns86018543fi_rns
flier86023403flier__
fliers94417193flier_s
frere85617723frer_e
gene56237223_ge_ne
genre66016803_genre
gieing83614853gieing
gien56330023gie_n_
girn56026863gi_rn_
girned84010513gi_rned
girns64516803gi_rns
gyrene10227243gyrene
here76447103_her_e
hern76134893_hern_
herns84825583_herns
hieing104216623hieing
hire75538963hi_r_e
hiree85427803hi_ree
imine75821063_imine
inane52820343_inane
interne73218153interne
ire36943173_i_r_e
irone55126363_irone
julienne1542223julienne
kern85326213_kern_
kerned114112933_kerned
kernel104010593_kernel
kernes104717533_kernes
kerns94719563_kerns
kier86526813kier__
kiers95320093kier_s
kine85643433ki__ne
kirn87123443ki_rn_
kirned11408623ki_rned
kirns95315453ki_rns
lacune8169673lacune
ladrone83611873ladrone
lagune7158633lagune
lane45153333l__ane
laree56036293l_aree
large65325463l_arge
larine63927043larine
latrine7715123latrine
laurae64011663laurae
lawine93316463lawine
lean46345243l_ean_
leaned73422543l_eaned
leaner64022193l_eaner
leans55536253l_eans
leant56737783l_eant
learn55322663learn_
learned8329303learned
learner7319383learner
learns65513743learns
learnt64019253learnt
lease55230263l_ease
leave84723723l_eave
leben7314853l_eben
ledge76519493l_edge
lee36068143l_e__e
leer46239353leer__
leered73816223leered
leerier73111503leerier
leering83417643leering
leers54828983leer_s
leery85919133leer_y
leke85527403l_e_ke
lend56233673l_e_nd
lenes54738523l_e_nes
leno47331393l_e_no
lens46146493l_e_ns
lense54523433l_ense
lent46360533l_e_nt
leones64417723l_eones
lethe85717303l_ethe
levee84023813l_evee
liable81415813liable
liaise6310693liaise
liana53915893li_ana
lianes63819323li_anes
liang64914413li_ang
liar47229683liar__
liard65418593liar_d
liards75212613liards
liars54723163liar_s
libelee92510983libelee
liber74723623liber__
liberal9310193liberal
liberate101113383liberate
libers84721443liber_s
libertine1147433libertine
liberty1237163liberty
libra74712423libr_a
libras83711703libras
librate93214233librate
libri74610113libr_i
lice66045063li__ce
licence11119363licence
license9148423license
licente91210893licente
lichee114017973lichee
lichen114012743lichen
lie38264523li___e
lied55838093lie__d
lieder74912323lieder
lief76036993lie__f
liefer9529573liefer
liefly1266363liefly
lieges74113443lieges
lienal63912783lienal
lies46454193lie__s
lieu46534363lie__u
lieus56218483lie_us
liever94611863liever
life75433733li__fe
lifeline11167663lifeline
lifer85822153lifer__
lifers95617843lifer_s
ligan67920283ligan_
ligand85011293ligand
ligans76817733ligans
ligase7259913ligase
ligate72519253ligate
liger65024473liger__
ligers75022043liger_s
ligroine945693ligroine
ligule74010833ligule
ligure7279473ligure
like86040843li__ke
liken911818843liken_
likened12267353likened
likens105613703likens
liker95627063liker__
likers104620913liker_s
liking114319583liking
liman75921603liman_
limans84816303limans
lime66244933li__me
limeade1076123limeade
limen75426033limen_
limens84618033limens
limina83514503limina
liming94021243liming
limn66527693li_mn_
limned94811473li_mned
limner84112873li_mner
limns75718393li_mns
lin37967373li__n_
linage7713403linage
lindane839033lindane
linden7411453linden
lineage878983lineage
lineate7815153lineate
lined64934643li__ned
linemen938633linemen
linen55728723li__nen
linens64818393linens
lineny94011443lineny
liner55938923li__ner
liners65428853liner_s
lines57054573li__nes
liney87029633li__ney
ling57447963li__ng
lingerie959203lingerie
linin58025523linin_
lining74526803lining
linins65922143linins
link86943443li__nk
linn46034593li__nn
linnet6419423li_nnet
linns56123333li_nns
lino46343373li__no
lins47059053li__ns
lint416266233li__nt
liny78141323li__ny
lion46334443li_on_
lions55923213li_ons
lipase8239103lipase
lipe66839733li__pe
lipide93511063lipide
lipin75518893lipin_
lipins85016883lipins
lippen103911403lippen
lira46928683li_r_a
liras56021983li_ras
liri45128253li_r_i
lirot5430033li_rot
lisente71210703lisente
lisle53916723li_sle
listee64223063listee
listen64816813listen
litany939053litany
lite47054543li__te
liter54736343liter__
literal7613273literal
literate81216893literate
liters65429883liter_s
lithe84922013li_the
litres65220393litres
litten64014873litten
little63312163little
live76540993li__ve
liven85021733liven_
livened11238933livened
livener10278943livener
livens94314893livens
liver85132963liver__
livered113111633livered
liveried1238733liveried
liveries11314373liveries
livering122012383livering
livers94927823liver_s
livery124910903liver_y
living104318323living
livres94311863livres
lone45849133l__one
lore45850353l_or_e
lorn46435253l_orn_
lucarne944263lucarne
lucern846103lucern_
lucernes1046363lucernes
lucerns935753lucerns
lucre76415523lucr_e
lune47140493l__une
lupine84013533lupine
lure45142463l_ur_e
lyre75623793l_yr_e
lysine94210553lysine
merde84320123_merde
mere67244443_mer_e
merge84523693_merge
merle75824373_merle
mesne75116293_mesne
mien65028363mie_n_
miens76118303mie_ns
mine67256173mi__ne
mire66748233mi_r_e
mitre75522423mitr_e
moderne1037123moderne
nene45932063_ne_ne
nerve86617373_nerve
niece74814503nie_ce
nieve85613183nie_ve
nine45842173ni__ne
niterie7313743niterie
nitre57519683nitr_e
oleine6313793oleine
olivine1038843olivine
overnew13268133overnew
peerie83617893peerie
penne75423853_penne
pere66450263_per_e
perse75429523_perse
piece96717993pie_ce
pieing93917653pieing
pier66035293pier__
pierced12347593pierced
piercer11337773piercer
pierces113411193pierces
piers75926333pier_s
pine67755713pi__ne
pinene82915643pinene
piperine122011833piperine
pirn67128373pi_rn_
pirns76020093pi_rns
plier75221283plier__
pliers84715153plier_s
pyrene113210733pyrene
quern143610403quern_
querns15307943querns
riverine11310803riverine
scene77220573sce_ne
seine55732873_seine
sene46848053_se_ne
sere46153473_ser_e
serene63522353_serene
serge64727473_serge
serine65432673_serine
serve85425963_serve
siege66718443sie_ge
sienna647193sienna
sierra637313sierra
sieve84918843sie_ve
silane62718053silane
sine46560623si__ne
sire46150413si_r_e
siree55238813si_ree
siren54525823siren_
sirens65318153sirens
sirree64017343sirree
skeane104611373skeane
skene96118123ske_ne
slier54827243slier__
slieve9359273slie_ve
stere55328543ster_e
stern55319123stern_
sterna63712763sterna
sterner7411913sterner
sterns64616763sterns
swerve1256293swerve
terce75721843_terce
tern46134803_tern_
ternes65422903_ternes
terns55226873_terns
terse55026823_terse
theine94814923theine
there87527393ther_e
therme115814993therme
tieing73518763tieing
tier44936143tier__
tierced10347053tierced
tiercel9316203tiercel
tierces93710453tierces
tiered73613973tiered
tiering8315253tiering
tiers55526523tier_s
tine45855133ti__ne
tire46143353ti_r_e
tisane6311573tisane
titre54619393titr_e
triene64316383trie_ne
uterine7315193uterine
verge93419843_verge
verse84723583_verse
verve115417723_verve
vier75428153vier__
viers85621953vier_s
vine75643683vi__ne
viperine13189713viperine
vitrine102511363vitrine
were76238333_wer_e
where117019423wher_e
wherve15568113wherve
wiener94513543wie_ner
wienie9229973wienie
wine74953423wi__ne
wire75839813wi_r_e
wivern12409283wivern_
wiverns13366963wiverns
zine137036153zi__ne

Search took 6 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.373479064.3
2DLD Change Limit1127164395.36021029.1
3Display Results4394390.1433069.9
 (SQL Overall)1786914395.87630410.3
 
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.