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

348 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
swoopy1448728(None) 
snoopy11449471snoopy
swoony12408261swoony
swoop105213431swoop_
swoops114910921swoops
droopy12458242droopy
goopy115816622_goopy
loopy105316642_loopy
scoop95617162scoop_
scoops105414362scoops
sloop76118912sloop_
sloops85513622sloops
sloppy1395302sloppy
snoop75317172snoop_
snoops84314172snoops
snooty94211512snooty
snoozy18517232snoozy
soapy106114782s_oapy
sooey84522432s_ooey
sooty84924842s_ooty
soppy125113522s_oppy
soupy106115402s_oupy
spoofy14498552spoofy
spooky15418092spooky
spoony114111792spoony
stoop75821542stoop_
stoops85917892stoops
swampy16437232swampy
sweepy14447452sweepy
swoon85014782swoo_n
swoons94511142swoons
swooped13418752swooped
swooper12389172swooper
swoosh12195212swoosh
swop95120502sw_op_
swops105913972sw_ops
woody125116882_woody
wooly114417672_wooly
woops104917522_woops
woozy204410602_woozy
aswoon947013aswoo_n
atopy106813393_atopy
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
bloop96116153bloop_
bloops106611343bloops
booby125319513_booby
boody115420403_boody
boogy114518323_boogy
boomy125421823_boomy
booty106125913_booty
boozy194917063_boozy
broody124510083broody
broomy13449953broomy
canopy1337723canopy
choosy14459103choosy
choppy18376293choppy
cooey105828223_cooey
cooky145321363_cooky
cooly105525423_cooly
coop87238653_coop_
coops96229643_coops
coopt95929853_coopt
copy116229803__copy
croupy13458733croupy
dhooly13457143dhooly
doody105517913_doody
dooly94821803_dooly
doomy116018263_doomy
doozy186813713_doozy
dopy106224153__dopy
drooly104911073drooly
droop85814823droop_
droops95110963droops
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
footy115820533_footy
gloomy12528763gloomy
gloppy1454723gloppy
goody105620393_goody
gooey95522863_gooey
goofy124915623_goofy
gooky135818033_gooky
goony95519783_goony
goop75829483_goop_
goops86620963_goops
goosy96018883_goosy
groovy13375403groovy
hoody124919723_hoody
hooey114926603_hooey
hooky155220263_hooky
hooly115022223_hooly
hoop96129983_hoop_
hoops105621073_hoops
hooty115022443_hooty
hoppy154912353_hoppy
isotopy12215123isotopy
jalopy18325863jalopy
kooky114412873_kooky
looby108115623_looby
looey84822913_looey
loony86918963_loony
loop67835013_loop_
loops75723963_loops
loppy125911663_loppy
moody115017493_moody
moony104818273_moony
moory105115793_moory
mopy115721973__mopy
myopy15457353_myopy
nooky124814813_nooky
oops65232673__oops
oozy167018133__oozy
phooey14379233phooey
poofy136213273_poofy
poop86532813_poop_
poops94422413_poops
poppy114813193_poppy
ptooey11346413ptooey
recopy1339043recopy
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
ropy96323413__ropy
roupy106112713_roupy
saloop84212583saloop_
saloops93510133saloops
sappy125413473s_appy
savory124310563savory
savoy114713883savo_y
saxony1636233saxony
scooch13228123scooch
scooped124611743scooped
scooper113812033scooper
scoot75729153scoo_t
scoots85315943scoots
scop85925523s_cop_
scope94821483s_cope
scops95820193s_cops
scroop10299783scroop_
scroops11288253scroops
seepy104717973s_eepy
sepoy10314303sepo_y
sharpy145211033sharpy
shoaly124010773shoaly
shoddy1434543shoddy
shoo75929893shoo__
shooed103916083shooed
shoofly1634353shoofly
shook124920163shoo_k
shooks134515633shooks
shool84523153shoo_l
shools94919013shools
shoon84022013shoo_n
shoos84226363shoo_s
shoot84235913shoo_t
shoots94619363shoots
shop95629843s_hop_
shoppe133110323shoppe
shops104222903s_hops
shorty124313203shorty
showy145714013s_howy
simony1137903simony
sirupy11377053sirupy
skimpy17475723skimpy
sleepy11479413sleepy
slippy1375843slippy
slobby1334803slobby
slop66533873s_lop_
slope75823563s_lope
slops75026013s_lops
sloshy12366623sloshy
slowly1237153slowly
smoggy1354283smoggy
smokey15398653smokey
smoky14388683s_moky
smooch13266803smooch
smoochy17223863smoochy
smoosh11236733smoosh
smooth11259203smooth
smoothy15205083smoothy
snappy1366103snappy
snippy1374843snippy
snobby1334403snobby
snood64616163snoo_d
snoods74312453snoods
snook95115573snoo_k
snooks104412833snooks
snool55118643snoo_l
snools65715883snools
snooped103711813snooped
snooper93511533snooper
snoopily1345553snoopily
snoot55030143snoo_t
snoots64216683snoots
snooze15439993snooze
snotty9489203snotty
snouty9419953snouty
snowy115011563s_nowy
soap65831133s_oap_
soaps75120713s_oaps
soddy104210703s_oddy
sodomy1276673sodomy
softy115414483s_ofty
soggy105413903s_oggy
sonly85718053s_only
sonny85016103s_onny
sonsy86416373s_onsy
sook84933393s_oo_k
sooks94425453s_ooks
soon46240503s_oo_n
soot45761063s_oo_t
sooth85924063s_ooth
soots55536213s_oots
sop57557863s__op_
soph97024203s__oph
sophy136611763s_ophy
sopor74016493s_opor
sops65244563s__ops
sorry84618253s_orry
soup66232913s_oup_
soups75322943s_oups
soy67851453s__o_y
spongy1236743spongy
spoof105019013spoo_f
spoofs114011813spoofs
spook115416043spoo_k
spooks124312933spooks
spool75219043spoo_l
spools85115913spools
spoon74719443spoo_n
spooney12418243spooney
spoons84116023spoons
spoor75016353spoo_r
spoors84014033spoors
sporty115112493sporty
spotty11448583spotty
spy86023743s___py
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083s_togy
stomp95616663stomp_
stomps105612833stomps
stoney96217353stoney
stony85818643s_tony
stood65517713stoo_d
stooge73811663stooge
stook95218213stoo_k
stooks105115373stooks
stool55619893stoo_l
stools65117023stools
stooped103813833stooped
stooper93813193stooper
stop66532033s_top_
stope74727243s_tope
stops74827283s_tops
stopt76528353s_topt
storey95217613storey
stormy115510733stormy
story86723033s_tory
stoup75517073stoup_
stoups85313273stoups
stoury9529943stoury
stowp105614233stowp_
stowps115710583stowps
stripy115812743stripy
strop77422243strop_
stroppy14205093stroppy
strops86220383strops
stroy87720393stro_y
stumpy13458133stumpy
swabby1634353swabby
swamp125015323swamp_
swamps135910263swamps
swamy136714403sw_amy
swanky16447973swanky
swanny12336823swanny
swap95925433sw_ap_
swaps104819203sw_aps
swarty125812383swarty
sway107128233sw__ay
sweaty123710053sweaty
sweeny12358843sweeny
sweep104715723sweep_
sweeps114110513sweeps
swept105720603sw_ept
swimmy16234353swimmy
swingy13489873swingy
swipe105217083sw_ipe
swirly12439253swirly
swishy15365843swishy
swob95218633sw_o_b
swobs104910893sw_obs
swooned11368593swooned
swooner10358673swooner
swoopers13317523swoopers
swoopier13175143swoopier
swooping14338403swooping
swopped15437673swopped
sword95214123sw_ord
swords104510803swords
swore84920823sw_ore
sworn86115313sw_orn
swot75134663sw_o_t
swots85518433sw_ots
swoun84811493sw_oun
swound10377633swound
swouns9358243swouns
syrupy14285823syrupy
sysop1037193sysop_
sysops1136013sysops
troop76417533troop_
troops85712783troops
waspy135410993_waspy
weepy134212593_weepy
whoop134211443whoop_
whoops14487863whoops
whop125520923_whop_
whops135013933_whops
wicopy1634033wicopy
wimpy155911923_wimpy
wispy137210973_wispy
womby155910093_womby
wonky154011773_wonky
woo66949803_woo__
wood85329383_woo_d
woods95723033_woods
woodsy13505923_woodsy
wooed94419873_wooed
wooer84316693_wooer
woof106532423_woo_f
woofs114918003_woofs
wool76427373_woo_l
woolly12408513_woolly
wools84421463_wools
woos76238803_woo_s
woosh113710733_woosh
wop87145133_w_op_
wops96634153_w_ops
wordy126916163_wordy
wormy137514253_wormy
worry116114333_worry
zooey173914803_zooey
zooty175415353_zooty

Search took 6 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.373479064.3
2DLD Change Limit1127163484.81323419.1
3Display Results3483480.1103163.6
 (SQL Overall)1786913485.29633740.7
 
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.