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

130 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
bumpering163659(None) 
buffering1835222buffering
buggering1435192buggering
bumping143812492bump__ing
bunkering16207102bunkering
buttering122312532buttering
compering163414162compering
cumbering16108202cumbering
hampering1738862hampering
lumbering14117932lumbering
numbering14107002numbering
pampering1638382pampering
simpering1449292simpering
summering1458752summering
supering11317682su_pering
tampering1438452tampering
tempering1438732tempering
umbering1399432_umbering
umpiring1336092_umpiring
badgering1436973badgering
bannering12208813bannering
bantering122414243bantering
barbering14229693barbering
bartering122313653bartering
battering122715153battering
beavering1538703beavering
bemiring13239603bem_iring
bettering122212763bettering
bickering1837673bickering
bittering122512003bittering
blubbering14103443blubbering
blundering1444823blundering
blustering13106183blustering
bordering1338833bordering
bothering152210203bothering
bouldering1464763bouldering
bowering142911713b_owering
brokering1636283brokering
bucketing1835713bucketing
bucklering1944043bucklering
budgeting1444023budgeting
buffeting1843783buffeting
bulleting1236643bulleting
bullring11388423bu_llring
bumbling15249763bum_bling
bumming143410783bum__ming
bumper123714343bumper___
bumpered1536003bumper_ed
bumpers133912053bumper__s
bumpkin1743613bump_kin_
bumpkins1843703bump_kins
burdening1335543burdening
burping124012943burp__ing
burring104016993bu__rring
busheling1535503busheling
butchering1844503butchering
cambering16109873cambering
capering132414963_capering
comparing162410583comparing
compeering1747053compeering
competing163712463competing
coopering142611323coopering
coppering162810893coppering
cupeling1338863cu_peling
dampening1535463dampening
diapering1339033diapering
dumping133712913dump__ing
dumpling14217893dump_ling
fullering1336653fullering
guttering112410443guttering
hammering1737633hammering
homering141512073hom_ering
humoring1456853hum_oring
humouring1544553humouring
humphing1935163hump_hing
humping153213073hump__ing
hungering14187683hungering
hunkering17227123hunkering
impeding1436563_impeding
juddering1933763juddering
jumping19319803jump__ing
kippering18205443kippering
lappering14258843lappering
limbering1488793limbering
lippering14217883lippering
loppering14237283loppering
lumberings15103783lumberings
lumping123314643lump__ing
lustering102711203lustering
mammering1337333mammering
mumping143411633mump__ing
murdering1357133murdering
mustering122212333mustering
muttering122611323muttering
papering132213313_papering
paupering1437273paupering
peppering1337083peppering
plumpening1742443plumpening
puckering1835883puckering
pummeling1643603pummeling
pumping144213553pump__ing
puttering122611643puttering
quavering2235953quavering
queering1838203qu_eering
quivering2235873quivering
rubbering1435703rubbering
rumoring1136983rum_oring
rumouring1244513rumouring
rumpling13178763rump_ling
scampering1745323scampering
scuppering1754023scuppering
simmering1467823simmering
slumbering15105323slumbering
suckering1638103suckering
suffering1637293suffering
sundering11312323sundering
suspiring1245703suspiring
tapering112112503_tapering
timbering14117723timbering
trumpeting1543573trumpeting
tuckering1635693tuckering
tumping123114243tump__ing
ulcering1139333_ulcering
umping114815333_ump__ing
ushering1258923_ushering
uttering91613083_uttering
whimpering2143853whimpering
wuthering1697803wuthering
yammering1735193yammering
zippering23215203zippering

Search took 7 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.420425454.8
2DLD Change Limit1486411306.42323142.0
3Display Results1301300.0632063.5
 (SQL Overall)1786911306.90625874.7
 
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.