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

330 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
whooper1529715(None) 
hooper114518311_hooper
whooped16326931whooped
whoopee15287511whoopee
whoopers16286261whoopers
whopper17328501whopper
blooper11358532blooper
chomper163810072chomper
chooser124412962chooser
chopper163611892chopper
cooper104221122_cooper
hoofer124014952_hoofer
hooker134820172_hooker
hooped125518182_hooped
hoopers123616482_hoopers
hooter94123922_hooter
hoover124314432_hoover
hoper105829142_h_oper
hopper134218482_hopper
looper83817112_looper
scooper113812032scooper
shooter103013972shooter
shopper143312622shopper
snooper93511532snooper
stooper93813182stooper
swooper12389172swooper
trooper94210352trooper
whapper17348272whapper
whimper17297722whimper
whipper173611382whipper
whisper15298012whisper
whoever1634102whoever
whomped18345472whomped
whoofed17374512whoofed
whoop134211442whoop__
whoopees16294822whoopees
whoopie15295912whoopie
whoopies16267362whoopies
whoopla1542632whoopla
whoops14487862whoop_s
whopped18358002whopped
whoppers18297532whoppers
wooer84316692w_oo_er
woofer124411362w_oofer
wooler93615872w_ooler
bloomer11419813bloomer
blooped12398543blooped
bloopers12397373bloopers
booger94816553_booger
booker124719193_booker
boomer104618513_boomer
boozer174815963_boozer
bopper123813833_bopper
brooder103811623brooder
champer163813403champer
cheaper144010583cheaper
cheeper143610743cheeper
chipper163912583chipper
chirper14359963chirper
choicer14197893choicer
choker154314373ch_oker
chokier1638043chokier
choler113717153ch_oler
chomped17329773chomped
chompers17369573chompers
choose115116143choose_
choosers134810863choosers
chooses125717413chooses
choosey15459233choosey
choosier1337163choosier
chopped174511003chopped
choppers174110453choppers
choppier17286643choppier
chouser125212943chouser
chowder16387803chowder
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
dorper94314563_dorper
drooped11368433drooped
droopier1145573droopier
dropper12329873dropper
eloper85414153_eloper
flooder11258463flooder
floorer10248073floorer
flopper14328473flopper
footer94320763_footer
goober93911733_goober
gooier73516213_gooier
goopier103910573_goopier
groomer10399873groomer
groover11358543groover
groper94517253_groper
grouper104210093grouper
hamper134518653_hamper
harper115018403_harper
heaper114119523_heaper
helper114313093_helper
hepper133412663_hepper
hipper133818023_hipper
hoaxer16348563_hoaxer
hobber134114633_hobber
hocker155118563_hocker
hoer76533983_h_o_er
hogger114615083_hogger
hokier134214033_hokier
holder104619653_holder
holier94921623_holier
holler93520613_holler
holpen11299413_holpen
homer105828453_h_omer
homier116416993_homier
honer85332093_h_oner
honker134117463_honker
honorer1039673_honorer
hooded114616743_hooded
hoodier113812973_hoodier
hooey114926603_hoo_ey
hoofed134614893_hoofed
hoofers134513323_hoofers
hooked145320553_hooked
hookers144916513_hookers
hookey164713933_hookey
hookier143811673_hookier
hoop96129983_hoop__
hoopla1147633_hoopla
hoopoe11911233_hoopoe
hoopoes121212483_hoopoes
hoopoo1198753_hoopoo
hoops105621073_hoop_s
hoopster1335543_hoopster
hooted104422653_hooted
hooters104520463_hooters
hootier104915343_hootier
hooved134713123_hooved
hoovers134312703_hoovers
hooves124815483_hooves
hope96639673_h_ope_
hoped115628183_h_oped
hopers114222973_h_opers
hopes105835643_h_opes
hopped144318113_hopped
hoppers143115143_hoppers
hoppier143110703_hoppier
hoser811529763_h_oser
hosier94219613_hosier
hotter94720073_hotter
houser95322283_houser
hover115524133_h_over
howler123514313_howler
humper134115883_humper
hyper135213903_h_yper
looker104816953_looker
looped95217173_looped
loopers93914033_loopers
loopier93711193_loopier
looser65219943_looser
looter64222323_looter
loper75129233__loper
lopper103717203_lopper
mooner85317833_mooner
mooter83921093_mooter
moper94925923__moper
mopper126215003_mopper
nooser65517823_nooser
phonier122710633phonier
phooey14379233phoo_ey
pooler83819843_pooler
pooped113915943_pooped
poorer82613993_poorer
popper93615963_popper
proofer12149103proofer
proper104319953_proper
prosper114012183prosper
romper104213683_romper
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
roper75431913__roper
schooner1336623schooner
scooped124611743scooped
scoopers124210193scoopers
scooter93312863scooter
shaper114119933sh_aper
sharper124312703sharper
shipper143514033shipper
shoaler102610073shoaler
shocker163411423shocker
shoer84722153sh_o_er
shooed103916073shoo_ed
shooled115212653shooled
shooters112811553shooters
shoppe133110313shoppe_
shopped153512203shopped
shoppers153010753shoppers
shoppes143411383shoppes
shorter103515493shorter
shouter103213073shouter
shover124515983sh_over
shower124315103sh_ower
showier1339093showier
sloper84615913_sloper
snooker113910303snooker
snooped103711813snooped
snoopers10319833snoopers
snoopier10177273snoopier
snoozer16409183snoozer
soaper84517873_soaper
sooner64220463_sooner
spoofer12368723spoofer
spooler93711383spooler
stomper114111223stomper
stooker113811733stooker
stooped103813833stooped
stoopers103711293stoopers
stoper84320093_stoper
stopper113012593stopper
swooner10358673swooner
swooped13418753swooped
swoopers13317523swoopers
swoopier13175143swoopier
thorpe113610093thorpe_
thorpes125010353thorpes
thrower1386993thrower
thumper14356953thumper
tooler63818613_tooler
tooter64420803_tooter
toper75231023__toper
topper103817603_topper
trooped104010723trooped
troopers10289423troopers
trouper93811413trouper
wagoner1136083wagoner
walloper13147113walloper
warper114015583w_arper
weeper114313303w_eeper
whacker19368503whacker
whaler124611973wh_aler
whapped18367573whapped
whappers18276743whappers
wheeler13298773wheeler
wheeped16387503wheeped
wheezer22296673wheezer
whelped16355633whelped
whether16346623whether
whetter13348803whetter
whicker19359773whicker
whiffer19105323whiffer
whimpers18276613whimpers
whiner124516633wh_iner
whinger1410810903whinger
whinier134110633whinier
whipped18379333whipped
whippers18329033whippers
whippet17328843whippet
whippier18265823whippier
whirler13307603whirler
whisker17367933whisker
whispers16266993whispers
whispery19284293whispery
whiter124316393wh_iter
whither163510253whither
whitier133311063whitier
whitter139110893whitter
whizzer2134583whizzer
whole114418093wh_ole_
wholes124616773wh_oles
whomever1942963whomever
whomp155011323whomp__
whomps16457603whomp_s
whoof144612693whoo__f
whoofs15457243whoo_fs
whooping17286633whooping
whooplas1644003whooplas
whoosh15244353whoo_sh
whooshed1833453whooshed
whooshes1734413whooshes
whoosis1335443whoosis
whop125520923wh_op__
whops135013933wh_op_s
whore116018043wh_ore_
whored135512123wh_ored
whores125617103wh_ores
whorled14366903whorled
whose114914533wh_ose_
whosever1742893whosever
whosoever1841983whosoever
whumped18335633whumped
whupped18365413whupped
widower1435343widower
wiper105421293w__iper
wolfer12429983w_olfer
wolver12419713w_olver
wonder103617813w_onder
wonner95114443w_onner
wooded114213683w_ooded
wooden103610303w_ooden
woodier113912063woodier
wooed94419873w_oo_ed
wooers93712443w_oo_ers
woofed134511203w_oofed
woofers133810583w_oofers
wooled103715503w_ooled
woolen93111373w_oolen
woolers104214023w_oolers
woolier103612353woolier
woomera12135773w_oomera
woops104917523w_oop_s
woopsed1344733w_oopsed
woopses1237883w_oopses
woozier19347323woozier
worker134715113w_orker
wormer114514913w_ormer
worser95117523w_orser
wowser125110203w_owser
wrapper14368333wrapper
wronger11288823wronger
zooier153411233_zooier

Search took 10 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.373479064.3
2DLD Change Limit1340273308.76615289.4
3Display Results3303300.1262619.0
 (SQL Overall)1786913309.26519286.7
 
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.