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

138 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
lagging10331674(None) 
bagging123316981bagging
blagging13319171blagging
clagging13328881clagging
fagging133714761fagging
flagging14329231flagging
gagging93013531gagging
hagging133114681hagging
jagging173311991jagging
laggings11298401laggings
legging103912641legging
logging103316811logging
lugging104114351lugging
nagging102613041nagging
ragging103516681ragging
sagging103116101sagging
slagging113711581slagging
tagging103014911tagging
wagging133313351wagging
zagging193210451zagging
ageing84213402_ageing
aging77026352_a_ging
badging123712792badging
baggings13307522baggings
banging114019862banging
barging114018482barging
begging123012652begging
bigging122815882bigging
blaggings14324462blaggings
blogging13369012blogging
bogging123615752bogging
bragging13359332bragging
bugging123515182bugging
cadging123610972cadging
caging105321022ca_ging
clanging124012122clanging
clogging13368502clogging
cogging123513722cogging
daggling12237062daggling
danging103716092danging
digging113513702digging
dogging113312692dogging
dragging12308102dragging
eagling91113602eagling
egging93210982_egging
fadging134210242fadging
figging133313562figging
flaggings15285182flaggings
flanging132710582flanging
flogging14329172flogging
fogging133513732fogging
fragging14329422fragging
fugging133912912fugging
gaggling10217462gaggling
gaging94718402ga_ging
ganging103216192ganging
gauging10339962gauging
gigging93311772gigging
glugging10316352glugging
haggling14227272haggling
hanging123518702hanging
hogging133112802hogging
hugging132710632hugging
igging93212072_igging
jigging173011552jigging
jogging173211232jogging
jugging172910722jugging
kegging14328292kegging
lacing94626232la_cing
lacking143821542lacking
lading84227122la_ding
ladling92813392ladling
lagering102212312lagering
lairing83715342lairing
laking115027042la_king
lalling83519632lalling
lambing123412412lambing
laming94528362la_ming
lamming123014582lamming
lamping123116002lamping
lancing103314122lancing
landing92819322landing
lapping124117022lapping
lapsing103511162lapsing
lapwing13308262lapwing
larding92917872larding
larking123718252larking
lashing114422892lashing
lasing74727982la_sing
lasting84725242lasting
lathing114315692lathing
lauding93211902lauding
laughing1335932laughing
laving104623572la_ving
lawing104625282la_wing
laying104525702la_ying
lazing164821472la_zing
lazying2046672lazying
leaguing1035342leaguing
leggin8268592leggin_
leggings11316192leggings
leggins9259472leggins
lodging103110812lodging
loggings11398232loggings
longing93915782longing
lugeing9359112lugeing
luging83915292l_uging
lunging93714212lunging
mogging123311492mogging
mugging122711792mugging
nogging103612722nogging
paging104020402pa_ging
panging113319112panging
parging113318602parging
pegging122811132pegging
pigging123614672pigging
plaguing1236032plaguing
plugging13306892plugging
pugging122912542pugging
raging85126432ra_ging
ranging94120262ranging
rigging103016332rigging
rugging102512762rugging
shagging14349052shagging
slanging103413432slanging
slogging113410492slogging
slugging11339422slugging
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.393454684.5
2DLD Change Limit1076711382.98336094.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911383.42252218.3
 
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.