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 “bagging” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

139 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
bagging12331698(None) 
badging123712791badging
baggings13307521baggings
banging114019861banging
barging114018481barging
begging123012651begging
bigging122815881bigging
blagging13319171blagging
bogging123615751bogging
bragging13359331bragging
bugging123515181bugging
fagging133714761fagging
gagging93013531gagging
hagging133114681hagging
jagging173311991jagging
lagging103316741lagging
nagging102613041nagging
ragging103516681ragging
sagging103116101sagging
tagging103014911tagging
wagging133313351wagging
zagging193210451zagging
abegging1334482abegging
ageing84213402_ageing
aging77026352_a_ging
baaing94916162ba_aing
babying1537962babying
baching156017752baching
backing165523442backing
baffing164011602baffing
baggie102912192baggi_e
baggier113611642baggier
baggies113814852baggies
baggily1436042baggily
bagwig1343082bagwi_g
bailing103723522bailing
baiting103918882baiting
baking135626622ba_king
balding114015062balding
baling94829692ba_ling
balking143717352balking
balling104424762balling
bamming144611812bamming
banding114921412banding
baning95127832ba_ning
banking144621352banking
banning103818232banning
barbing123716992barbing
barding113822892barding
barfing134615092barfing
baring95135852ba_ring
barking144724182barking
barning104320352barning
barring104021592barring
bashing135422582bashing
basing95427662ba_sing
basking144718612basking
basting104227202basting
bathing134816242bathing
bating95132252ba_ting
batting104422272batting
batwing13509812batwing
bawling133813862bawling
baying125222582ba_ying
biggin103710602biggin_
biggings13327472biggings
biggins113410692biggins
bilging114212682bilging
binging113619382binging
blaggings14324462blaggings
blogging13369012blogging
boggling13257162boggling
bonging113316372bonging
budging124313022budging
bugling113615342bugling
bulging113514212bulging
bunging113616502bunging
cadging123610972cadging
caging105321022ca_ging
clagging13328882clagging
cogging123513712cogging
daggling12237062daggling
danging103716092danging
debagging1533592debagging
digging113513702digging
dogging113312692dogging
dragging12308102dragging
eagling91113602eagling
egging93210982_egging
fadging134210242fadging
figging133313562figging
flagging14329232flagging
fogging133513732fogging
fragging14329422fragging
fugging133912912fugging
gaggling10217462gaggling
gaging94718402ga_ging
ganging103216192ganging
gauging10339962gauging
gigging93311772gigging
haggling14227272haggling
hanging123518702hanging
hogging133112802hogging
hugging132710632hugging
igging93212072_igging
jigging173011552jigging
jogging173211232jogging
jugging172910722jugging
kegging14328292kegging
laggings11298402laggings
legging103912642legging
logging103316812logging
lugging104114352lugging
mogging123311492mogging
mugging122711792mugging
nogging103612722nogging
paging104020402pa_ging
panging113319112panging
parging113318602parging
pegging122811132pegging
pigging123614672pigging
pugging122912542pugging
raging85126432ra_ging
ranging94120262ranging
rigging103016332rigging
rugging102512762rugging
shagging14349052shagging
slagging113711582slagging
snagging11319372snagging
stagging113310512stagging
swagging14328092swagging
tanging93419532tanging
togging103512742togging
tugging102611232tugging
vegging13308872vegging
waggling14197062waggling
waging114318382wa_ging
wigging133413832wigging
zigging193210532zigging

Search took 4 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 Filter1786911076710.423422437.4
2DLD Change Limit1076711393.15634116.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911393.64249064.0
 
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.