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

372 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
snogged1041797(None) 
nogged95716331_nogged
shogged13397951shogged
slogged104910461slogged
snagged104010661snagged
snugged10408021snugged
sogged95518521s_ogged
bogged116019282_bogged
clogged12528652clogged
cogged116416612_cogged
dogged106017702_dogged
flogged13528802flogged
fogged125518372_fogged
frogged13408492frogged
hogged125817772_hogged
jogged166015922_jogged
logged96622942_logged
mogged115215392_mogged
nagged93916052_nagged
progged12409792progged
sagged94120002s_agged
shagged134210122shagged
slagged104312762slagged
slogger94310482slogger
slugged104410372slugged
snigger9328372snigger
sniggled11275742sniggled
snooded94110362snooded
snooked123711492snooked
snooled84513932snooled
snooped103711812snooped
snooted84213272snooted
snoozed173410122snoozed
snored74819542sno_red
snorted83813492snorted
snouted84311342snouted
snowed104613612sno_wed
snugger9318312snugger
snuggled11234952snuggled
sponged1137952sponged
stagged104212072stagged
stodged10377982stodged
stooged94310732stooged
swagged13419142swagged
swigged13327182swigged
togged95117512_togged
angled84219073an_gled
bagged114519903_bagged
befogged1643153befogged
begged115013803_begged
blogger11448313blogger
boggled12409003_boggled
bonged105719603_bonged
boogied11379283boogied
bragged12449843bragged
bugged114318403_bugged
chugged1584823chugged
clagged12749233clagged
clogger11438803clogger
congaed11399743congaed
congeed113212313congeed
cragged12479883cragged
defogged1533783defogged
digged104314653_digged
dodged107514683_dodged
dogger95216783_dogger
dragged11379563dragged
drugged11367173drugged
egged85114383__egged
encaged113211083encaged
engaged10379833engaged
engorged1134553engorged
enraged93511783enraged
fagged124717703_fagged
figged124013893_figged
flagged13459633flagged
flogger12449463flogger
fogger114414783_fogger
forged115519323_forged
fragged134010163fragged
frigged13439053frigged
frugged13387283frugged
fugged124615383_fugged
gagged104817153_gagged
gigged104112293_gigged
glugged11396613glugged
goggled11348953_goggled
gonged97115913_gonged
gorged95016983_gorged
gouged96214593_gouged
hagged124317703_hagged
hogger114615083_hogger
hogget114715763_hogget
hongied12308163hongied
hugged124113643_hugged
igged86012763__igged
incaged114010443incaged
ingoted939183ingoted
jagged164115353_jagged
jigged164412773_jigged
jogger154713163_jogger
joggled17398433_joggled
jugged163813933_jugged
kegged13469243_kegged
knobbed1633703knobbed
knocked13236293knocked
knolled12296563knolled
knopped16355443knopped
knotted12357223knotted
knouted12416763knouted
lagged95520133_lagged
legged95713083_legged
lodged913815703_lodged
logger86420003_logger
longed87121373_longed
lugged94417053_lugged
mugged114113833_mugged
nagger84016123_nagger
nigger89713573_nigger
niggled10319203_niggled
nighed113811293_nighed
nocked134617383_nocked
nodded94012123_nodded
nogg65115943_nogg__
noggin8288883_noggin
noggs75811183_nogg_s
noised75416233_noised
noodged10295923noodged
noosed75018013_noosed
normed95014543_normed
nosed65524553_no_sed
noshed104413503_noshed
noted65123843_no_ted
nudged95511833_nudged
nugget8311723_nugget
ogled75915963__ogled
pegged114811903_pegged
pigged114214153_pigged
plugged12408033plugged
ponged105619353_ponged
prigged12398923prigged
progger11319373progger
pronged113912393pronged
pugged114314523_pugged
ragged94620263_ragged
renigged1135053renigged
rigged94517403_rigged
rogued84711473_rogued
rouged86717323_rouged
rugged94215373_rugged
sagger84321073s_agger
savaged1236993savaged
scoffed16266183scoffed
scolded11358853scolded
sconced12359173sconced
scooped124611743scooped
scooted103612273scooted
scoped115116653sco_ped
scored94621133sco_red
scorned10229953scorned
scoured103811153scoured
scourged1234573scourged
scouted104112033scouted
scowed124413823sco_wed
scowled13398183scowled
scragged1335813scragged
scrouged1235373scrouged
segued838513s_egued
serged84118763s_erged
shoaled113810963shoaled
shocked174611803shocked
shoed95723003sho__ed
shooed103916073sho_oed
shooled115212653shooled
shopped153512203shopped
shored105723643sho_red
shorted113614393shorted
shotted113912383shotted
shouted113911543shouted
shoved134214273sho_ved
showed135016963sho_wed
shrugged1433663shrugged
sieged85212713s_ieged
sighed113712053s_ighed
signed83413753s_igned
singed85422293s_inged
singled93914683singled
skoaled12226043skoaled
slanged94112853slanged
sledged103610313sledged
sloggers10418783sloggers
sloped94216853slo_ped
slopped123511443slopped
sloshed11329823sloshed
slotted84613873slotted
sloughed13305583sloughed
slowed104617073slo_wed
sludged103610333sludged
slugger93610673slugger
smocked16398223smocked
smoggier1243973smoggier
smoggy1354283smogg_y
smoked134311723smo_ked
smudged12326463smudged
smugger11327053smugger
smuggled13254213smuggled
snacked144013113snacked
snafued1134933snafued
snaggier10136303snaggier
snaggy11488053snagg_y
snailed83811923snailed
snaked115017593sn_aked
snapped124611203snapped
snared74824553sn_ared
snarfed11378753snarfed
snarled83612353snarled
snawed104813733sn_awed
sneaked12329693sneaked
sneaped10338813sneaped
sned56026053sn___ed
snedded10377393snedded
sneered83113973sneered
sneezed17287793sneezed
snelled83313043snelled
snibbed12325633snibbed
snicked143811633snicked
sniffed14318183sniffed
sniggered1243443sniggered
sniggers10317093sniggers
sniggle9316833sniggle
sniggler10396113sniggler
sniggles10307313sniggles
sniglet83612413sniglet
sniped94913483sn_iped
snipped123510043snipped
snog55623633sno_g__
snogging11318043snogging
snogs66017493sno_g_s
snood64616163sno__od
snooker113910303snooker
snooper93511533snooper
snooze15439983snooze_
snoozer16409183snoozer
snoozes16289763snoozes
snoozled18344493snoozled
snore55424953sno_re_
snorer64316763sno_rer
snores64324313sno_res
snorkel1135423snorkel
snorter74412653snorter
snowier1038783snowier
snowmen12246153snowmen
snowshed1534413snowshed
snubbed12347443snubbed
snuffed14308063snuffed
snuggery13253973snuggery
snuggest1045233snuggest
snuggies10246353snuggies
snuggle9275713snuggle
snuggles10306133snuggles
soaked114717593s_oaked
soaped95817973s_oaped
soared74324293s_oared
sobbed113516263s_obbed
socked134721503s_ocked
sodded94113303s_odded
soggier93410883s_oggier
soggy105413903s_ogg_y
soiled73822473s_oiled
soled65835173s_o_led
solgel737963s_olgel
soloed74515743s_oloed
solved105312933s_olved
sooted73922583s_ooted
soothed113712733soothed
sopped114819903s_opped
sorbed94916513s_orbed
sored66141783s_o_red
sorned74820043s_orned
sorted74523713s_orted
sotted74121393s_otted
soughed123811623soughed
souled75419823s_ouled
souped95017673s_ouped
soured74921863s_oured
soused74822983s_oused
sowed94933863s_o_wed
sparged113512753sparged
splodged1333263splodged
spoiled104811353spoiled
spoked134413893spo_ked
sponge939663sponge_
sponger1038523sponger
sponges10311043sponges
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spoored104411293spoored
spored94821793spo_red
sported104015433sported
spotted103713133spotted
spoused10349653spoused
spouted103412263spouted
sprigged13316213sprigged
squegged2042893squegged
staged84521563s_taged
stagger94212393stagger
stanged94113843stanged
stobbed12287493stobbed
stocked144312873stocked
stodge8369043stodge_
stodges9309083stodges
stogey105811543sto_gey
stogie7311313stogie_
stogies8413693stogies
stoked114718293sto_ked
stoled74521593sto_led
stomped124110533stomped
stoned75923143sto_ned
stooge73811663stooge_
stooges83611483stooges
stooked124312303stooked
stooled84313893stooled
stooped103813833stooped
stoped94721013sto_ped
stopped124512203stopped
stored75524213sto_red
storied8515163storied
stormed1039043stormed
stotted83511413stotted
stowed105817203sto_wed
sughed113610203s_ughed
surged84118883s_urged
swaged114212253s_waged
swagger12389333swagger
swigger12338453swigger
swinged123810793swinged
swobbed15335443swobbed
swooned11368593swooned
swooped13418753swooped
swopped15437673swopped
swotted11398703swotted
swouned11366663swouned
tagged93418123_tagged
thonged12376833thonged
togaed84711343_togaed
toggled10428653_toggled
tonged86518903_tonged
tongued946323tongued
trigged10359853trigged
tugged93813523_tugged
twigged13345283twigged
unaged83916423un_aged
uncaged113314123uncaged
unclogged1443933unclogged
unforged13238623unforged
unoiled82415473unoiled
unowned1148803unowned
unpaged113311043unpaged
unpegged1334353unpegged
unrigged1165643unrigged
unsnagged1243123unsnagged
untagged1135973untagged
unurged939143unurged
vegged124910013_vegged
vogued11457633_vogued
wagged124616123_wagged
wigged124413583_wigged
wronged12397673wronged
zagged183612513_zagged
zigged184110193_zigged

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273726.83019623.3
3Display Results3723720.1233024.4
 (SQL Overall)1786913727.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.