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

331 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
gleaners934807(None) 
cleaners103610541cleaners
gleamers11306561gleamers
gleaner8379771gleaner_
leaners73718171_leaners
bleaters103412322bleaters
cleaner93712302cleaner_
cleansers11335062cleansers
clearers10349302clearers
cleavers13398872cleavers
glancers11408002gl_ancers
glanders103811502gl_anders
glazers174410042gl_azers
gleamer10328512gleamer_
gleaned9349422gleane_d
gleans75014742glean__s
glegness1034612glegness
gloaters9288862gloaters
greasers93410252greasers
groaners9248502groaners
leaders83819602_leaders
leakers113415422_leakers
leaner64022192_leaner_
leapers93716662_leapers
learners8398152_learners
leasers74717842_leasers
leavers103717782_leavers
loaners73913622_loaners
meaners94415242_meaners
oleanders1035572oleanders
planers94517942pl_aners
pleaders113210182pleaders
pleasers104010292pleasers
pleaters103613792pleaters
weaners104613832_weaners
alexanders1842443alexanders
alieners889823alieners
aligners9117573aligners
aliners74717723al_iners
alkanes113812933alkane_s
alkanets12366233alkanets
allayers11156633allayers
almners9399563al_mners
almoners1068133almoners
beaders104120183_beaders
beakers134216873_beakers
beanery1237563_beanery
bearers94619593_bearers
beaters94925043_beaters
beavers124417323_beavers
belayers13298143belayers
bladers104214683bl_aders
blamers115314213bl_amers
blazers184811683bl_azers
bleachers16297923bleachers
bleaker133510533bleaker_
bleakness1543593bleakness
blears85116453blea__rs
bleater94515303bleater_
bleeders11448453bleeders
bleepers12377493bleepers
blenders115210993blenders
blessers10277633blessers
blethers13429613blethers
bloaters103311023bloaters
breakers143810973breakers
caners84629203__caners
cheaters133613513cheaters
clangers114312343cl_angers
clavers124314903cl_avers
clawers123910973cl_awers
cleaned103512003cleane_d
cleanest10310293cleanest
cleanness1144973cleanness
cleans85817053clean__s
cleanser10356313cleanser_
cleanses10358143cleanses
cleanups1242203cleanups
clearer93710823clearer_
clearness1135633clearness
clears84116563clea__rs
cleaver124110803cleaver_
cleaves124111623cleave_s
cloners94514823cl_oners
coleaders1237823coleaders
creamers124111303creamers
creasers103612823creasers
dealers84118613_dealers
deanery1137613_deanery
delayers12268663delayers
dreamers11369003dreamers
eagers74523683__eagers
earners74016453__earners
eaters65535953__eaters
elaters74420193el_aters
eloiners8128153eloiners
eveners10109503eve_ners
fearers104815273_fearers
flakers143613273fl_akers
flamers124616363fl_amers
flanes94522423fl_ane_s
flaneurs1133953fl_aneurs
flangers123311373fl_angers
flankers15349303fl_ankers
flayers133912033fl_ayers
fleecers13325933fleecers
fleers96015793fle__ers
flensers1135463flensers
fleshers14339443fleshers
floaters112711513floaters
gagers84021333g__agers
gainers84214593g_ainers
gamers94420833g__amers
ganders93521703g__anders
ganefs10489203g__anefs
ganevs10456913g__anevs
gangers94418603g__angers
gapers94520473g__apers
garners83815983g_arners
gaters74728643g__aters
gazers164516303g__azers
gears64628693g_ea__rs
geezers17286513g_eezers
gelants82611443gelan_ts
gelates83219583gelate_s
gelders93812573g_elders
genders93616783g_enders
genera71211713g_e_nera
genes65133093g_e_ne_s
genets75716663g_e_nets
genres75515623g_e_nres
getters84216103g_etters
geysers1135703g_eysers
ginners84314223g_inners
glaces94218023gl_ace_s
glaciers11277893glaciers
glades84820343gl_ade_s
gladness1036153gladness
glaires84010133gl_aires
glairs75211333gl_a_irs
glamors1068113gl_amors
glancer103710073gl_ancer_
glances104113143gl_ances
glandes95413833gl_andes
glands85314403gl_an_ds
glans65125833gl_an__s
glares75518863gl_are_s
glazer164212263gl_azer_
glazes165315643gl_aze_s
glaziers18406563glaziers
gleamed11327933gleame_d
gleamier1144913gleamier_
gleams94812253glea__ms
glean65818203glean___
gleaning10269323gleaning
gleanings11244643gleanings
glebes95512243gle_be_s
gledes84915133gle_de_s
gleeds84711623gle__eds
gleeks11489673gle__eks
glees65027593gle__e_s
gleets75315053gle__ets
glens66519853gle_n__s
glibness1134133glibness
gliders94811843gl_iders
glimmers13396153glimmers
glisters93912603glisters
glitters93710543glitters
gloater83711013gloater_
glossers9319053glossers
glovers114310883gl_overs
glowers113412093gl_owers
gluers75011153gl__uers
glueyness1342913glueyness
gluiness937363gluiness
glumness1135203glumness
gnawers11356393g_nawers
goners74420173g__oners
graders94716013g_raders
grainers93012073grainers
grangers103011973g_rangers
granters93614143g_ranters
graters85419743g_raters
gravers114515273g_ravers
grazers175112453g_razers
greaser83913083greaser_
greases84816713grease_s
greatens9307593greatens
greater84416493greater_
greatness1036903greatness
greaves113311443greave_s
greener83111713greener_
greenery12265923greenery
greeters92610113greeters
greyness1235243greyness
grinners9288043grinners
groaner82510133groaner_
guessers9174903guessers
gunners83111733g_unners
headers113819393_headers
healers104319463_healers
heapers123616673_heapers
hearers104319783_hearers
heaters104225223_heaters
heavers133717193_heavers
keeners113610783_keeners
klezmers2341583klezmers
kneaders1384713kneaders
laagers83411253_laagers
lacers85225253_l_acers
laders74927763_l_aders
lagers74826143_l_agers
lakers105225153_l_akers
lancers93616643_l_ancers
landers84026213_l_anders
lanes54946793_l_ane_s
lanners73618333_lanners
lasers64925703_l_asers
lavers94526363_l_avers
layers93921183_l_ayers
leachers133712813_leachers
leadens83610983_leadens
leader74824653_leader_
leaguers935063_leaguers
leaker104620073_leaker_
leaned73422543_leane_d
leanest7415863_leanest
leanness837373_leanness
leans55536253_lean__s
leaper88118943_leaper_
learner7319383_learner_
lears55938733_lea__rs
leaser65322673_leaser_
leases65428113_lease_s
leathers114215083_leathers
leavens10409303_leavens
leaver94321513_leaver_
leaves94222383_leave_s
lechers123313963_lechers
ledgers94912173_ledgers
leers54828983_le__ers
legers74518313_le_gers
lenders84419643_lenders
lenes54738523_le_ne_s
leones64417723_leone_s
lepers84817323_le_pers
letters73819853_letters
levanters1254993_levanters
levers94621323_le_vers
leviers103510343_leviers
lianes63819323_liane_s
limners93311563_limners
liners65428853_l_iners
loaders83413433_loaders
loafers10349463_loafers
loaner64416503_loaner_
loners64225813_l_oners
meanders1168833_meanders
meaner84617843_meaner_
moaners92813553_moaners
oleander936403oleander_
oleasters936733oleasters
oleates7417833oleate_s
oleines7313393oleine_s
openers9339493ope_ners
penners93414183_penners
placers114515263pl_acers
planer84122653pl_aner_
planes85028083pl_ane_s
planets93914083pl_anets
planners10399933planners
planters102915323pl_anters
platers93924093pl_aters
players124313763pl_ayers
pleader103511753pleader_
pleaser93912343pleaser_
pleases94515483please_s
pleater93916333pleater_
pleathers1446453pleathers
pledgers12387643pledgers
preavers13910263preavers
preeners102712813preeners
readers83823773_readers
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
reavers108320743_reavers
relaters83218153relaters
relaxers15298263relaxers
releasers937323releasers
sealers74323553_sealers
seamers94719433_seamers
seaters74028943_seaters
seiners74219273_seiners
shearers113911323shearers
skeanes113610713skeane_s
slakers114115753sl_akers
slanders94014013sl_anders
slaters73123733sl_aters
slavers103716503sl_avers
slayers104513323sl_ayers
sleaves103813203sleave_s
sleazes162810333sleaze_s
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
smearers10308623smearers
sneakers12308643sneakers
speakers14299453speakers
spearers103711143spearers
stealers83412203stealers
steamers103410873steamers
swearers11328583swearers
sweaters113811063sweaters
tearers75218233_tearers
teasers75317243_teasers
teeners74415453_teeners
tenners74014923_tenners
theaters114211903theaters
treaders93311843treaders
treaters83615843treaters
tweeners11306243tweeners
vealers103214293_vealers
veiners104112523_veiners
weaner93816773_weaner_
wearers104615903_wearers
weavers133714463_weavers
weiners103913063_weiners
wieners103212483wie_ners
wreakers15328423wreakers
yearners11346373_yearners

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623317.06320694.0
3Display Results3313310.1232691.1
 (SQL Overall)1786913317.34224338.2
 
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.