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

269 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
likened1226735(None) 
livened11238931livened
aliened81011742ali_ened
dizened18267332dizened
ladened979052ladened
lakebed1434782lakebed
latened8711922latened
libeled10249412libeled
licenced13145772licenced
licensed11145722licensed
lichened1435752lichened
liked104523812lik__ed
liken911818842liken__
likeness12229862likeness
likens105613702liken_s
limned94811472li_mned
lined64934642li__ned
lippened13255222lippened
listened9168812listened
livener10278942livener
livered113111632livered
pinkened1535752pinkened
ripened1038202ripened
sickened1546782sickened
slickened1644292slickened
tokened1236392tokened
wakened1546872wakened
widened12328052widened
wizened20275422wizened
akene95818663_akene_
akenes104817343_akenes
alienee71013153ali_enee
aliener71011193ali_ener
aligned9128553ali_gned
alikeness1336333alikeness
alimented1245313alimented
alined75221403ali__ned
alkene104114003alkene_
alkenes114212753alkenes
awakened1653473awakened
bickered17108003bickered
biked125320033bik__ed
bikinied1543513bikinied
binned94414543bi_nned
blackened1845273blackened
blinkered1644413blinkered
chickened2144623chickened
clinkered1634773clinkered
cozened19349183cozened
daikered1495223daikered
darkened1435943darkened
davened124610073davened
dickered16117533dickered
diene65720133di_ene_
dienes75719903di_enes
dieted83115493di_eted
diked115024683dik__ed
dined76431993di__ned
dinned84317613di_nned
divined12329693divined
dovened12389063dovened
dozened18377453dozened
eikones1137853eikones
enlivened1342993enlivened
evened101010313_evened
fibered1337643fibered
fiend95312983fi_en_d
fileted1159093fileted
fined94930503fi__ned
finned104114603fi_nned
flickered1943753flickered
ginned83813983gi_nned
girned84010513gi_rned
glistened11174283glistened
greened93111263greened
harkened1637483harkened
havened14429243havened
hiked135919203hik__ed
hoidened1335653hoidened
inned64118423_i_nned
ironed74916013_ironed
itemed936603_itemed
keened114013623_keened
kenned114411263__kenned
kerned114112923__kerned
keyed1369383__keyed
kilned11368393ki_lned
kirned11408623ki_rned
kittened1334523kittened
kneed104612053__kneed
labeled102510563labeled
lackered15108673lackered
lackeyed18104513lackeyed
lagend838743lagen_d
lagered92311153lagered
lakebeds1542583lakebeds
laked105731123lak__ed
lamented1138193lamented
lapeled10258893lapeled
layered11259413layered
leadened1036153leadened
leaned73422543l_eaned
learned8329303learned
leavened1235553leavened
leered73816223l_eered
legend837693legen_d
lekked10395633lek_ked
lend56233673l__en_d
lenes54738523l__enes
lensed74015473l__ensed
lessened935093lessened
leveed104111373leve_ed
leveled114010383leveled
levered114212303levered
liaised837113liaised
liane54720663li_ane_
lianes63819323li_anes
libelee92510983libelee
libeler9219003libeler
libelled11317213libelled
licence11119363licence
licencee12116463licencee
licencer12146133licencer
licences12129323licences
license9148423license
licensee10166303licensee
licenser10155883licenser
licenses10118923licenses
licente91210893licente
lichted13268803lichted
licked134621563li_cked
lidded93410243li_dded
lied55838093li___ed
lieder74912323li_eder
liefer9529573li_efer
liege65314433li_ege_
lieges74113443li_eges
lien45339803li_en__
lienal63912783li_enal
liens56525503li_en_s
lierne638023lierne_
liernes739623liernes
lieve86315473li_eve_
liever94611863li_ever
lifted104413523li_fted
ligand85011293ligan_d
ligated92414143ligated
lighted122913503lighted
lightened1446023lightened
like86040843lik__e_
likelier1235283likelier
likely13328133like_ly
likening13246893likening
liker95627063lik__er
likers104620913like_rs
likes96231903lik__es
likest104914383like_st
liking114319583likin_g
likings12539413likings
lilied73913213li_lied
lilted73715373li_lted
limbed114513183li_mbed
limbered13158123limbered
limeade1076123limeade
limed85426803li__med
limen75426033limen__
limens84618033limen_s
limited102310233limited
limner84112873li_mner
limped114817123li_mped
line46965573li__ne_
lineated9711063lineated
linebred1144963linebred
linemen938633linemen
linen55728723li__nen
linens64818393linen_s
lineny94011443linen_y
liner55938923li__ner
lines57054573li__nes
liney87029633li__ney
lingered10129643lingered
linked114518213li_nked
linnet6419423li_nnet
linseed838203linseed
linted74021823li_nted
lipped114419543li_pped
lippered13287953lippered
lisente71210703lisente
lisped94113423li_sped
listed74322833li_sted
listener8158313listener
liteness82213213liteness
lithoed1137833lithoed
littered92511383littered
lived95523723li__ved
liven85021733liven__
liveners11217933liveners
liveness112411393liveness
livens94314893liven_s
liveried1238733liveried
loaned73816293l_oaned
loitered938183loitered
loosened945453loosened
loudened1044693loudened
lowered112711913lowered
miked125020453mik__ed
mildened1235773mildened
mimeoed1235193mimeoed
mined85333353mi__ned
mitered103213233mitered
mittened1136363mittened
nickeled15115513nickeled
nickered15117023nickered
omened93711003_omened
opened94311863_opened
peened94318163_peened
picketed17167383picketed
pieced113912103pi_eced
piked125623313pik__ed
pikemen1535333pikemen
pined85935323pi__ned
pinene82915643pinene_
pinenes93416673pinenes
pinned94818383pi_nned
preened103214993preened
queened17105863queened
quickened2543163quickened
ravened115012283ravened
rekeyed1536163rekeyed
richened1435953richened
ripener937903ripener
riveted11258573riveted
sheened113511703sheened
sickener1436603sickener
sieged85212713si_eged
sieved104611443si_eved
signed83413753si_gned
silenced1136273silenced
sinewed1137053sinewed
sinned73818413si_nned
skeed105018983_ske_ed
skeined1236773_skeined
skene96118123_skene_
skenes104616633_skenes
skewed145610233_skewed
skinned12387293skinned
slackened1644243slackened
sleekened1442543sleekened
slickener1544043slickener
slivered12218103slivered
thickened1944303thickened
ticketed15146643ticketed
tiered73613973ti_ered
tined65434533ti__ned
tinkered1387683tinkered
tinned74317533ti_nned
unkend11309223unken_d
unkenned1336183unkenned
viewed1345993vi_ewed
vined95626153vi__ned
viseed105310983vise_ed
wakener1446913wakener
weakened1634823weakened
weened104013733_weened
whitened1535173whitened
widener11318693widener
wiener94513543wi_ener
wined94434183wi__ned
winned104017013wi_nned

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.406440125.6
2DLD Change Limit1340272695.59323963.3
3Display Results2692690.0962802.1
 (SQL Overall)1786912696.09529317.6
 
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.