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

105 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
jagging17331199(None) 
bagging123316981bagging
fagging133714761fagging
gagging93013521gagging
hagging133114681hagging
jigging173011551jigging
jogging173211231jogging
jugging172910721jugging
lagging103316731lagging
nagging102613041nagging
ragging103516681ragging
sagging103116101sagging
tagging103014911tagging
wagging133313351wagging
zagging193210451zagging
ageing84213402_ageing
aging77026352_a_ging
badging123712792badging
baggings13307522baggings
banging114019862banging
barging114018482barging
begging123012652begging
bigging122815882bigging
blagging13319162blagging
bogging123615752bogging
bragging13359332bragging
bugging123515182bugging
cadging123610972cadging
caging105321022ca_ging
clagging13328872clagging
cogging123513712cogging
daggling12237062daggling
danging103716092danging
digging113513702digging
dogging113312692dogging
dragging12308102dragging
eagling91113602eagling
egging93210982_egging
fadging134210242fadging
figging133313562figging
flagging14329222flagging
fogging133513732fogging
fragging14329422fragging
fugging133912912fugging
gaggling10217462gaggling
gaging94718402ga_ging
ganging103216192ganging
gauging10339962gauging
gigging93311772gigging
haggling14227272haggling
hanging123518702hanging
hogging133112802hogging
hugging132710632hugging
igging93212072_igging
jabbing19319412jabbing
jacking214515262jacking
jading154214022ja_ding
jaggier16339182jaggier
jaggies163311082jaggies
jailing153415842jailing
jambing19328532jambing
jamming19329792jamming
jangling17249622jangling
japing165013572ja_ping
jarring153613192jarring
jauking19418322jauking
jauping17307192jauping
jawing174414962ja_wing
jazzing2333882jazzing
jiggling18226362jiggling
joggings18264632joggings
joggling18215572joggling
judging17337932judging
juggling18225602juggling
kegging14328292kegging
laggings11298402laggings
legging103912642legging
logging103316802logging
lugging104114352lugging
mogging123311492mogging
mugging122711792mugging
nogging103612722nogging
paging104020402pa_ging
panging113319112panging
parging113318602parging
pegging122811132pegging
pigging123614672pigging
pugging122912542pugging
raging85126432ra_ging
ranging94120262ranging
rigging103016332rigging
rugging102512762rugging
shagging14349052shagging
slagging113711572slagging
snagging11319372snagging
stagging113310512stagging
swagging14328092swagging
tanging93419522tanging
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.360496363.9
2DLD Change Limit1076711052.89037256.4
3Display Results1051050.0303500.0
 (SQL Overall)1786911053.28054479.0
 
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.