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

366 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
gleaming1227793(None) 
gleaning10269321gleaning
gloaming12268011gloaming
beaming123618802_beaming
blaming123515692bl_aming
blearing113111942blearing
bleating113514502bleating
breaming133612512breaming
cleaning113112382cleaning
clearing113014882clearing
cleating113518132cleating
cleaving141389682cleaving
creaming133413142creaming
dreaming124011062dreaming
flaming134216442fl_aming
gaming104622042g__aming
gearing92818842g_earing
gelating103015732gelating
gemming13289142g_emming
glaring93714882gl_aring
glazing183611002gl_azing
gleamier1144912gleamier
gleanings11244642gleanings
gleeking14316492gleeking
gleeting10279172gleeting
gleying12318432gle_ying
gliming113310132gl_iming
gloamings13254092gloamings
gloating102611462gloating
glomming14275922glomming
glooming12358012glooming
greasing102811392greasing
laming94528362_l_aming
leading93419552_leading
leafing113313582_leafing
leaking123616972_leaking
leaning83721202_leaning
leaping103215992_leaping
leasing83920162_leasing
leaving114216852_leaving
lemming12269392_lemming
loaming103613732_loaming
pleading123011442pleading
pleasing112611592pleasing
pleating112916052pleating
reaming103924012_reaming
seaming103222112_seaming
sleaving123310982sleaving
steaming114013212steaming
teaming103917592_teaming
adeeming1254793adeeming
alarming1138583alarming
alerting91312383alerting
aliasing9310073aliasing
allaying12339303allaying
anearing9413973anearing
balsaming1445123balsaming
beading113221863_beading
beaning103820683_beaning
bearing103624773_bearing
beating104326873_beating
belaying143110603belaying
beleaping1436743beleaping
benaming1339693benaming
berming123614833_berming
blading113615363bl_ading
blaring104317113bl_aring
blawing134012753bl_awing
blazing193612393bl_azing
bleaching17287093bleaching
blebbing12265673blebbing
bleeding12359053bleeding
bleeping13377933bleeping
blending12249963blending
blessing1137593blessing
bloating113512813bloating
blooming13299433blooming
bluming123511283bl_uming
breading123515463breading
breaking153914253breaking
ceasing104118263_ceasing
cheating144014523cheating
claiming13279303claiming
clamming15329373clamming
clamping154011153cl_amping
clawing133812673cl_awing
claying133614303cl_aying
cleansing1235073cleansing
clearings12286063clearings
clearwing1533673clearwing
cleeking15267813cleeking
clefting14347583clefting
cleping123310423cle_ping
clerking15257163clerking
clewing13359583cle_wing
cloaking15299713cloaking
coaming123818323_coaming
coleading1338523coleading
creaking153414123creaking
creasing113314443creasing
creating113921953creating
dealing94323233_dealing
deaning94020473_deaning
deaving123814753_deaving
deeming113913123_deeming
defaming15238463defaming
delating103119603delating
delaying133210973delaying
deleading1237773deleading
deleaving1436263deleaving
deliming12310373deliming
dreading113712803dreading
earing75235483__earing
easing74926463__easing
eating75134403__eating
elating83423083el_ating
electing112113783electing
elevating1338203elevating
faming124922973__faming
fearing113520033_fearing
feasing113916653_feasing
feazing205411443_feazing
flaking154114493fl_aking
flamingo14274143fl_amingo
flamming16357153flamming
flaring114116803fl_aring
flawing143812563fl_awing
flaying143914463fl_aying
flecking18408233flecking
fledging14276523fledging
fleecing14347573fleecing
fleeing113511293fle_eing
fleering123811283fleering
fleeting122910323fleeting
flensing1246973flensing
fleshing15339303fleshing
flexing18358993fle_xing
fleying14329873fle_ying
floating123111883floating
fluming133512793fl_uming
foaming133612993_foaming
framing133014793_framing
freaking163611453freaking
gaeing84617223g__aeing
gaging94718403g__aging
gallamine1246123gallamine
gamin84423003g__amin_
gamine94620153g__amine
gamings114610913g__amings
gamins94420043g__amins
gamming133112623g_amming
gaping105618923g__aping
garaging1139043garaging
gating84826953g__ating
gauming11319713g_auming
gazing174717173g__azing
gearings10359503g_earings
gecking154111363g_ecking
geeing84313763g_e_eing
gelatin83514733gelatin_
gelatine93213303gelatine
gelatins93414093gelatins
gelding103911793g_elding
gelling93219763g_elling
germina1038493g_ermina
getting93316563g_etting
gheraoing1443523gheraoing
gieing83614853gie__ing
glaceing1236533glaceing
gladding1236303gladding
glairing1047283glairing
glancing1247063glancing
glassing10329973glassing
glazings19325753gl_azings
gleam86916733gleam___
gleamed11327933gleam_ed
gleamer10328513gleam_er
gleamers11306563gleamers
gleamiest1235303gleamiest
gleams94812253gleam__s
gleamy12398113gleam__y
glean65818203glea__n_
gleans75014743glea__ns
gleeman1035363gleeman_
gleemen1035723gleemen_
gleyings13283653gle_yings
gliadin935593gliadin_
gliadine1045403gliadine
gliadins1035193gliadins
gliding103911843gl_iding
glinting103210053glinting
glitzing1934973glitzing
globing113210003gl_obing
gloomings13283973gloomings
glopping14307753glopping
glorying1335543glorying
glossing10278883glossing
glouting10379693glouting
gloving12308443gl_oving
glowing123211793gl_owing
glozing18338893gl_ozing
glueing9338713gl_ueing
glugging10316353glugging
gluing83812053gl__uing
glutamine1243573glutamine
glutting10247643glutting
gnawing12377903g_nawing
goading103112853g_oading
goaling93515333g_oaling
gorming112810833g_orming
gracing113216443g_racing
grading103918713g_rading
grating93923183g_rating
graving123114563g_raving
graying124115883g_raying
grazing183514553g_razing
greeing93613783gre_eing
greening103112533greening
greeting103112353greeting
greying124110893gre_ying
griming113612493g_riming
groaning102410283groaning
grooming12309513grooming
guessing1036243guessing
guesting1058463guesting
gumming133810193g_umming
gyrating1337453gyrating
heading122919113_heading
healing113922963_healing
heaping133015853_heaping
hearing113324163_hearing
heating114024323_heating
heaving144114763_heaving
helming133712003_helming
hemming15269973_hemming
ideating10311703ideating
illuming1135873illuming
iteming1037753ite_ming
kneading1436373kneading
lacing94626233_l_acing
lading84227123_l_ading
laking115027043_l_aking
lambing123412413_l_ambing
lamina84920443_l_amina
lamming123014583_lamming
lamping123116003_l_amping
lasing74727983_l_asing
laving104623573_l_aving
lawing104625283_l_awing
laying104525703_l_aying
lazing164821473_l_azing
leaching143012833_leaching
leadings103511243_leadings
leaguing1035343_leaguing
leanings94010183_leanings
learning978553_learning
leashing123310313_leashing
leasings9379843_leasings
leavings12407493_leavings
leching134613653_leching
leering83417643_leering
legating102313113_legating
legging103912643_legging
lekking11306503_lekking
lemmings13254733_lemmings
lending94118533_lending
lensing84015103_lensing
letting83218533_letting
levying1435873_levying
liming94021243_l_iming
loading94114613_loading
loafing11319793_loafing
loaning83614833_loaning
looming102814853_looming
meaning103918703_meaning
melamine12310303melamine
naming93917893__naming
nearing83020333_nearing
outgleaming1542533outgleaming
peacing124117073_peacing
peaking144317693_peaking
pealing104123203_pealing
perming123416093_perming
placing123815283pl_acing
planing103418253pl_aning
plating103823073pl_ating
playing133816093pl_aying
pleaching17257083pleaching
pleadings13285543pleadings
pledging13276363pledging
pluming123412043pl_uming
poleaxing1944873poleaxing
prearming14139223prearming
reading93327213_reading
reaping103621213_reaping
rearing83128783_rearing
rearming111413613_rearming
reaving113820533_reaving
relacing112516043relacing
relating92725443relating
relaxing162612633relaxing
relaying122515153relaying
releasing10411013releasing
reluming11310013reluming
renaming11313693renaming
reteaming122110443reteaming
roaming103215793_roaming
salaaming1265363salaaming
screaming14217823screaming
sealing83528563_sealing
searing83330923_searing
seating84130683_seating
seeming103216263_seeming
shaming133016743_shaming
sheafing15329483sheafing
shealing123415463shealing
shearing123915903shearing
sheaving154110253sheaving
slaking123717473sl_aking
slamming133310003slamming
slating83724653sl_ating
slaving113514833sl_aving
slaying113316843sl_aying
sledding11248503sledding
sledging11288183sledging
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353sle_wing
sliming102913953sl_iming
slimming13288093slimming
slumming13278383slumming
smearing113511753smearing
sneaking133211093sneaking
sneaping11349493sneaping
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
steading103613593steading
stealing93416603stealing
stemming13408203stemming
streaming12239653streaming
swearing123711443swearing
sweating123213023sweating
taming94023433__taming
tearing84021493_tearing
teasing83918513_teasing
teeming103513093_teeming
terming104016003_terming
theming133610473the_ming
treading103515333treading
treating92519613treating
tweaking1635883tweaking
unleading1138673unleading
unseaming1278113unseaming
upleaping1434363upleaping
vealing114217423_vealing
velamina1345663velamina
weaning114117193_weaning
wearing113318863_wearing
weaving143211623_weaving
whelming17304923whelming
wreaking163010213wreaking
yealing112716383_yealing
yeaning113814633_yeaning

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.1731032896.0
2DLD Change Limit1461623667.09320606.5
3Display Results3663660.1402614.3
 (SQL Overall)1786913667.40624127.9
 
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.