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

224 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
beastings1238765(None) 
bastings114214691b_astings
beatings114113231bea_tings
beestings12335921beestings
blastings12347911blastings
eastings93412951_eastings
bashings144311242b_ashings
basting104227202b_asting_
battings114010572b_attings
beadings123711782bea_dings
bearings113912252bea_rings
beasties102514652beasti_es
beating104326872bea_ting_
beeswings15293302beeswings
beltings11369252be_ltings
besting104923922be_sting_
biestings12266032biestings
blasting114013432blasting_
boasting113512502boasting_
boatings113710112boa_tings
breasting1239582breasting_
castings113614052_castings
coastings12357862coastings
easting84924302_easting_
eatings84616442_ea_tings
fastings124011942_fastings
feasting122011322feasting_
jestings16368022je_stings
lastings94214422_lastings
leasings9379842leas_ings
seatings93614302sea_tings
vestings12359142ve_stings
westings12429802we_stings
yeasting12188922yeasting_
actings104512463__actings
antings85015583__antings
askings12519173__askings
backings174012213b_ackings
baggings13307523b_aggings
baiting103918883b_aiting_
bakings144312023b_a_kings
bankings15489403b_ankings
bantengs1134593b_antengs
bantlings12216603b_antlings
bashing135422583b_ashing_
basing95427663b_as_ing_
basins85722763b_as_in_s
basking144718613b_asking_
bastiles10313353b_astiles
bastions10411693b_astions
bating95132253b_a_ting_
batting104422273b_atting_
beaching164114143beaching_
beading113221863bea_ding_
beaming123618803bea_ming_
beaning103820683bea_ning_
bearding124011943bearding_
bearing103624773bea_ring_
bearskins1543373bearskin_s
beastie92412433beasti__e
beastliness1343333beastliness
beasts84519723beast___s
beatniks1444043bea_tniks
beauties10229523beauti_es
becomings1643783becomings
beddings13407923be_ddings
bedsprings1642353bedsprings
bedstands1343503bedstands
beeswing14255763beeswing_
beings94613033be___ings
bellings113811153be_llings
belting104119133be_lting_
bemisting1438073bemisting_
berating113220763berating_
bestirs9311133be_sti_rs
betting103921403be_tting_
biasing103512453bias_ing_
biassing11307263biassing_
bittings11339293b_ittings
blackings18316763blackings
bladings12337753bla_dings
blaggings14324463blaggings
blasties102113633blasti_es
blatting114111653blatting_
bleating113514503blea_ting_
blessings1233723blessings
boardings13296063boardings
boating103721303boa_ting_
boosting113311053boosting_
bowstrings16173223bowstrings
bracings13369293bra_cings
braidings13285903braidings
brandings13277483brandings
brassing112612303brassing_
breakings16297063brea_kings
breastpins1442713breastpin_s
breathings16234313breathings
brislings12236363brislings
buntings11348773b_untings
bursting1138703bursting_
bushings14348793b_ushings
busings103711223b_us_ings
bussings11386663b_ussings
busting104221793b_usting_
casings104013513_cas_ings
casting104628343_casting_
ceasing104118263ceas_ing_
chasings14318253chas_ings
coasting113615513coasting_
coatings113811843coa_tings
crestings12298043crestings
dealings103510703dea_lings
deashing134210953deashing_
demasting1338453demasting_
destines93619663de_stines
draftings14334213draftings
dustings10419033_dustings
eanlings9128473_eanlings
earings84517713_ea_rings
earnings9419333_earnings
earrings9299633_earrings
easing74926463_eas_ing_
eating75134403_ea_ting_
elastins82111743elastin_s
emptings1364823_emptings
fasting114522833_fasting_
feasing113916653feas_ing_
feltings12317903fe_ltings
flashings16316663flashings
frostings1335733frostings
gaskings14427473_gaskings
gassings10438403_gassings
gasting95022763_gasting_
gatings95212823_ga_tings
gearings10359503gea_rings
ghostings1433483ghostings
gratings103910763gra_tings
hasting114725193_hasting_
headings133510493hea_dings
hearings123611853hea_rings
hearting12513123hearting_
heating114024323hea_ting_
heisting123411043heisting_
hustings12378683_hustings
jesting154317713je_sting_
kartings13418523_kartings
lashings124412253_lashings
lasting84725243_lasting_
leadings103511243lea_dings
leanings94010183lea_nings
learnings1094323learnings
leashing123310313leashing_
leasing83920163leas_ing_
leavings12407493lea_vings
listings93310043_listings
maskings15448753_maskings
masting104325823_masting_
matings104516213_ma_tings
mattings11369673_mattings
meanings11329163mea_nings
meetings11287413me_etings
mestinos1048163me_stinos
nesting84320443ne_sting_
nestlings1074313ne_stlings
nettings9288103ne_ttings
partings113513743_partings
passings11409873_passings
pastinas103712163_pastinas
pasting103826553_pasting_
pettings11349703pe_ttings
plaitings12296243plaitings
plantings12348403plantings
platings113611363pla_tings
postings112912303_postings
raspings11337853_raspings
ratings84217413_ra_tings
reacting113317893reacting_
readings103512643rea_dings
reasonings1143653reasonings
reassigns1074353reassigns
recasting122414233recasting_
reesting93118273reesting_
repasting122312843repasting_
resting85031183re_sting_
restrings10159293re_strings
retasting102513413retasting_
roasting93012703roasting_
saltings92811253_saltings
seasonings1143293seasonings
seating84130683sea_ting_
seisings9398523seis_ings
sestinas8249133se_stinas
sestines82717243se_stines
settings93810073se_ttings
shaftings16224183shaftings
skatings13326993ska_tings
slashings13316203slashings
slatings94011723sla_tings
slattings10346073slattings
stings76220183___stings
tasting84624213_tasting_
tattings9408823_tattings
teachings15296553teachings
teasing83918513teas_ing_
testing86021053te_sting_
toasting93410583toasting_
twistings13264353twistings
vesting114618683ve_sting_
waistings1352710763waistings
waitings123413743_waitings
washings15419273_washings
wasting114422843_wasting_
weaklings1794003weaklings
weanlings1394413weanlings
weltings12388203we_ltings
westing115020273we_sting_
wettings12348403we_ttings
yealings12257703yea_lings
yeanlings1393693yeanlings
yearlings1384203yearlings
yearnings1393553yearnings
yeastiness1344883yeastiness
zeatins16311733zea_tin_s
zesting174515333ze_sting_

Search took 9 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.436409841.7
2DLD Change Limit1486412247.66019404.8
3Display Results2242240.0932408.6
 (SQL Overall)1786912248.18921820.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.