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

160 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
learnings109432(None) 
earnings9419331_earnings
leanings94010181lea_nings
learning978551learning_
yearnings1393551yearnings
bearings113912252bear_ings
clearings12286062clear_ings
clearwings1651702clearwings
darnings10378552_darnings
earings84517712_ear_ings
earning83418212_earning_
earrings9299632_earrings
gearings10359502gear_ings
gleanings11244642glea_nings
hearings123611852hear_ings
leadings103511242lea_dings
leaning83721202lea_ning_
leasings9379842lea_sings
leavenings1472582leavenings
leavings12407492lea_vings
loanings9348012loa_nings
meanings11329162mea_nings
warnings12358452_warnings
yearlings1384202yearlings
yearning1296982yearning_
armings103811503__armings
awnings11406713__awnings
barning104320353_barning_
beadings123711783bea_dings
beaning103820683bea_ning_
bearding124011943bearding_
bearing103624773bear_ing_
beastings12387653beastings
beatings114113233bea_tings
blearing113111943blear_ing_
boardings13296063boardings
burnings11387623_burnings
cannings113710333_cannings
cardings123812633_cardings
carlings114015853_carlings
carpings133812383_carpings
carvings143810203_carvings
churnings15233403churnings
cleaning113112383clea_ning_
clearing113014883clear_ing_
clearwing1533673clearwing_
darings93713653_dar_ings
darlings103710383_darlings
darning93817333_darning_
deadenings1393323deadenings
deafenings1562503deafenings
dealings103510703dea_lings
deaning94020473dea_ning_
eanlings9128473_eanlings
earing75235483_ear_ing_
earring83519013_earring_
earwigs11104413_earwi_gs
eastings93412953_eastings
eatings84616443_ea_tings
evenings1234383_evenings
farmings14298223_farmings
fearing113520033fear_ing_
gearing92818843gear_ing_
gleaning10269323glea_ning_
harpings14379773_harpings
headings133510493hea_dings
hearing113324163hear_ing_
hearsing1239383hearsing_
hearting12513123hearting_
herrings12379533he_rrings
hoardings14315113hoardings
hornings12238363_hornings
kartings13418523_kartings
kennings13315273ke_nnings
kerning124010893ke_rning_
lacings105013653l_a_cings
ladings93814133l_a_dings
laggings11298403l_aggings
lakings124713513l_a_kings
landings103110073l_andings
lapwings14274973l_apwings
larding92917873l_arding_
larking123718253l_arking_
lashings124412253l_ashings
lastings94214423l_astings
lathings12469853l_athings
lawings113611473l_a_wings
leaching143012833leaching_
leadening1176733leadening_
leading93419553lea_ding_
leafing113313583lea_fing_
leaguing1035343leaguing_
leaking123616973lea_king_
leaping103215993lea_ping_
learners8398153learn_ers
learns65513743lear__n_s
leashing123310313leashing_
leasing83920163lea_sing_
leavening1365973leavening_
leaving114216853lea_ving_
leering83417643leer_ing_
leggings11316193le_ggings
lemmings13254733le_mmings
linings84313073l__inings
loadings10378383loa_dings
loaning83614833loa_ning_
loathings1344213loathings
lordings10368503l_ordings
markings153410243_markings
marlings113713493_marlings
meaning103918703mea_ning_
mornings11297923_mornings
mournings1243533mournings
nearing83020333near_ing_
nervings12256323ne_rvings
pargings123410163_pargings
parings104219213_par_ings
parkings153610683_parkings
partings113513733_partings
pearling11912013pearling_
pharmings17254723pharmings
plannings12325453plannings
pleadings13285543plea_dings
readings103512643rea_dings
rearing83128783rear_ing_
rearming111413613rearming_
reasonings1143653reasonings
reearning1039053reearning_
relearning1135283relearning_
roarings9248293roar_ings
scannings12264823scannings
searing83330923sear_ing_
seasonings1143293seasonings
seatings93614303sea_tings
sergings10299213se_rgings
servings12249223se_rvings
shearings13337563shear_ings
shearlings1443533shearlings
soarings93210393soar_ings
sparlings12257153sparlings
starlings10237923starlings
tannings9268633_tannings
teachings15296553teachings
tearing84021493tear_ing_
trainings10246723trainings
turnings9287233_turnings
unlearning1144713unlearning_
veinings12306433ve_inings
warning113717093_warning_
weaklings1794003weaklings
weaning114117193wea_ning_
weanlings1394413weanlings
wearing113318863wear_ing_
wearying1546703wearying_
yarning113512953_yarning_
yealings12257703yea_lings
yeaning113814633yea_ning_
yeanlings1393693yeanlings
yearling1297883yearling_
yearningly1743383yearningly

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411606.79621871.8
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.29924481.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.