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

292 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
gleamers1130656(None) 
gleamer10328511gleamer_
gleaners9348071gleaners
blamers115314212bl_amers
bleaters103412322bleaters
cleaners103610542cleaners
clearers10349302clearers
cleavers13398872cleavers
creamers124111312creamers
dreamers11369002dreamers
flamers124616362fl_amers
gamers94420832g__amers
glamors1068122gl_amors
glazers174410042gl_azers
gleamed11327932gleame_d
gleamier1144912gleamier_
gleams94812252gleam__s
gleaner8379772gleaner_
glimmers13396152glimmers
gloaters9288862gloaters
greasers93410252greasers
klezmers2341582klezmers
leaders83819602_leaders
leakers113415422_leakers
leaners73718172_leaners
leapers93716662_leapers
leasers74717842_leasers
leavers103717782_leavers
pleaders113210182pleaders
pleasers104010292pleasers
pleaters103613792pleaters
reamers94221082_reamers
seamers94719432_seamers
steamers103410872steamers
allayers11156633allayers
beaders104120183_beaders
beakers134216873_beakers
bearers94619593_bearers
beaters94925043_beaters
beavers124417323_beavers
belayers13298143belayers
bladers104214683bl_aders
blamer104417143bl_amer_
blames105121863bl_ame_s
blazers184811683bl_azers
bleachers16297923bleachers
bleaker133510533bleaker_
blears85116453blea__rs
bleater94515303bleater_
bleeders11448453bleeders
bleepers12377493bleepers
blenders115210993blenders
blessers10277633blessers
blethers13429613blethers
bloaters103311023bloaters
bloomers12348823bloomers
breakers143810973breakers
cheaters133613513cheaters
claimers12298743claimers
clambers144211293cl_ambers
clammers143510693clammers
clamors11710093cl_amors
clampers143211893cl_ampers
clavers124314903cl_avers
clawers123910973cl_awers
cleaner93712303cleaner_
cleansers11335073cleansers
clearer93710823clearer_
clears84116563clea__rs
cleaver124110803cleaver_
cleaves124111623cleave_s
cleomes1138813cleome_s
coleaders1237823coleaders
creamer113714093creamer_
creamery15385983creamery
creasers103612843creasers
dealers84118613_dealers
defamers14258523defamers
delayers12268663delayers
dreamer104110843dreamer_
eagers74523683__eagers
eaters65535953__eaters
elaters74420193el_aters
emmers104013223__emmers
fearers104815273_fearers
flakers143613273fl_akers
flamens124611063fl_amens
flamer114919123fl_amer_
flames114723693fl_ame_s
flayers133912033fl_ayers
fleams115011943fleam__s
fleecers13325933fleecers
fleers96015793fle__ers
flehmens1643233flehmens
flensers1135463flensers
fleshers14339443fleshers
floaters112711513floaters
foamers123812103_foamers
framers125113823_framers
gagers84021333g__agers
gamer84928943g__amer_
games86238553g__ame_s
gammers123214563g_ammers
gapers94520473g__apers
gaters74728643g__aters
gazers164516303g__azers
gears64628693g_ea__rs
geezers17286513g_eezers
gelates83219593gelate_s
gelders93812573g_elders
genders93616783g_enders
germens1078633g_ermens
getters84216103g_etters
geysers1135703g_eysers
glaces94218033gl_ace_s
glaciers11277903glaciers
glades84820343gl_ade_s
glaires84010143gl_aires
glairs75211333gl_a_irs
glamor958193gl_amor_
glamours1184743gl_amours
glams85822933gl_am__s
glancers11408003glancers
glanders103811503glanders
glares75518873gl_are_s
glazer164212263gl_azer_
glazes165315643gl_aze_s
glaziers18406563glaziers
gleam86916733gleam___
gleamiest1235313gleamiest
gleaming12277933gleaming
gleamy12398113gleam__y
gleaned9349423gleane_d
gleans75014743glea__ns
glebes95512243gle_be_s
gledes84915133gle_de_s
gleeds84711623gle__eds
gleeks11489673gle__eks
gleemen1035723gleeme_n
glees65027593gle__e_s
gleets75315053gle__ets
glegness1034613glegness
gliders94811843gl_iders
glimes94717523gl_ime_s
glimmer12437713glimmer_
glisters93912603glisters
glitters93710543glitters
gloams95210663gloam__s
gloater83711013gloater_
glomera1035943gl_omera
glossers9319053glossers
glovers114310883gl_overs
glowers113412093gl_owers
gluers75011153gl__uers
glumes94516813gl_ume_s
glummer12417983glummer_
gnawers11356393g_nawers
gomers94116883g__omers
gossamers1243333gossamers
graders94716013g_raders
graters85419743g_raters
gravers114515273g_ravers
grazers175112453g_razers
greaser83913083greaser_
greases84816713grease_s
greatens9307593greatens
greater84416493greater_
greaves113311443greave_s
greeters92610113greeters
groaners9248503groaners
groomers11388483groomers
guessers9174903guessers
gummers123712203g_ummers
headers113819393_headers
healers104319463_healers
heapers123616673_heapers
hearers104319783_hearers
heaters104225223_heaters
heavers133717193_heavers
hemmers143310843_hemmers
klezmer2231933klezmer_
kneaders1384713kneaders
laagers83411253_laagers
lacers85225253_l_acers
laders74927763_l_aders
lagers74826143_l_agers
lakers105225153_l_akers
lambers113817113_l_ambers
lameds94812033_l_ameds
lamer75233703_l_amer_
lames75445543_l_ame_s
lampers113817333_l_ampers
lasers64925703_l_asers
lavers94526363_l_avers
layers93921183_l_ayers
leachers133712813_leachers
leadens83610983_leadens
leader74824653_leader_
leaguers935063_leaguers
leaker104620073_leaker_
leaner64022193_leaner_
leaper88118943_leaper_
learners8398153_learners
lears55938733_lea__rs
leaser65322673_leaser_
leases65428113_lease_s
leathers114215083_leathers
leavens10409303_leavens
leaver94321513_leaver_
leaves94222383_leave_s
lechers123313963_lechers
ledgers94912183_ledgers
leers54828983_le__ers
legers74518313_le_gers
lemurs837253_le_murs
lenders84419643_lenders
lepers84817323_le_pers
letters73819853_letters
levers94621323_le_vers
leviers103510343_leviers
limmers113413083_limmers
loaders83413433_loaders
loafers10349463_loafers
loaners73913623_loaners
meaners94415243_meaners
metamers1249623metamers
namers84517333__namers
oleanders1035573oleanders
oleasters936733oleasters
oleates7417833oleate_s
placers114515263pl_acers
planers94517943pl_aners
platers93924093pl_aters
players124313763pl_ayers
pleader103511753pleader_
pleaser93912343pleaser_
pleases94515483please_s
pleater93916333pleater_
pleathers1446453pleathers
pledgers12387643pledgers
preavers13910263preavers
readers83823773_readers
reamer84325213_reamer_
reapers93520453_reapers
rearers74323563_rearers
reavers108320743_reavers
relaters83218153relaters
relaxers15298263relaxers
releasers937323releasers
roamers93713463_roamers
screamers13236263screamers
sealers74323553_sealers
seamer84223613_seamer_
seaters74028943_seaters
seemers93814333_seemers
shearers113911323shearers
slakers114115753sl_akers
slammers123511223slammers
slaters73123733sl_aters
slavers103716503sl_avers
slayers104513323sl_ayers
sleaves103813203sleave_s
sleazes162810333sleaze_s
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
slimmers12369633slimmers
slummers12358933slummers
smearers10308623smearers
sneakers12308643sneakers
speakers14299453speakers
spearers103711143spearers
stealers83412213stealers
steamer93313093steamer_
stemmers12378443stemmers
streamers11228073streamers
swearers11328583swearers
sweaters113811063sweaters
tamers84224033__tamers
tearers75218233_tearers
teasers75317243_teasers
teemers95012903_teemers
termers95414503_termers
theaters114211903theaters
treaders93311843treaders
treaters83615843treaters
vealers103214293_vealers
vitamers1334683vitamers
weaners104613833_weaners
wearers104615903_wearers
weavers133714463_weavers
wreakers15328423wreakers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622926.39022873.6
3Display Results2922920.1102654.5
 (SQL Overall)1786912926.90625874.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.