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

203 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
beavering153870(None) 
bearing103624772bea__ring
bettering122212752bettering
beveling143011032be_veling
clavering1538372clavering
fevering152510082fe_vering
havering152211052_havering
leavening1365972leavening
levering122212502le_vering
quavering2235952quavering
revering122918072re_vering
severing122013852se_vering
slavering1338722slavering
wavering152410542_wavering
averring12239063__averring
averting122512733__averting
badgering1436963badgering
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
baring95135853b_a__ring
barring104021593b_a_rring
bartering122313643bartering
battering122715143battering
beaching164114143bea_ching
beaconing1436633beaconing
beading113221863bea__ding
beaming123618803bea__ming
beaneries11310903beaneries
beaning103820683bea__ning
bearding124011943bea_rding
bearings113912253bea__rings
beating104326873bea__ting
beaver114819253beaver___
beavered1437503beaver_ed
beavers124417323beaver__s
bebeerine1344293bebeerine
bedcovering2052663bedcovering
bedewing1537143be_dewing
bediapering1763043bediapering
bedspring1544313bedspring
beefing133911473be__efing
beeping124013913be__eping
befleaing1544023befleaing
beggaring1435183beggaring
behaving1735453behav__ing
belaboring1544033belaboring
believing1535283believing
bemiring13239603be_miring
berberin1246563berberin_
berberine1346523berberine
berberins1346713berberins
beseeming1435143beseeming
beshivering2052543beshivering
besieging1344763besieging
besmearing1544323besmearing
betattering1444143betattering
bevelling15227453be_velling
bewaring14279493be_waring
beweeping1743933beweeping
bickering1837663bickering
bittering122511993bittering
blabbering14104363blabbering
blaring104317113bla__ring
blathering16107583blathering
blattering13108713blattering
blearing113111943blea__ring
blethering16115933blethering
bordering1338833bordering
bothering152210203bothering
bowering142911713b_owering
braveries1439103braveries
braving133714613brav__ing
bravoing1445993brav_oing
brazening2185183brazening
breveting1536263breveting
brokering1636283brokering
buffering1835223buffering
buggering1435193buggering
bumpering1636593bumpering
bunkering16207103bunkering
buttering122312523buttering
capering132414963_capering
catering112019903_catering
caverning1536283_caverning
centering122915143centering
covering142215723_covering
cratering12312653cratering
cravening1547553cravening
davening13258873_davening
deadening1277583deadening
deafening1476273deafening
deairing10311893dea_iring
deaving123814753deav__ing
delivering1545173delivering
develing133212733de_veling
dewatering1545773dewatering
diapering1339033diapering
earing75235483_ea__ring
earring83519013_ea_rring
entering91920053_entering
evening11310223_e_vening
everting122213133_e_verting
favoring1596673_favoring
fearing113520033fea__ring
feathering17108793feathering
featuring1337323featuring
festering132413173festering
fettering132310513fettering
flavoring1665113flavoring
gaveling133410163_gaveling
gearing92818843gea__ring
gendering12249753gendering
gettering112310033gettering
graveling1457383graveling
havening15258553_havening
hearing113324163hea__ring
heaving144114763heav__ing
hoovering1635753hoovering
hovering151911143_hovering
jeering153513043je__ering
laagering1136833laagering
lagering102212313_lagering
laveering1336813_laveering
layering122310353_layering
leadening1176733leadening
leaguering1243813leaguering
leathering1488683leathering
leavenings1472583leavenings
leaving114216853leav__ing
lechering1538443lechering
leering83417643le__ering
lettering102112073lettering
leveeing12265963le_veeing
leveling122910433le_veling
livering122012383_livering
meandering1446983meandering
measuring1236123measuring
metering112915633me_tering
nearing83020333nea__ring
neatening1038353neatening
neutering1038963neutering
overing111918053__overing
palavering1644483palavering
papering132213313_papering
peering103520353pe__ering
peltering122011673peltering
peppering1337083peppering
perverting1646623perverting
pestering122315663pestering
petering112516813pe_tering
preaverring1743243preaverring
quivering2235873quivering
raveling123414373_raveling
ravening122611293_ravening
realtering1139473realtering
rearing83128783rea__ring
reaving113820533reav__ing
reavowing1634863reavowing
recovering1647373recovering
rendering112213183rendering
repapering1547043repapering
reveling123117083re_veling
reverbing15248593re_verbing
reversing132611483re_versing
reverting132315133re_verting
sabering112113743_sabering
savoring1269483_savoring
seafaring1345963seafaring
searing83330923sea__ring
sewering122411093se_wering
shaveling1646843shaveling
shivering1637333shivering
silvering1337923silvering
slivering1338083slivering
steamering1345443steamering
tabering112211423_tabering
tapering112112503_tapering
tearing84021493tea__ring
teaseling1036913teaseling
teazeling1934543teazeling
teddering12256303teddering
teetering10239893teetering
telfering1336253telfering
tempering1438733tempering
tendering112210813tendering
tentering102313203tentering
tethering1339133tethering
traveling1349053traveling
traversing1444803traversing
unwavering1743223unwavering
veering113213683ve__ering
veneering1337663veneering
wafering15208893_wafering
wagering13219523_wagering
watering122316313_watering
weakening1734843weakening
wearing113318863wea__ring
weaseling1335613weaseling
weathering1798353weathering
weaving143211623weav__ing
weltering13219493weltering
westering132112643westering

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 Limit1486412036.67022285.0
3Display Results2032030.0962114.6
 (SQL Overall)1786912037.20624797.5
 
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.