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

461 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
gleaner837977(None) 
cleaner93712301cleaner
gleamer10328511gleamer
gleaned9349421gleaned
gleaners9348071gleaners
leaner64022191_leaner
bleaker133510532bleaker
bleater94515302bleater
cleaned103512002cleaned
cleaners103610542cleaners
cleanser10356322cleanser
clearer93710822clearer
cleaver124110802cleaver
glancer103710072gl_ancer
glazer164212262gl_azer
gleamed11327932gleamed
gleamers11306562gleamers
gleamier1144912gleamier
glean65818202glean__
gleans75014742glean_s
gloater83711012gloater
greaser83913082greaser
greater84416492greater
greener83111712greener
groaner82510132groaner
leader74824652_leader
leaker104620072_leaker
leaned73422542_leaned
leaners73718172_leaners
leaper88118942_leaper
learner7319382_learner
leaser65322672_leaser
leaver94321512_leaver
loaner64416502_loaner
meaner84617842_meaner
oleander936402oleander
planer84122662pl_aner
pleader103511762pleader
pleaser93912342pleaser
pleater93916332pleater
weaner93816772_weaner
alane56135613al_ane_
alerter72111513alerter
alexander1742773alexander
aliener71011193aliener
aligner8108313aligner
aliner65621983al_iner
alkane104313323alkane_
alkanes113812933alkanes
alkanet113714433alkanet
allayer10148213allayer
almner85710723al_mner
almoner949383almoner
beader94623793_beader
beaker125520693_beaker
beaned95621473_beaned
beanery1237563_beanery
bearer85323913_bearer
beater84729393_beater
beaver114819253_beaver
belayer12339503belayer
blader93618583bl_ader
blamer104417143bl_amer
blander103715173bl_ander
blanker134612023bl_anker
blazer174414023bl_azer
bleacher15358883bleacher
blear75918683blea__r
bleared104211253bleared
blearier1037333blearier
bleated104015973bleated
bleaters103412323bleaters
bleeder10359643bleeder
bleeper11458253bleeper
blender104613853blender
blesser9329293blesser
blether12459913blether
bloater94013423bloater
breaker133912923breaker
caner75334773__caner
cheaper144010583cheaper
cheater124816963cheater
clanger104113493cl_anger
claver113816973cl_aver
clawer114512783cl_awer
clean75420413clean__
cleanest10310293cleanest
cleanlier1143363cleanlier
cleanly1236323cleanly
cleans85817053clean_s
cleanse9358723cleanse
cleansed11395933cleansed
cleansers11335073cleansers
cleanses10358143cleanses
cleanup1144083cleanup
clear76219053clea__r
cleared103612463cleared
clearers10349303clearers
cleated103417853cleated
cleave114212513cleave_
cleaved134010483cleaved
cleavers13398873cleavers
cleaves124111623cleaves
clever114611533cle_ver
cloner84418093cl_oner
coleader1139183coleader
creamer113714093creamer
creaser94415743creaser
deader84220473_deader
deafer104114813_deafer
dealer74122143_dealer
deaned84620453_deaned
deanery1137613_deanery
dearer74822803_dearer
delayer113010533delayer
dreamer104110843dreamer
eager65526973__eager
earner63617223__earner
eater54639843__eater
elater64724203el_ater
eloiner7149183eloiner
evener91010623eve_ner
fearer94820183_fearer
feater95224053_feater
flaker134916173fl_aker
flamer114919123fl_amer
flanes94522423fl_anes
flaneur1034183fl_aneur
flanger113412623fl_anger
flanker143911293fl_anker
flayer124713563fl_ayer
fleecer12368033fleecer
fleer86020773fle__er
fleeter103210363fleeter
flenser1036783flenser
flesher133610923flesher
floater104413353floater
gager74726293g__ager
gainer74117493g_ainer
galeae74717453galea_e_
galeate83916793galeate_
galeated104111583galeated
gamer84928943g__amer
gander84322763g__ander
gane55145303g__ane_
ganef96322463g__anef
ganev95513863g__anev
ganger83721473g__anger
gaper86125123g__aper
garner73917003g_arner
gater64533653g__ater
gayer94519193g__ayer
gazer155720073g__azer
gear55934973g_ea__r
geared85317743g_eared
geekier12286393geekier
geezer16278013g_eezer
gelant72821673gelan_t
gelants82611443gelants
gelate73421263gelate_
gelated93615643gelated
gelates83219593gelates
gelder84613713g_elder
gender83517933g_ender
gene56237223g_e_ne_
genera71211713g_e_nera
genes65133093g_e_nes
genet66038683g_e_net
genre66016803g_e_nre
getter74117613g_etter
geyser1036513g_eyser
ginner73915823g_inner
glace87420163gl_ace_
glaces94218033gl_aces
glacier103911303glacier
gladder10398313gladder
glade75121963gl_ade_
glades84820343gl_ades
gladier93810993gladier
glair65313553gl_a_ir
glaire74411303gl_aire
glamor958193gl_amor
glance94312313gl_ance
glanced11439233gl_anced
glancers11408003gl_ancers
glances104113143gl_ances
gland75217713gl_an_d
glanders103811513gl_anders
glandes95413833gl_andes
glands85314403gl_ands
glans65125833gl_an_s
glare65222963gl_are_
glared84715203gl_ared
glares75518873gl_ares
glarier84112213glarier
glaze155418163gl_aze_
glazed174711773gl_azed
glazers174410043gl_azers
glazes165315643gl_azes
glazier17409353glazier
gleam86916733glea__m
gleams94812253glea_ms
gleamy12398113glea_my
gleaning10269323gleaning
glebae9407613glebae_
glebe85016443gle_be_
glebes95512243gle_bes
glede75517833gle_de_
gledes84915133gle_des
glee55239063gle__e_
gleed75320573gle__ed
gleek105315103gle__ek
gleeked13346333gleeked
gleemen1035723gleemen
glees65027593gle__es
gleet65532343gle__et
gleeted9379323gleeted
gleetier934913gleetier
glegness1034613glegness
glen56027203gle_n__
glens66519853gle_n_s
gleyed11478153gle_yed
glibber1235163glibber
glider84614263gl_ider
glimmer12437713glimmer
glister84013343glister
glitter84211803glitter
gloated93511533gloated
gloaters9288863gloaters
glosser83410813glosser
glover104513533gl_over
glower105114933gl_ower
gluer65116773gl__uer
gluier7310263gl_uier
glummer12417983glummer
gnawer10386953g_nawer
goldener1045403goldener
goner66025163g__oner
gowaned1235763gowaned
grader84919693g_rader
grainer83714063grainer
grander93315873g_rander
granger93514213g_ranger
granter84117133g_ranter
grater74625443g_rater
graver105018593g_raver
grayer106014543g_rayer
grazer164815763g_razer
grease75416233grease_
greased93812393greased
greasers93410253greasers
greases84816713greases
greasier9298083greasier
greaten83610643greaten
greave104611493greave_
greaved12408913greaved
greaves113311443greaves
greened93111263greened
greenery12265923greenery
greenier938713greenier
greeter82812673greeter
greyer104510093gre_yer
grinner8329233grinner
groaned9259973groaned
groaners9248513groaners
guesser8166543guesser
gunner73813983g_unner
header104422543_header
healer94221803_healer
heaper114119523_heaper
hearer94323653_hearer
heater94828303_heater
heaver124819673_heaver
humaner12257663humaner
inaner62213543_inaner
insaner7310443insaner
jeaned143813463_jeaned
keener104012843_keener
kleenex1842383kleenex
klezmer2231933klezmer
kneader1275893kneader
laager74312783_laager
lacer75833753_l_acer
lader65633723_l_ader
lager65132863_l_ager
laker95432873_l_aker
lamer75233703_l_amer
lancer84319973_l_ancer
lander74028493_l_ander
lane45153333_l_ane_
lanes54946793_l_anes
lanker104123003_l_anker
lanner64920603_lanner
laser54633323_l_aser
later54843923_l_ater
laver85031793_l_aver
laxer125420333_l_axer
layer84626473_l_ayer
leacher124014843_leacher
leaded84221543_leaded
leaden74515223_leaden
leaders83819603_leaders
leadier83212723_leadier
leafed105713873_leafed
leafier10329833_leafier
leaguer835793_leaguer
leaked114217703_leaked
leakers113415423_leakers
leakier114010993_leakier
lean46345243_lean__
leanest7415863_leanest
leanly93811503_leanly
leans55536253_lean_s
leant56737783_lean_t
leaped94317773_leaped
leapers93716663_leapers
lear47045953_lea__r
learier73415663_learier
learned8329303_learned
learners8398153_learners
lease55230263_lease_
leased74722883_leased
leasers74717843_leasers
leases65428113_leases
leather103815783_leather
leave84723723_leave_
leaved105719023_leaved
leaven95013073_leaven
leavers103717783_leavers
leaves94222383_leaves
leavier10319993_leavier
lecher113415853_lecher
ledger85914393_ledger
leer46239353_le__er
lefter93613433_lefter
leger65721513_le_ger
lender73921283_lender
lenes54738523_le_nes
leone55018823_leone_
leones64417723_leones
leper74820743_le_per
lesser63514853_lesser
letter63722583_letter
levanter1145303_levanter
lever85125163_le_ver
levier94013873_levier
lewder10479613_lewder
liane54720663_liane_
lianes63819323_lianes
limner84112873_limner
liner55938923_l_iner
loader74316313_loader
loafer93610943_loafer
loaned73816293_loaned
loaners73913623_loaners
loner55431043_l_oner
meager94515203_meager
meander1049973_meander
meaners94415243_meaners
moaner84415113_moaner
nearer64618893_nearer
neater64424313_neater
oleanders1035573oleanders
oleaster837263oleaster
oleate6318883oleate_
oleates7417833oleates
oleine6313793oleine_
oleines7313393oleines
opener83910993ope_ner
penner84616663_penner
placer105117743pl_acer
plainer93811983plainer
planar84212713pl_anar
plane74929143pl_ane_
planed94420913pl_aned
planers94517953pl_aners
planes85028083pl_anes
planet84228353pl_anet
planner93511633planner
planter94017813pl_anter
plater84427693pl_ater
player115215213pl_ayer
pleaded113511263pleaded
pleaders113210193pleaders
please84315733please_
pleased103712073pleased
pleasers104010293pleasers
pleases94515483pleases
pleated103816633pleated
pleaters103613793pleaters
pleather1356653pleather
pledger11359173pledger
preaver121011613preaver
preener93114833preener
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
rearer64928913_rearer
reaver94524733_reaver
relater73723143relater
relaxer143410223relaxer
releaser839503releaser
saner54334323__saner
sealer63928963_sealer
seamer84223613_seamer
searer65432023_searer
seater64534163_seater
seiner64622483_seiner
shearer104414693shearer
skeane104611373skeane_
skeanes113610713skeanes
slaker104219273sl_aker
slander84015453sl_ander
slater64429183sl_ater
slaver94419613sl_aver
slayer93916333sl_ayer
sleave94714153sleave_
sleaved113611133sleaved
sleaves103813203sleaves
sleaze152611863sleaze_
sleazes162810333sleazes
sleazier1735123sleazier
sledder9399203sledder
sleeker11339823sleeker
sleeper93211563sleeper
slender83413603slender
smearer94110403smearer
sneaker112910453sneaker
solemner1045053solemner
speaker133311213speaker
speaned103411523speaned
spearer93913663spearer
stealer72913983stealer
steamer93313093steamer
sterner7411913sterner
swearer10349953swearer
sweater103712723sweater
tearer64822903_tearer
teaser65421523_teaser
teener64717503_teener
tenner64117103_tenner
theater104014253theater
treader84113833treader
treater74219833treater
tweener10306833tweener
uncleaner1144763uncleaner
uneager839753uneager
urbaner9177133urbaner
vealer94016543_vealer
veiner94514753_veiner
weaker134015443_weaker
weaned103816153_weaned
weaners104613833_weaners
wearer94319413_wearer
weaver123916613_weaver
weiner94214133_weiner
wiener94513543wie_ner
wreaker143610043wreaker
yeaned103813903_yeaned
yearner10336873_yearner

Search took 8 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.483369960.7
2DLD Change Limit1340274616.81319672.2
3Display Results4614610.1562955.1
 (SQL Overall)1786914617.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.