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

493 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
learning97855(None) 
earning83418211_earning
leaning83721201lea_ning
learnings1094321learnings
yearning1296981yearning
barning104320352_barning
beaning103820682bea_ning
bearding124011942bearding
bearing103624772bear_ing
blearing113111942blear_ing
cleaning113112382clea_ning
clearing113014882clear_ing
clearwing1533672clearwing
darning93817332_darning
deaning94020472dea_ning
earing75235482_ear_ing
earnings9419332_earnings
earring83519012_earring
fearing113520032fear_ing
gearing92818842gear_ing
gleaning10269322glea_ning
hearing113324162hear_ing
hearsing1239382hearsing
hearting12513122hearting
kerning124010892ke_rning
larding92917872l_arding
larking123718252l_arking
leaching143012832leaching
leadening1176732leadening
leading93419552lea_ding
leafing113313582lea_fing
leaguing1035342leaguing
leaking123616972lea_king
leanings94010182lea_nings
leaping103215992lea_ping
leashing123310312leashing
leasing83920162lea_sing
leavening1365972leavening
leaving114216852lea_ving
leering83417642leer_ing
loaning83614832loa_ning
meaning103918702mea_ning
nearing83020332near_ing
pearling11912012pearling
rearing83128782rear_ing
rearming111413612rearming
reearning1039052reearning
relearning1135282relearning
searing83330922sear_ing
tearing84021492tear_ing
unlearning1144712unlearning
warning113717092_warning
weaning114117192wea_ning
wearing113318862wear_ing
wearying1546702wearying
yarning113512952_yarning
yeaning113814632yea_ning
yearling1297882yearling
yearnings1393552yearnings
aborning1188003aborning
adorning1087323adorning
aerating92821003aerating
alarming1138583alarming
alerting91312383ale_rting
anearing9413973anear_ing
arcing95819643__arcing
arming94719803__arming
awarding1356043awarding
awning105013393__awning
baning95127833_ba_ning
banning103818233_banning
barbing123716993_barbing
barding113822893_barding
barfing134615093_barfing
barging114018483_barging
baring95135853_bar_ing
barking144724183_barking
barring104021593_barring
beaching164114143beaching
beaconing1436633beaconing
beading113221863bea_ding
beaming123618803bea_ming
bearings113912253bear_ings
beating104326873bea_ting
bedamning1534183bedamning
beraking153612973beraking
berating113220763berating
berming123614833be_rming
berrying14137373berrying
bewaring14279493bewar_ing
blaring104317113blar_ing
bleaching17287093bleaching
bleating113514503blea_ting
boarding123110233boarding
braining113414683braining
branning112911093branning
burning104215503_burning
caning94128623_ca_ning
canning103620133_canning
carding113922433_carding
caring95137993_car_ing
carking144322853_carking
carling103727063_carling
carping123521083_carping
carting104228283_carting
carving133916773_carving
ceasing104118263cea_sing
cering94522533ce_r_ing
chaining142810783chaining
charging152910773charging
charing133721323char_ing
charking183512613charking
charming163012033charming
charring142913163charring
charting142614193charting
churning14237173churning
cleansing1235073cleansing
clearings12286063clear_ings
clearwings1651703clearwings
cleating113518133clea_ting
cleaving141389683clea_ving
clerking15257163cle_rking
corning103720123_corning
craning103620303cra_ning
damning114211633_damning
daring84928683_dar_ing
darking134217343_darking
darling93418363_darling
darnings10378553_darnings
darting94020663_darting
dawning124111013_dawning
deaconing1337193deaconing
deadening1277583deadening
deafening1476273deafening
deairing10311893deairing
dealing94323233dea_ling
deashing134210953deashing
deaving123814753dea_ving
debarking1735383debarking
debarring1335713debarring
deboning12109153deboning
decerning1337293decerning
decrying15237413decrying
defining133711803defining
dehorning1455243dehorning
deigning1137753deigning
demarking1736773demarking
denning93515173de_nning
departing1349513departing
deponing121211213deponing
deranging1238063deranging
derating103222283derating
detaining112510473detaining
draining103312673draining
durning93511733_durning
dwarfing1633613dwarfing
eagling91113603_eagling
eanling81416673_eanling
earings84517713_ear_ings
earrings9299633_earrings
earthing12310323_earthing
earwig10114703_earwi_g
easing74926463_ea_sing
easting84924303_easting
eating75134403_ea_ting
elapsing1146713elapsing
elating83423083ela_ting
eloining9310443eloining
erasing8317963_erasing
erring73816483_e_rring
evening11310223_evening
fanning113615073_fanning
farcing133514003_farcing
farding123716743_farding
faring105231283_far_ing
farming133515083_farming
farting114120753_farting
fawning14409133_fawning
feasing113916653fea_sing
feasting122011323feasting
feazing205411443fea_zing
feigning1335813feigning
ferrying15146243ferrying
flaring114116803flar_ing
fleering123811283fleer_ing
gaining94015663_gaining
garbing113613273_garbing
garring93116713_garring
gearings10359503gear_ings
girning93210693_girning
glaring93714883glar_ing
gleaming12277933glea_ming
gleanings11244643glea_nings
gnarling10217603gnarling
gnarring10225973gnarring
graining102813183graining
guarding1136523guarding
haring104233003_har_ing
harking154120943_harking
harming133717933_harming
harping134118383_harping
heading122919113hea_ding
healing113922963hea_ling
heaping133015853hea_ping
hearings123611853hear_ings
hearkening1844533hearkening
heartening1446733heartening
heating114024323hea_ting
heaving144114763hea_ving
heiring113312903heir_ing
herding122915123he_rding
herring113615883he_rring
herrying15147023herrying
hoarding13288643hoarding
horning113015003_horning
inarming1138343inarming
inurning937553inurning
jarring153613193_jarring
jeering153513043jeer_ing
jerking19308923je_rking
karting123716063_karting
keening123713153ke_ening
kenning124010543ke_nning
kerbing14308483ke_rbing
kerfing15307533ke_rfing
kirning12319333_kirning
lacing94626233l_a_cing
lacking143821543l_acking
ladening1078823ladening
lading84227123l_a_ding
ladling92813393l_adling
lagging103316733l_agging
lairing83715343l_airing
laking115027043l_a_king
lalling83519623l_alling
lambing123412413l_ambing
laming94528363l_a_ming
lamming123014583l_amming
lamping123116003l_amping
lancing103314123l_ancing
landing92819323l_anding
lapping124117023l_apping
lapsing103511163l_apsing
lapwing13308263l_apwing
larine63927043l_ar_ine
lashing114422893l_ashing
lasing74727983l_a_sing
lasting84725243l_asting
latening9711493latening
lathing114315693l_athing
lauding93211903l_auding
laving104623573l_a_ving
lawing104625283l_a_wing
laying104525703l_a_ying
lazing164821473l_a_zing
lazying2046673l_azying
leadings103511243lea_dings
learier73415663lear_ier
learn55322663lear__n_
learned8329303learn_ed
learner7319383learn_er
learners8398153learners
learns65513743lear__ns
learnt64019253lear__nt
leasings9379843lea_sings
leavenings1472583leavenings
leavings12407493lea_vings
leching134613653le_ching
leeching14318373leeching
leftwing1532973leftwing
legating102313113legating
legging103912643le_gging
lekking11306503le_kking
lemming12269393le_mming
lending94118533le_nding
leniting9312353leniting
lensing84015103le_nsing
leonine7311233le_onine
lesioning1046443lesioning
lessening1045333lessening
lessoning1044773lessoning
letching143810263letching
letting83218533le_tting
levanting1345523levanting
leveeing12265963leveeing
leveling122910433leveling
levering122212503levering
levying1435873le_vying
liaising937913liaising
likening13246893likening
limning103710323l_imning
lining74526803l__ining
livening12248153livening
loading94114613loa_ding
loafing11319793loa_fing
loaming103613733loa_ming
loanings9348013loa_nings
loathing1247673loathing
lording93115233l_ording
louring83916503lour_ing
luring73820753l_ur_ing
lurking123710853l_urking
manning103616383_manning
marking144020133_marking
marling103322763_marling
marring103319553_marring
marting103325013_marting
meanings11329163mea_nings
merging112711763me_rging
metring103215293metr_ing
mislearning1443723mislearning
moaning103714443moa_ning
morning103215043_morning
mourning1156793mourning
narking124015383_narking
neatening1038353neatening
nerving112910833ne_rving
nonearning1145183nonearning
oaring74225303_oar_ing
outearning1146743outearning
outlearning1243543outlearning
paining103920243_paining
panning104019393_panning
parging113318603_parging
paring94236493_par_ing
parking143423043_parking
parling103823763_parling
parring103222063_parring
parsing103819553_parsing
parting103527383_parting
pawning134711413_pawning
peaching163613643peaching
peacing124117073pea_cing
peaking144317693pea_king
pealing104123203pea_ling
peening103318303pe_ening
peering103520353peer_ing
peining104619153pe_ining
penning103616493pe_nning
perking143716463pe_rking
perming123416093pe_rming
pharming16248143pharming
plaining113911553plaining
planing103418253pla_ning
planning113610223planning
pleaching17257083pleaching
pleading123011443plea_ding
pleasing112611593plea_sing
pleating112916053plea_ting
prawning1446963prawning
prearming14139223prearming
prewarning16135193prewarning
raining83922693_raining
raring74332873_rar_ing
reaching143317203reaching
reacting113317893reacting
readding11411363readding
reading93327213rea_ding
readorning1245723readorning
readying13410223readying
reaming103924013rea_ming
reaping103621213rea_ping
rearguing1135603rearguing
reasoning10310203reasoning
reaving113820533rea_ving
recaning111416693recaning
redrying13209023redrying
refining122416863refining
refrying15278903refrying
regaining112411083regaining
regarding12149153regarding
reigning1039883reigning
reining84425323re_ining
relining93218743relining
remaining122212793remaining
remanning12229033remanning
remarking1638893remarking
reparking1638923reparking
repining114116593repining
resining92919553resining
retaining102114733retaining
retarding111110653retarding
retrying122410453retrying
retuning9311583retuning
returning1038133returning
rewarding14148833rewarding
rewarming15147383rewarming
rezoning18310453rezoning
roaring82916003roar_ing
saining83621393_saining
saning75127643_sa_ning
scanning113310773scanning
scarfing14309713scarfing
scaring103421973scar_ing
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
scorning1169133scorning
seagoing1038193seagoing
sealing83528563sea_ling
seaming103222113sea_ming
searching1538343searching
seasoning1037413seasoning
seating84130683sea_ting
secerning1246203secerning
seining84020773se_ining
serging93416673se_rging
sering74731813se_r_ing
serrying12167693serrying
serving113014983se_rving
sharing113723243shar_ing
sharking163912973sharking
sharping143011373sharping
shearing123915903shear_ing
shearling1336923shearling
sleaving123310983slea_ving
smarting113212453smarting
smearing113511753smear_ing
snarfing12358663snarfing
snaring83920953snar_ing
snarling92513183snarling
soaring83521893soar_ing
sorning83116813_sorning
spanning113311083spanning
sparging122611133sparging
sparing104823873spar_ing
sparking152812543sparking
sparling112714533sparling
sparring113112223sparring
spawning14296913spawning
speaning113512243spea_ning
spearing113216103spear_ing
spurning11258663spurning
staining9413373staining
staning83922243sta_ning
staring84527053star_ing
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
swanning12338813swanning
swarding1359003swarding
swarming1458223swarming
swearing123711443swear_ing
tanning83618253_tanning
taring73932283_tar_ing
tarring83318303_tarring
tarting84222653_tarting
teaching143612603teaching
teaming103917593tea_ming
teasing83918513tea_sing
teazling1856573teazling
tenoning938893tenoning
terming104016003te_rming
thorning1237513thorning
training93015863training
turning83713183_turning
unarming1138623unarming
vanning113912463_vanning
varying1429723_varying
vealing114217423vea_ling
veering113213683veer_ing
veining114713893ve_ining
verging123812303ve_rging
versing112314193ve_rsing
waning103623803_wa_ning
wanning113816213_wanning
warding123918143_warding
waring105029443_war_ing
warking153519573_warking
warming133515083_warming
warnings12358453_warnings
warping133715183_warping
warring113717973_warring
weakening1734843weakening
weakling16106763weakling
weanling12118643weanling
weaponing1545383weaponing
weaving143211623wea_ving
weening114113973we_ening
weirding1335593weirding
wharfing1834683wharfing
yarding123413143_yarding
yawning14378343_yawning
yealing112716383yea_ling
yeanling12107063yeanling
yearlings1384203yearlings
yearlong12102573yearlong
yearningly1743383yearningly
yeasting12188923yeasting
yenning11369493ye_nning
yerking15368813ye_rking
zeroing1738343ze_roing

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.406440125.6
2DLD Change Limit1461624936.85621318.8
3Display Results4934930.2062393.2
 (SQL Overall)1786914937.46823927.6
 
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.