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

413 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
snooper9351153(None) 
scooper113812031scooper
snooker113910301snooker
snooped103711811snooped
snoopers10319841snoopers
snoopier10177271snoopier
snoozer16409191snoozer
stooper93813191stooper
swooper12389171swooper
blooper11358532blooper
cooper104221122_cooper
hooper114518312_hooper
looper83817112_looper
nooser65517822_nooser
scooped124611742scooped
scoopers124210192scoopers
scooter93312872scooter
shooter103013992shooter
shopper143312632shopper
sloper84615912s_loper
snapper113512072snapper
sniper84413642sn_iper
snipper113911332snipper
snooded94110362snooded
snooked123711492snooked
snookers12398652snookers
snooled84513942snooled
snoop75317172snoop__
snoops84314172snoop_s
snoopy11449472snoop_y
snooted84213282snooted
snootier8278382snootier
snooze15439992snooze_
snoozed173410132snoozed
snoozers17296942snoozers
snoozes16289782snoozes
snoozier17185192snoozier
snorer64316762sn_orer
snorter74412662snorter
snowier1038792snowier
soaper84517872s_oaper
sooner64220462s_ooner
spoofer12368722spoofer
spooler93711382spooler
stomper114111232stomper
stooker113811732stooker
stooped103813832stooped
stoopers103711302stoopers
stoper84320102s_toper
stopper113012602stopper
swooner10358672swooner
swooped13418752swooped
swoopers13317522swoopers
swoopier13175142swoopier
trooper94210362trooper
whooper15297152whooper
annoyer1095603annoyer
another10289153another
bloomer11419813bloomer
blooped12398543blooped
bloopers12397373bloopers
booger94816553_booger
booker124719193_booker
boomer104618513_boomer
boozer174815963_boozer
bopper123813833_bopper
brooder103811623brooder
chomper163810073chomper
chooser124412973chooser
chopper163611893chopper
cooer74831013_coo_er
cooker124722453_cooker
cooler84824713_cooler
cooped114821603_cooped
coopers114019483_coopers
coopery143910273_coopery
cooter85128613_cooter
coper95336093__coper
copper124321893_copper
crooker134111093crooker
crooner93714043crooner
cropper133312963cropper
doozer163910463_doozer
doper86128393__doper
dorper94314573_dorper
drooped11368433drooped
droopier1145573droopier
dropper12329873dropper
eloper85414153_eloper
encoder1038633encoder
endower1138483endower
enjoyer1744383enjoyer
enrober9218623enrober
flooder11258463flooder
floorer10248073floorer
flopper14328473flopper
footer94320773_footer
goober93911743_goober
gooier73516213_gooier
goopier103910573_goopier
groomer10399873groomer
groover11358543groover
groper94517253_groper
grouper104210093grouper
honorer1039673honorer
hoofer124014953_hoofer
hooker134820173_hooker
hooped125518183_hooped
hoopers123616483_hoopers
hooter94123933_hooter
hoover124314433_hoover
hoper105829143__hoper
hopper134218483_hopper
incomer1169943incomer
intoner7811673intoner
invoker1435363invoker
ionomer939833ionomer
knapper15387153knapper
knocker12296393knocker
knoller11285913knoller
knopped16355453knopped
knotter11317643knotter
knower1337083kn_ower
looker104816953_looker
looped95217173_looped
loopers93914033_loopers
loopier93711193_loopier
looser65219943_looser
looter64222323_looter
loper75129233__loper
lopper103717203_lopper
monomer11311893monomer
mooner85317833_mooner
mooter83921093_mooter
moper94925923__moper
mopper126215003_mopper
napper103718283_napper
nipper103715713_nipper
nobler83713453_nobler
nodder84811943_nodder
nonpar8168993_nonpar
noose55624063_noose_
noosed75018013_noosed
noosers74913923_noosers
nooses65623643_nooses
nope65934193_n_ope_
nosher94616363_nosher
nosier63716323_nosier
noter55025643_n_oter
nother93815963_nother
onlooker1243473onlooker
pooler83819843_pooler
pooped113915943_pooped
poorer82613993_poorer
popper93615963_popper
proofer12149103proofer
proper104319953_proper
prosper114012193prosper
romper104213683_romper
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
roper75431913__roper
sapper103822353s_apper
savorer1057883savorer
scalper113912923scalper
scamper134613163scamper
scarper114814823scarper
scauper11379453scauper
schooner1336623schooner
scoffer15317023scoffer
scolder103210343scolder
scoop95617163scoop__
scoops105414363scoop_s
scooted103612283scooted
scooters103511033scooters
scope94821483s_cope_
scoped115116653s_coped
scopes104719593s_copes
scorer84818263s_corer
scorner9259763scorner
scoter83815483s_coter
scourer93910433scourer
scouter93313323scouter
scowder13286873scowder
scowler12248193scowler
scraper114513423scraper
scrooped1356403scrooped
scupper1367423scupper
shaper114119933s_haper
sharper124312703sharper
shipper143514043shipper
shnorrer1143523shnorrer
shoaler102610083shoaler
shocker163411433shocker
shoer84722163s_ho_er
shooed103916083shoo_ed
shooled115212663shooled
shooters112811583shooters
shoppe133110323shoppe_
shopped153512213shopped
shoppers153010763shoppers
shoppes143411393shoppes
shorter103515503shorter
shouter103213083shouter
shover124515993s_hover
shower124315113s_hower
showier1339103showier
simper103616293s_imper
sipper103920993s_ipper
skipper15339573skipper
slapper113512463slapper
sleeper93211563sleeper
slipper113712983slipper
slobber11388903slobber
slogger94310483slogger
sloop76118913sloop__
sloops85513623sloop_s
slope75823563s_lope_
sloped94216853s_loped
slopers94213093s_lopers
slopes84820453s_lopes
slopped123511443slopped
sloppier1255703sloppier
slotter73314453slotter
slower94016153s_lower
smoker124311693s_moker
smokier1356703smokier
smolder10327753smolder
smoocher15205503smoocher
smoother13196673smoother
smother123510213smother
snacker133112603snacker
snakier112810003snakier
snapped124611203snapped
snappers123510173snappers
snappier1266213snappier
snarer64620843sn_arer
snarler73610633snarler
sneaker112910453sneaker
sneaped10338813sneaped
sneer54919953sn__eer
sneerer73512313sneerer
sneezer16237963sneezer
sneller73512843sneller
snicker133012673snicker
snider74413913sn_ider
sniffer13318903sniffer
snifter10349623snifter
snigger9328373snigger
snipe75320573sn_ipe_
sniped94913483sn_iped
snipers93311773sn_ipers
snipes83917393sn_ipes
snipped123510043snipped
snippers12299723snippers
snippet113310433snippet
snippier1255793snippier
snobbery15514293snobbery
snobbier1234633snobbier
snogged10417973snogged
snood64616163snoo__d
snoods74312453snoo_ds
snook95115573snoo__k
snookered1443263snookered
snooks104412833snoo_ks
snool55118643snoo__l
snools65715883snoo_ls
snoopiest11157063snoopiest
snoopily1345553snoopily
snooping113811323snooping
snoot55030143snoo__t
snoots64216683snoo_ts
snooty94211513snoo_ty
snoozle16305913snoozle
snoozled18344493snoozled
snoozles17335563snoozles
snoozy18517233snoo_zy
snore55424953sn_ore_
snored74819543sn_ored
snorers74313803sn_orers
snores64324323sn_ores
snorkel1135423snorkel
snorted83813493snorted
snorters83410583snorters
snottier8217383snottier
snouted84311343snouted
snoutier8206973snoutier
snowed104613623sn_owed
snowmen12246153snowmen
snubber11277733snubber
snuffer13318853snuffer
snugger9318313snugger
soaker105717533s_oaker
soaped95817973s_oaped
soapers93715923s_oapers
soapier93411713s_oapier
soarer64522243s_oarer
sobber104016593s_obber
sober74822413s__ober
soccer1038543s_occer
soever94412093s_oever
softer94015313s_ofter
solder73921343s_older
solver94016703s_olver
somber103714003s_omber
sonder73623523s_onder
sonsier7711743sonsier
sooey84522433s_oo_ey
sooners73916643s_ooners
sooted73922593s_ooted
soother104215043soother
sootier73916613sootier
sopor74016493s__opor
sopped114819903s_opped
soppier112711583s_oppier
sorer56236593s__orer
sorner64720393s_orner
sorter64425093s_orter
souped95017673s_ouped
soupier93111753s_oupier
sourer63620213s_ourer
souter64225923s_outer
sower85229313s__ower
spoiler93310683spoiler
sponger1038523sponger
spoofed13399103spoofed
spoofers13307323spoofers
spoofery16354313spoofery
spooked144510473spooked
spookery17264143spookery
spookier14175493spookier
spooled104613523spooled
spoolers10349363spoolers
spooned103412443spooned
spooney12418243spooney
spoonier10167653spoonier
spoor75016353spoo__r
spoored104411293spoored
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
stamper113714403stamper
steeper93812773steeper
stepper113010853stepper
stocker133713083stocker
stoker104417623s_toker
stomped124110533stomped
stompers123610043stompers
stoner65823203s_toner
stonier72013793stonier
stooge73811663stooge_
stooged94310733stooged
stooges83611483stooges
stooked124312303stooked
stookers12449793stookers
stooled84313893stooled
stoop75821543stoop__
stoops85917893stoop_s
stope74727243s_tope_
stoped94721013s_toped
stopers94217373s_topers
stopes84525893s_topes
stopover1344063stopover
stopped124512203stopped
stoppers123910593stoppers
storer64721673s_torer
stouter74012053stouter
stover94115643s_tover
striper94514793striper
stroker114113523stroker
stropper1247763stropper
stroyer103510783stroyer
stumper113610093stumper
super74924483s__uper
supper104115433s_upper
swamper14349313swamper
swapper14359703swapper
sweeper12329373sweeper
swobber14336543swobber
swooned11368593swooned
swooners11336863swooners
swoonier11185133swoonier
swoop105213433swoop__
swoops114910923swoop_s
swoopy14487283swoop_y
swopped15437673swopped
swotter10399473swotter
syncope1445383syncope_
syncopes1545763syncopes
tooler63818613_tooler
tooter64420803_tooter
toper75231023__toper
topper103817603_topper
trooped104010723trooped
troopers10289443troopers
trouper93811433trouper
uncover1239003uncover
undoer73113043undo_er
unhoped13249353unhoped
unopen838913un_open
unriper9188283unriper
unroped102812103unroped
unsober967643unsober
whooped16326933whooped
whoopee15287513whoopee
whoopers16286263whoopers
whopper17328503whopper
wooer84316693_woo_er
woofer124411363_woofer
wooler93615873_wooler
zooier153411233_zooier

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274136.09321996.9
3Display Results4134130.1402950.0
 (SQL Overall)1786914136.63926915.3
 
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.