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

449 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
spongy123674(None) 
sponge939661sponge
podgy125610772_podgy
pogy105623552_po_gy
pong76231142_pong_
pongs85526342_pongs
pony96434052_pon_y
porgy116916122_porgy
slangy105411392slangy
smoggy1354282smoggy
soggy105413902s_oggy
song55133672s_ong_
songs67725552s_ongs
sonly85718052s_only
sonny85016102s_onny
sonsy86416372s_onsy
spang84919732spang_
spangly1336472spangly
spendy124911142spendy
spinny114510182spinny
spiny104921302spin_y
sponged1137952sponged
sponger1038522sponger
sponges10311042sponges
spongily1444902spongily
spongin1036362spongin
spoofy14498552spoofy
spooky15418092spooky
spooney12418242spooney
spoony114111792spoony
sporty115112492sporty
spotty11448572spotty
springy13359662springy
spunky15427162spunky
stingy105213202stingy
stodgy11415732stodgy
stogy95414082sto_gy
stoney96217352stoney
stony85818642ston_y
swingy13489872swingy
agony96415653agon_y
along65419493along_
among85813303among_
aping87327233aping_
apology1337913apology
astony9510523aston_y
atony87218853aton_y
boggy126116073_boggy
bogy106426193_bo_gy
boney105227313_boney
bong75633413_bong_
bongo85720943_bongo
bongs87828423_bongs
bonny105816623_bonny
bony96732083_bon_y
boogy114518323_boogy
bronzy20306713bronzy
clingy12659063clingy
cloggy1344873cloggy
coney105932883_coney
conga85419873_conga
conge85227593_conge
congo85623133_congo
conky145818743_conky
cony96537833_con_y
crony105918673cron_y
dingy105721263_dingy
dodgy116611463_dodgy
doggy115214873_doggy
dogy96126493_do_gy
dong66031653_dong_
donga76718423_donga
dongs76525813_dongs
donsy96414683_donsy
drongo836793drongo
dungy104713643_dungy
ebony104511513ebon_y
eponym1345793eponym
eponymy1743493eponymy
epoxy17465773epo_xy
flong95815683flong_
flongs105010493flongs
foggy136714543_foggy
fogy115923183_fo_gy
fringy13309263fringy
froggy1434493froggy
gong66827193_gong_
gongs74921613_gongs
gooney106612313gooney
goony95519783goon_y
groggy1234803groggy
grungy11345973grungy
hoagy124710473_hoagy
honey115629913_honey
hong85833953_hong_
hongi96715853_hongi
hongs95126203_hongs
honky156218523_honky
irony85015903iron_y
klong105310403klong_
klongs11436603klongs
lingy96925133_lingy
loggy105714193_loggy
logy87025783_lo_gy
long56933343_long_
longe66626463_longe
longly10279603_longly
longs65527063_longs
looney94712403looney
loony86918963loon_y
loungy10476833loungy
mangy115021233_mangy
mingy115520183_mingy
moggy125212163_moggy
money104826843_money
mongo810122413_mongo
mony96830003_mon_y
moony104818273moon_y
nongay10169153_nongay
ology94113113olo_gy
only75319723__only
openly1137123openly
oping86322413oping_
orangy105111233orangy
orgy85218003__orgy
pandy115021173_pandy
pang75336283_pang_
panga85323533_panga
pangs84628663_pangs
pansy105717973_pansy
panty105929303_panty
pengo84317593_pengo
penny105119453_penny
peony105717563peon_y
phoney143612983phoney
phony136715443phon_y
piggy124011433_piggy
piney105727503_piney
ping75943593_ping_
pingo87122713_pingo
pings85830883_pings
pinky145823403_pinky
pinny105222063_pinny
piny911838353_pin_y
poboy121612223_poboy
pocky165314603_pocky
poesy105014063_poesy
pogey116017893_pogey
pointy114913283_pointy
pokey145318973_pokey
poky135922153_po_ky
poly96235153_po_ly
pommy14449863_pommy
ponce95222513_ponce
pond75530493_pon_d
ponds85323403_ponds
pone65747533_pon_e
pones74547043_pones
ponged105619353_ponged
pongee94920193_pongee
pongid104111583_pongid
pons65850603_pon_s
poofy136213273_poofy
poppy114813193_poppy
popsy125713403_popsy
porky145019333_porky
porny106020193_porny
posy96028423_po_sy
potsy105815613_potsy
potty105621003_potty
pouty107018813_pouty
poxy166820893_po_xy
prong85218113prong_
prongs94314483prongs
pudgy124911163_pudgy
puggy124612323_puggy
pung75429633_pung_
pungs85422223_pungs
punky144419393_punky
punny104217713_punny
punty106021613_punty
puny95526993_pun_y
rangy95320383_rangy
saggy105917463s_aggy
sagy85327083s__agy
sandy94221133s_andy
sang55441223s_ang_
sanga66023793s_anga
sangh95517453s_angh
saponify1644183saponify
saponin9310253saponin
sarong73914873sarong_
sarongs84511803sarongs
sawney12387603sawney
saxony1636233saxon_y
scanty114014663scanty
sconce104711723sconce
scone74621833scon_e
scones84521303scones
scroggy14243843scroggy
scroungy1452563scroungy
sedgy104512783s_edgy
sengi64016513s_engi
sepoy10314303sepo__y
shaggy14478043shaggy
shandy134710033shandy
shanny124110093shanny
shanty124715113shanty
shindy13449323shindy
shingly143210803shingly
shinny124810783shinny
shiny115122143shin_y
shoaly124010763shoaly
shoddy1434533shoddy
shog86025133sho_g_
shogi95013993sho_gi
shogs95319703sho_gs
shone83725973shon_e
shorty124313193shorty
showy145714003sho_wy
simony1137903simon_y
sing57544173s_ing_
singe65731133s_inge
singly104015853s_ingly
sings65532703s_ings
siping94220633siping_
skanky12476963skanky
skinny13456613skinny
skunky12436163skunky
slaggy11438793slaggy
slang66324023slang_
slangs75615343slangs
slanty95114843slanty
sling66028803sling_
slings74618013slings
slinky13399103slinky
slobby1334803slobby
slog56728273slo_g_
slogs64521843slo_gs
sloppy1395303sloppy
sloshy12366623sloshy
slough10539233slough
sloughy14535803sloughy
slowly1237153slowly
sludgy11366253sludgy
slung65117833slung_
smog76317413smo_g_
smogs85112163smo_gs
smokey15398653smokey
smoky14388683smo_ky
smudgy13294133smudgy
snaggy11488053snaggy
snobby1334403snobby
snog55623633sno_g_
snogs66017493sno_gs
snoopy11449473snoopy
snooty94211503snooty
snoozy18517223snoozy
snotty9489193snotty
snouty9419953snouty
snowy115011563sno_wy
soapy106114783s_oapy
soddy104210703s_oddy
softy115414483s_ofty
son37761953s_on__
sonar56523423s_onar
sonde64622833s_onde
sone46649983s_on_e
sones55444143s_ones
sonic75225283s_onic
sons46049553s_on_s
sooey84522433s_ooey
soon46240503soon__
sooner64220463sooner
sooty84924833s_ooty
sophy136611763s_ophy
soppy125113523s_oppy
sorgo64719723s_orgo
sorry84618253s_orry
sough95320463s_ough
soupy106115403s_oupy
soy67851453s_o__y
spacey136212533spacey
spacy125415623sp_acy
span65234663span__
spangle1038403spangle
spank115919573span_k
spanks124514123spanks
spans74528733span_s
sparge94216043sparge
sparky154511523sparky
sparry115111303sparry
spay96631663sp__ay
speedy1218410783speedy
spence103813793spence
spend85619333spen_d
spends94714473spends
spense83912433spense
spent75532833spen_t
sphery14318883sphery
spicey134414233spicey
spicy125417713sp_icy
spiffy17326223spiffy
spikey155411333spikey
spiky146014113sp_iky
spin66231303spin__
spinage10289653spinage
spinal84915313spinal
spindly13257383spindly
spine76534423spin_e
spined95423943spined
spinel85317333spinel
spines85132033spines
spinet85629753spinet
spinney12438923spinney
spinor839943spinor
spins75327983spin_s
spinto8410663spinto
spiry105017353sp_iry
spivvy1733213spivvy
splay105816043sp_lay
splodge1134103splodge
splurgy1343023splurgy
spode84617703spo_de
spodes94817433spodes
spoil75818643spo_il
spoils84614533spoils
spoilt85016593spoilt
spoke114818663spo_ke
spoked134413893spoked
spoken124610003spoken
spokes124417213spokes
spoking143212223spoking_
spondee10310593spondee
spongers1137603spongers
spongier1135733spongier
sponging1238823sponging
spongins1136563spongins
sponsal946333sponsal
sponson935383sponson
sponsor934963sponsor
spoof105019013spo_of
spoofs114011813spoofs
spook115416043spo_ok
spooks124312933spooks
spool75219043spo_ol
spools85115913spools
spoon74719443spo_on
spooned103412443spooned
spooneys13314583spooneys
spoonily1335233spoonily
spoons84116013spoons
spoor75016353spo_or
spoors84014023spoors
sporal82915453sporal
spore75428593spo_re
spored94821793spored
spores84726613spores
sporing104319413sporing_
sport75935983spo_rt
sports84619183sports
spot65540683spo__t
spots74424103spo_ts
spouse84112513spouse
spout75029633spo_ut
spouts85115113spouts
sprag86418693sprag_
sprags95715823sprags
sprang95713523sprang_
sprangs104610053sprangs
spray106720063sp_ray
sprig85617743sprig_
spriggy14374213spriggy
sprigs94814773sprigs
spring94526013spring_
springe103913983springe
springs104415923springs
sprucy13356323sprucy
sprug85313893sprug_
sprugs94010173sprugs
sprung94610033sprung_
spry96819123sp__ry
spryly1435513spryly
spuing94313363spuing_
spumy124610363sp_umy
spun66221463spun__
spunk114513403spun_k
spunks12349333spunks
spurge93711323spurge
spurry11429113spurry
spy86023743sp___y
spying123913253spying_
staggy115510393staggy
stagy96618893s_tagy
stang66424683stang_
stangs75018163stangs
sting65330243sting_
stingo74212163stingo
stings76220183stings
stinky134611073stinky
stocky15369153stocky
stodge8369043stodge
stogey105811543stogey
stone55431183ston_e
stoned75923143stoned
stoner65823203stoner
stones65130033stones
stonily1049433stonily
stooge73811663stooge
storey95217613storey
stormy115510723stormy
story86723033sto_ry
stoury9529943stoury
stringy114111073stringy
strong74914883strong_
strongly1245953strongly
strongyl1243553strongyl
stung65417153stung_
suing65026363suing_
sung55832173s_ung_
sunny84917743s_unny
surgy95118523s_urgy
swang95519723swang_
swanky16447973swanky
swanny12336823swanny
swing96124843swing_
swingby16343893swingby
swinge105614383swinge
swings104714453swings
swoony12408263swoony
swoopy14487283swoopy
swung95610563swung_
syzygy2141113syzygy
tangy94519933_tangy
thong95014173thong_
thongs104611183thongs
toney86027413_toney
tong56434353_tong_
tonga65619683_tonga
tongs65928463_tongs
tony75635153_ton_y
twangy13386983twangy
upon65817583upon__
wingy126521033_wingy
wonky154011773_wonky
wrong94712323wrong_
wrongly1434553wrongly
wrongs10338933wrongs
zingy186516133_zingy

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164496.26617988.5
3Display Results4494490.1233650.4
 (SQL Overall)1786914496.52927368.8
 
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.