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

135 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
wagging13331335(None) 
bagging123316981bagging
fagging133714761fagging
gagging93013531gagging
hagging133114681hagging
jagging173311991jagging
lagging103316741lagging
nagging102613041nagging
ragging103516681ragging
sagging103116101sagging
swagging14328091swagging
tagging103014911tagging
waggling14197061waggling
waging114318381wa_ging
wigging133413831wigging
zagging193210451zagging
ageing84213402_ageing
aging77026352_a_ging
badging123712792badging
baggings13307522baggings
banging114019862banging
barging114018482barging
begging123012652begging
bigging122815882bigging
blagging13319172blagging
bogging123615752bogging
bragging13359332bragging
bugging123515182bugging
cadging123610972cadging
caging105321022ca_ging
clagging13328882clagging
cogging123513712cogging
daggling12237062daggling
danging103716092danging
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
swaging124210632swa_ging
swigging14337222swigging
tanging93419532tanging
togging103512742togging
tugging102611232tugging
twanging13287062twanging
twigging14305672twigging
vegging13308872vegging
wadding133711942wadding
wading114619532wa_ding
waffing173710242waffing
wafting143911662wafting
wagering13219522wagering
waggish15207072waggish
waggon1136392waggon_
waggoning1543592waggoning
waggons1235502waggons
wagoning1336922wagoning
waifing142910892waifing
wailing113620902wailing
wairing113414312wairing
waiting113618952waiting
waiving14329632waiving
waking144821382wa_king
waling104525302wa_ling
walking154013302walking
walling113520972walling
wangling132310992wangling
waning103623802wa_ning
wanking154216782wanking
wanning113816212wanning
wanting114220172wanting
wapping153514602wapping
warding123918142warding
waring105029442wa_ring
warking153519572warking
warming133515082warming
warning113717092warning
warping133715182warping
warring113717972warring
washing145119282washing
wasting114422842wasting
wauking153410012wauking
wauling112713112wauling
waving134018202wa_ving
wawling143810962wawling
waxing174215282wa_xing
waxwing2154722waxwing
waygoing1633272waygoing
wedging13308722wedging
whanging16267142whanging
wiggings14316172wiggings
wiggling14217292wiggling
winging123718712winging
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.390458182.1
2DLD Change Limit1076711353.39031761.4
3Display Results1351350.0632142.9
 (SQL Overall)1786911353.84346497.8
 
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.