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

139 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
whoopee1528751(None) 
whooped16326931whooped
whoopees16294821whoopees
whooper15297151whooper
whoopie15295911whoopie
hooped125518182_hooped
hooper114518312_hooper
hoopoe11911232_hoopoe
whomped18345472whomped
whoofed17374512whoofed
whoop134211442whoop__
whoopers16286262whoopers
whoopies16267362whoopies
whoopla1542632whoopla
whoops14487862whoop_s
whopped18358002whopped
whopper17328502whopper
blooped12398543blooped
blooper11358533blooper
bootee84323023_bootee
chomped17329773chomped
chomper163810073chomper
choose115116143choo_se
chooser124412963chooser
chooses125717413chooses
choosey15459233choosey
chopped174511003chopped
chopper163611893chopper
cooee74531023_coo_ee
cooped114821603_cooped
cooper104221123_cooper
dhootie1136453dhootie
doolee73018953_doolee
drooped11368433drooped
epopee10312503_epopee
holpen11299413_holpen
honoree10412113_honoree
hooded114616743_hooded
hoodie105116133_hoodie
hooey114926603_hoo_ey
hoofed134614893_hoofed
hoofer124014953_hoofer
hooked145320553_hooked
hooker134820173_hooker
hookey164713933_hookey
hoolie93217773_hoolie
hoop96129983_hoop__
hoopers123616483_hoopers
hoopla1147633_hoopla
hoopoes121212483_hoopoes
hoopoo1198753_hoopoo
hoops105621073_hoop_s
hooted104422653_hooted
hooter94123923_hooter
hooved134713123_hooved
hoover124314433_hoover
hooves124815483_hooves
hope96639673_h_op_e
hoped115628183_h_oped
hoper105829143_h_oper
hopes105835643_h_opes
hopped144318113_hopped
hopper134218483_hopper
hopple132910483_hopple
looped95217173_looped
looper83817113_looper
phooey14379233phoo_ey
pooped113915943_pooped
scooped124611743scooped
scooper113812033scooper
shooed103916073shoo_ed
shooled115212653shooled
shooter103013973shooter
shoppe133110313sh_oppe
shopped153512203shopped
shopper143312623shopper
shoppes143411383shoppes
snooped103711813snooped
snooper93511533snooper
stooped103813833stooped
stooper93813183stooper
swooped13418753swooped
swooper12389173swooper
thorpe113610093thorp_e
thorpes125010353thorpes
topee76029953__topee
toupee8316133_toupee
trooped104010723trooped
trooper94210353trooper
whangee14268613whangee
whapped18367573whapped
whapper17348273whapper
whee105429593wh___ee
wheeped16387503wheeped
wheeple1534853wheeple
whelped16355633whelped
whimper17297723whimper
whipped18379333whipped
whipper173611383whipper
whippet17328843whippet
whisper15298013whisper
whoever1634103whoever
whole114418093wh_o_le
wholes124616773wh_oles
whomp155011323whomp__
whomps16457603whomp_s
whoof144612693whoo__f
whoofs15457243whoo_fs
whooping17286633whooping
whooplas1644003whooplas
whoosh15244353whoo_sh
whooshed1833453whooshed
whooshes1734413whooshes
whoosis1335443whoosis
whop125520923wh_op__
whoppers18297533whoppers
whops135013933wh_op_s
whore116018043wh_o_re
whored135512123wh_ored
whores125617103wh_ores
whorled14366903whorled
whortle13335943whortle
whose114914533wh_o_se
whumped18335633whumped
whupped18365413whupped
wooded114213683w_ooded
wooden103610303w_ooden
woodie103513613w_oodie
wooed94419873w_oo_ed
wooer84316693w_oo_er
woofed134511203w_oofed
woofer124411363w_oofer
wooled103715503w_ooled
woolen93111373w_oolen
wooler93615873w_ooler
woolie93514483w_oolie
woops104917523w_oop_s
woopsed1344733w_oopsed
woopses1237883w_oopses

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.1431249587.4
2DLD Change Limit1340271396.42020876.5
3Display Results1391390.0463021.7
 (SQL Overall)1786911396.60927037.5
 
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.