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

413 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
liernes73962(None) 
lierne638021lierne_
dienes75719902die_nes
ernes55224812__ernes
kernes104717522_kernes
lenes54738522l_e_nes
leones64417722l_eones
lianes63819322li_anes
lieges74113442lie_ges
liens56525502lie_n_s
liers55130402lier__s
lines57054572li__nes
litres65220392litr_es
liveries11314372liveries
livres94311862livr_es
lucernes1046362lucernes
pierces113411192pierces
ternes65422902_ternes
tierces93710452tierces
aeries64737783_aeries
agenes74720253age_nes
airns55521033ai_rn_s
akenes104817343ake_nes
algerines1069083algerines
aliened81011743alie_ned
alienee71013153alie_nee
alienees8118653alienees
aliener71011193alie_ner
alieners889823alie_ners
alienness945373alienness
aliens65619213alie_n_s
alines65735223ali__nes
alkenes114212753alke_nes
amerces1149853amerces
aperies9423203aperies
arenes64928393are_nes
beignes10149243beignes
benes75536233_be_nes
bennes86019013_bennes
bermes106023003_bermes
bicornes12307253bicornes
biers76225223bier__s
bines76946793bi__nes
biremes1138773biremes
birles84920643bi_rles
birses84717733bi_rses
bizones1837823bizones
bournes93615023bournes
casernes103810753casernes
ceres75540013_cer_es
certes84623083_certes
cicerones1347073cicerones
cines75239683ci__nes
cires74932913ci_r_es
citrines102513133citrines
clients938093clie_nts
clines84926043cli__nes
coerces11311943coerces
denes65639723_de_nes
diaries83321953diaries
diene65720133die_ne_
diereses938693diereses
dieses75218693die_ses
dines66449153di__nes
direness9311303direness
dirges84915103di_rges
diverges13258313diverges
divines113514723divines
eikones1137853eikones
emerges101310883emerges
emeries91620023emeries
epergnes1156713epergnes
erne46727423__erne_
erns45428223__ern_s
erses55826803__erses
eserines8413743eserines
esnes54817363__esnes
eterne6311723eterne_
externes1539833externes
faeries104118993faeries
feres86038183_fer_es
ferns85220083_fern_s
fibres114312123fibr_es
fiends104110293fie_nds
fierce11348913fierce_
fiercer12356953fiercer
fiercest13216143fiercest
fierier103511193fierier
fieriest112112243fieriest
fieriness1238623fieriness
fineries112416743fineries
fines86644263fi__nes
fires85740753fi_r_es
firns86018543fi_rn_s
fliers94417193flier__s
freres94716173frer_es
genes65133093_ge_nes
genres75515623_genres
girned84010513gi_rned
girns64516803gi_rn_s
gyrenes11267523gyrenes
haeres94017033haer_es
heres86245903_her_es
herns84825583_hern_s
heroes94923823_heroes
herpes115517323_herpes
hirees95117293hi_rees
hires86134343hi_r_es
icones84616383_icones
ileuses738673ileuses
ilexes134510253ile_xes
imines84918353_imines
inanes62519803_inanes
internes82721233internes
ires45639283_i_r_es
irones64724013_irones
juliennes1642343juliennes
kermes124616123_kermes
kerne94718213_kerne_
kerned114112923_kerned
kernel104010583_kernel
kernels11417953_kernels
kerns94719563_kern_s
kiers95320093kier__s
kines95039133ki__nes
kirned11408623ki_rned
kirns95315453ki_rn_s
lacunes9159623lacunes
ladrones92710973ladrones
lagunes8148523lagunes
lanes54946793l__anes
larees65323113l_arees
lares54852633l_ar_es
larges74824233l_arges
latrines8515003latrines
lawines103313563lawines
leaned73422543l_eaned
leaner64022193l_eaner
leaners73718173l_eaners
leanest7415863l_eanest
leans55536253l_ean_s
learned8329303learned
learner7319383learner
learners8398153learners
learns65513743learn_s
leases65428113l_eases
leaves94222383l_eaves
lebens8310093l_ebens
leches115421313l_eches
ledges84917993l_edges
leeches123911933leeches
leered73816223leer_ed
leerier73111503leerier
leeriest83112883leeriest
leeriness938323leeriness
leers54828983leer__s
lees45455883l_e__es
leges64427283l_e_ges
lends65326253l_e_nds
lenis56326863l_e_nis
lenos56024863l_e_nos
lens46146493l_e_n_s
lense54523433l_e_nse
lenses64620893l_enses
leone55018823l_eone_
leses54930813l_e_ses
lethes94818083l_ethes
leudes75314093l_eudes
levees93714523l_evees
levies93919863l_evies
lexes127225263l_e_xes
lezzes14387833l_ezzes
liaises7311053liaises
lianas63713383li_anas
liane54720663li_ane_
liangs74410593li_angs
liards75212613liar_ds
liars54723163liar__s
libelees10227213libelees
liberals1039413liberals
liberates111012943liberates
libers84721443liber__s
liberties1149203liberties
libertines1246533libertines
librae84310173librae_
libras83711703libr_as
librates103412953librates
licences12129323licences
license9148423license
licenses10118923licenses
lichees123512783lichees
lichens123510683lichens
liches114724293li_ches
lieder74912323lie_der
liefer9529573lie_fer
liefest1038443lie_fest
liege65314433lie_ge_
lien45339803lie_n__
lienal63912783lie_nal
lier45942463lier___
lies46454193li___es
lieus56218483lie__us
lieve86315473lie_ve_
liever94611863lie_ver
lievest1048343lie_vest
lifelines12147053lifelines
lifers95617843lifer__s
ligands9438983ligands
ligans76817733ligan_s
ligases82310713ligases
ligates82318383ligates
ligers75022043liger__s
ligroines1044993ligroines
ligules82210923ligules
ligures8269893ligures
likened12267353likened
likeness12229863likeness
likens105613703liken_s
likers104620913liker__s
likes96231903li__kes
likings12539413likings
lilies63021413li_lies
limans84816303liman_s
limberness1443273limberness
limeades11116643limeades
limens84618033limen_s
limes75636503li__mes
liminess10510643liminess
limites92915453limites
limned94811473li_mned
limner84112873li_mner
limners93311563li_mners
limns75718393li_mn_s
limpness1246703limpness
linages8813173linages
lindanes939173lindanes
lindens839413lindens
lindies8416583lindies
line46965573li__ne_
lineages979183lineages
lined64934643li__ned
linen55728723li__nen
linens64818393li__nens
liner55938923li__ner
linerless936333linerless
liners65428853li__ners
liney87029633li__ney
lingeries10511813lingeries
lingoes84014693lingoes
lings67135773li__ngs
linings84313073linings
linins65922143linin_s
links96430193li__nks
linnet6419423li_nnet
linnets739833li_nnets
linns56123333li__nns
linos55631503li__nos
lins47059053li__n_s
lints57137193li__nts
lioness739103li_oness
lions55923213li_on_s
lipases9209483lipases
lipides103810623lipides
lipins85016883lipin_s
lippens11328533lippens
liras56021983li_r_as
lire47845293li_r_e_
lisles63416283li_sles
listees73416673listees
listens74014133listens
litanies8310993litanies
liteness82213213liteness
literals8312293literals
literates91415653literates
liters65429883liter__s
litotes7311183litotes
litre55421463litr_e_
littles73212783littles
livened11238933livened
livener10278943livener
liveners11217933liveners
liveness112411393liveness
livens94314893liven_s
livered113111633liver_ed
liveried1238733liveried
livers94927823liver__s
lives86133193li__ves
livings11408923livings
livre85613253livr_e_
loesses7310033loesses
lores55045403l_or_es
lories64933043l_ories
lorries74518343lorries
lucarnes1045093lucarnes
lucerne945753lucerne_
lucerns935753lucern_s
lucres84513303lucr_es
lunes55337773l__unes
lupines93912503lupines
lures56138533l_ur_es
lurexes1436073lurexes
lyres85019963l_yr_es
lysines10369093lysines
merces105720743_merces
merdes94518603_merdes
meres75143573_mer_es
merges94122483_merges
merles85322763_merles
mesnes85216213_mesnes
miens76118303mie_n_s
mines75651953mi__nes
mires75640883mi_r_es
mirexes1636993mirexes
miseries10320403miseries
mitres83922073mitr_es
modernes1138423modernes
nenes55329673_ne_nes
nerves94216193_nerves
nieces84112713nie_ces
nieves94311293nie_ves
nines55937343ni__nes
niteries8318383niteries
nitres65519333nitr_es
oleines7313393oleines
olivines1137473olivines
overnew13268133overnew
peeries93623023peeries
penes75839223_pe_nes
peones83821043_peones
peres76246643_per_es
perses85428063_perses
pieces104217273pie_ces
pierce104010393pierce_
pierced12347593pierced
piercer11337773piercer
piercers12316723piercers
piers75926333pier__s
pieties9419223pieties
pinenes93416673pinenes
pineries102419083pineries
pines76048863pi__nes
pinones94717073pinones
piperines131610693piperines
pirns76020093pi_rn_s
pliers84715153plier__s
pyrenes123511223pyrenes
queries16315873queries
querns15307943quern_s
scenes84520353sce_nes
seines65029903_seines
serenes73222903_serenes
seres55448893_ser_es
serges74225963_serges
series64540973_series
serines74229543_serines
serves94423653_serves
sieges73816833sie_ges
siemens938413siemens
siennas736123siennas
sierras737863sierras
sieves93216003sie_ves
silanes72517163silanes
sines55954823si__nes
sirees64624583si_rees
sirens65318153siren_s
sires55945373si_r_es
sirrees73410573sirrees
skeanes113610713skeanes
skenes104616633ske_nes
slieves10378963slie_ves
steres63929533ster_es
sterner7411913sterner
sternest8314433sternest
sterns64616763stern_s
swerves1377533swerves
terces83921413_terces
terne56426153_terne_
terns55226873_tern_s
theines104013233theines
theres96525473ther_es
thermes126214613thermes
tierce8339843tierce_
tierced10347053tierced
tiercel9316203tiercel
tiercels10344733tiercels
tiered73613973tier_ed
tiers55526523tier__s
tines54848423ti__nes
tires55437493ti_r_es
tisanes7311853tisanes
titres64718933titr_es
trienes74118413trie_nes
veeries102916893veeries
verges104320173_verges
vermes115019143_vermes
verses94223763_verses
verves124617883_verves
viers85621953vier__s
vineries112716043vineries
vines85137643vi__nes
vires84529683vi_r_es
vitrines112610913vitrines
wheres125917433wher_es
wherves16548053wherves
wiener94513543wie_ner
wieners103212483wie_ners
wienies102213683wienies
wineries112316533wineries
wines85546863wi__nes
wires86034913wi_r_es
wiverns13366963wivern_s
zeroes154314343_zeroes
zines145232653zi__nes

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340274136.25021444.3
3Display Results4134130.1432888.1
 (SQL Overall)1786914136.54627297.7
 
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.