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

496 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
gleaned934942(None) 
cleaned103512001cleaned
gleamed11327931gleamed
gleaner8379771gleaner
leaned73422541_leaned
beaned95621472_beaned
bleared104211252bleared
bleated104015972bleated
cleaner93712302cleaner
cleansed11395932cleansed
cleared103612462cleared
cleated103417842cleated
cleaved134010482cleaved
deaned84620452_deaned
galeated104111572galeated
geared85317742g_eared
gelated93615632gelated
glanced11439232gl_anced
gland75217712gl_an_d
glared84715192gl_ared
glazed174711772gl_azed
gleamer10328512gleamer
glean65818202glean__
gleaners9348072gleaners
gleans75014742glean_s
gleed75320572gle__ed
gleeked13346332gleeked
gleeted9379322gleeted
gleyed11478152gle_yed
gloated93511532gloated
gowaned1235762gowaned
greased93812392greased
greaved12408912greaved
greened93111262greened
groaned9259972groaned
jeaned143813462_jeaned
leaded84221542_leaded
leafed105713872_leafed
leaked114217702_leaked
leaner64022192_leaner
leaped94317772_leaped
learned8329302_learned
leased74722882_leased
leaved105719022_leaved
loaned73816292_loaned
planed94420912pl_aned
pleaded113511262pleaded
pleased103712072pleased
pleated103816632pleated
sleaved113611132sleaved
speaned103411522speaned
weaned103816152_weaned
yeaned103813902_yeaned
afeared1176833afeared
aland65526413al_an_d
alane56135613al_ane_
alated75625143al_ated
alerted82512223alerted
aliened81011743aliened
aligned9128553aligned
alined75221403al_ined
alkane104313323alkane_
alkanes113812933alkanes
alkanet113714433alkanet
allayed11138063allayed
aneared8512743aneared
baned85436353__baned
beaded104922423_beaded
beaked135919493_beaked
beamed115720733_beamed
belaced124112153belaced
belated103520013belated
belayed133610083belayed
beleaped1336103beleaped
bemeaned1335783bemeaned
bladed104717763bl_aded
blamed116017953bl_amed
bland85320453bl_an_d
blanked144011223bl_anked
blared95018243bl_ared
blawed124713893bl_awed
blazed184314713bl_azed
bleached16378563bleached
bleaker133510533bleaker
bleater94515303bleater
bleed85019803ble__ed
bleeped12287273bleeped
blend85317453ble_n_d
blende95413443ble_nde
blended114710713blended
blessed10319493blessed
bloated104513433bloated
breaded115014063breaded
breamed124011593breamed
caned85838093__caned
ceased94920783_ceased
cheated134416343cheated
clanged114212653cl_anged
clanked143812253cl_anked
clawed125115073cl_awed
clayed125013043cl_ayed
clean75420413clean__
cleaners103610543cleaners
cleanest10310293cleanest
cleanly1236323cleanly
cleans85817053clean_s
cleanse9358723cleanse
cleanser10356313cleanser
cleanses10358143cleanses
cleanup1144083cleanup
clearer93710823clearer
cleave114212513cleave_
cleaver124110803cleaver
cleaves124111623cleaves
cleeked14357733cleeked
clefted13326753clefted
cleped115114113cle_ped
clerked14326653clerked
clewed1225113203cle_wed
cloaked14368543cloaked
cloned94518803cl_oned
clowned13447733clowned
craned96121653_craned
creaked143413233creaked
creamed123913713creamed
creased104315583creased
created104323453created
deaved114916553_deaved
delated93722873delated
delayed123310763delayed
deleaded1148333deleaded
deleaved1346573deleaved
demeaned1237283demeaned
denned84215633_denned
dreaded103612023dreaded
dreamed114310633dreamed
eared65139503__eared
earned74818333__earned
eased65430403__eased
eaved95924503__eaved
eland65820393el_an_d
elated74725823el_ated
elected102812613elected
elevated12118293elevated
eloined8149813eloined
evened101010313eve_ned
feared106320433_feared
feased105718713_feased
feazed195112633_feazed
flaked144715653fl_aked
flamed124618973fl_amed
flanes94522423fl_anes
flanged123810843fl_anged
flanked153710643fl_anked
flared105317603fl_ared
flawed134712723fl_awed
flayed134414053fl_ayed
flecked17358073flecked
fledged13417863fledged
fleeced13358153fleeced
fleered11309503fleered
fleeted113310233fleeted
flensed1136613flensed
fleshed143210263fleshed
flexed17419093fle_xed
fleyed13408813fle_yed
floated113312703floated
freaked15399703freaked
gaed66031513g__a_ed
gaged85522313g__aged
gained84617463g_ained
galeae74717453galea_e_
galeate83916783galeate_
gallanted1145893gallanted
gamed95126393g__amed
gane55145303g__ane_
ganef96322463g__anef
ganev95513863g__anev
ganged94619193g__anged
gaped96123533g__aped
garaged1039253garaged
gated75329773g__ated
gazed165520333g__azed
gecked146911933g_ecked
geed65435503g_e__ed
geeked124510163g_eeked
gelant72821673gelan_t
gelants82611443gelants
gelate73421253gelate_
gelates83219583gelates
gelded94512113g_elded
gelled84718893g_elled
gemmed12329573g_emmed
gene56237223g_e_ne_
genes65133093g_e_nes
genet66038683g_e_net
gheraoed1343343gheraoed
ginned83813983g_inned
girned84010513g_irned
glace87420153gl_ace_
glaceed1136193glaceed
glaces94218023gl_aces
glad65624013gl_a__d
gladded11357453gladded
glade75121963gl_ade_
glades84820343gl_ades
glaired9387743glaired
glaived12375973glaived
glance94312313gl_ance
glancer103710073gl_ancer
glances104113143gl_ances
glandes95413833gl_andes
glands85314403gl_ands
glans65125833gl_an_s
glare65222953gl_are_
glares75518863gl_ares
glassed93710433glassed
glaze155418163gl_aze_
glazer164212263gl_azer
glazes165315643gl_azes
gleam86916733glea__m
gleamers11306563gleamers
gleamier1144913gleamier
gleams94812253glea_ms
gleamy12398113glea_my
gleaning10269323gleaning
glebae9407613glebae_
glebe85016443gle_be_
glebes95512243gle_bes
gled65631143gl___ed
glede75517833gle_de_
gledes84915133gle_des
glee55239063gle__e_
gleeds84711623gle__eds
gleek105315103gle__ek
gleemen1035723gleemen
glees65027593gle__es
gleet65532343gle__et
glegness1034613glegness
glen56027203gle_n__
glenoid937803glenoid
glens66519853gle_n_s
glided94513903gl_ided
glimed105312283gl_imed
glinted9399373glinted
glitzed18375493glitzed
gloater83711013gloater
globated1265753globated
globed104811763gl_obed
glommed13265443glommed
gloomed11337413gloomed
glopped13347613glopped
gloried9169513gloried
glossed94410073glossed
glouted9429713glouted
gloved114811873gl_oved
glowed114913833gl_owed
glozed173711223gl_ozed
glued75118363gl__ued
glugged11396623glugged
glutted937243glutted
gnawed11427833g_nawed
goaded94913713g_oaded
goaled85014363g_oaled
governed1335193governed
gowned114410133g_owned
graced105217903g_raced
graded94919553g_raded
grained93814273grained
grand75122693g_ran_d
granted94715103g_ranted
grated84523923g_rated
graved114818813g_raved
grayed115415643g_rayed
grazed174115913g_razed
grease75416233grease_
greaser83913083greaser
greases84816713greases
greaten83610643greaten
greatened1144583greatened
greater84416493greater
greave104611493greave_
greaves113311443greaves
greed75125693gre__ed
greener83111713greener
greeted93111383greeted
grenade938413grenade
greyed114610603gre_yed
grinned9378553grinned
groaner82510133groaner
groined92710813groined
guessed9176603guessed
guested9157713guested
gunned83513093g_unned
gyrated12428413gyrated
headed114020473_headed
healed105121443_healed
heaped124516903_heaped
heated104525593_heated
heaved134717863_heaved
ideated9310973ideated
keened114013633_keened
kenned114411273_kenned
kerned114112933_kerned
kleenex1842383kleenex
kneaded13146473kneaded
laced87132643_l_aced
laded74232613_l_aded
laked105731123_l_aked
lamed85235293_l_amed
lanced93717723_l_anced
land56337313_l_an_d
landed84619243_l_anded
lane45153333_l_ane_
lanes54946793_l_anes
lased65132343_l_ased
lated65240673_l_ated
laved95028593_l_aved
lawed96028323_l_awed
layed95127383_l_ayed
lazed154925843_l_azed
leached133715043_leached
lead56038853_lea__d
leaden74515223_leaden
leadened1036153_leadened
leader74824653_leader
leagued935463_leagued
leaker104620073_leaker
lean46345243_lean__
leaners73718173_leaners
leanest7415863_leanest
leanly93811503_leanly
leans55536253_lean_s
leant56737783_lean_t
leaper88118943_leaper
learner7319383_learner
lease55230263_lease_
leaser65322673_leaser
leases65428113_leases
leashed113211163_leashed
leave84723723_leave_
leaven95013073_leaven
leavened1235553_leavened
leaver94321513_leaver
leaves94222383_leaves
leched123716003_leched
leered73816223_leered
legated92513983_legated
legend837693_legend
legged95713093_legged
lekked10395633_lekked
lend56233673_le_n_d
lenes54738523_le_nes
lensed74015473_lensed
leone55018823_leone_
leones64417723_leones
letted74118543_letted
levanted1245323_levanted
leveed104111373_leveed
levied104111433_levied
liane54720663_liane_
lianes63819323_lianes
limned94811473_limned
lined64934643_l_ined
loaded84616873_loaded
loafed104011153_loafed
loamed94414613_loamed
loaner64416503_loaner
maned86634103__maned
meaner84617843_meaner
meated94222403_meated
melamed1249633melamed
moaned94514173_moaned
neared75119803_neared
neoned7311483_neoned
oleander936403oleander
oleate6318883oleate_
oleates7417833oleates
oleine6313793oleine_
oleines7313393oleines
omened93711003ome_ned
opened94311863ope_ned
paned85437183__paned
peaced115818913_peaced
peaked136117403_peaked
pealed95322813_pealed
peened94318163_peened
peined94918843_peined
penned94217613_penned
pileated112711133pileated
placed114318003pl_aced
plained103812233plained
plane74929143pl_ane_
planer84122653pl_aner
planes85028083pl_anes
planet84228353pl_anet
planked143512283pl_anked
planned103810153planned
planted103516123pl_anted
plated95225773pl_ated
played124815033pl_ayed
pleached16338063pleached
plead85818463plea__d
pleader103511753pleader
please84315733please_
pleaser93912343pleaser
pleases94515483pleases
pleater93916333pleater
pledged12358633pledged
poleaxed1854823poleaxed
preaged11612333preaged
preened103214993preened
queened17105863queened
reamed94326123_reamed
reaped94122453_reaped
reared75930013_reared
reaved104523923_reaved
recaned102817203recaned
recleaned1236583recleaned
reearned948883reearned
reined74425523_reined
relaced103517213relaced
reland75920433relan_d
relanded102410463relanded
related83327573related
relaxed153312533relaxed
relayed113212753relayed
relearned1035633relearned
released9310243released
relined85321933relined
reloaned939723reloaned
saned65636273__saned
seabed95017693_seabed
sealed74328363_sealed
seamed94823883_seamed
seared75232843_seared
seated75131063_seated
seined74023063_seined
sheafed14388973sheafed
sheared114516003sheared
sheaved143411633sheaved
sheened113511703sheened
skeane104611373skeane_
skeanes113610713skeanes
skeined1236773skeined
slaked114318273sl_aked
slanged94112853sl_anged
slanted83514743sl_anted
slated75028313sl_ated
slaved104017043sl_aved
slayed104716223sl_ayed
sleave94714153sleave_
sleaves103813203sleaves
sleaze152611863sleaze_
sleazes162810333sleazes
sledded10378873sledded
sledged103610333sledged
sleeked123510883sleeked
sleeted83113223sleeted
sleeved11419913sleeved
slewed104815523sle_wed
smeared104510623smeared
sneaked12329693sneaked
sneaped10338813sneaped
speared104314423speared
staned74824643_staned
steaded92811673steaded
steamed103712143steamed
sweated113411543sweated
teamed95418593_teamed
teared75722153_teared
teased74721153_teased
teated74924023_teated
treaded95014283treaded
treated83618703treated
tweaked1534403tweaked
ullaged937033ullaged
uncleaned1237173uncleaned
unearned9310063unearned
unleaded10411333unleaded
unlearned1035653unlearned
unleased9310713unleased
unweaned1238593unweaned
unyeaned1237743unyeaned
upleaped1334333upleaped
vaned94622423__vaned
vealed103916323_vealed
veined104413913_veined
waned95831783__waned
weaner93816773_weaner
weaved133913483_weaved
weened104013733_weened
womaned1337213womaned
wreaked15369023wreaked
yearned11327373_yearned
yenned10409383_yenned

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 Limit1340274965.76323256.5
3Display Results4964960.1732867.1
 (SQL Overall)1786914966.34228175.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.