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 “spookily” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
spookily174417(None) 
spoonily1335231spoonily
pockily1846232_pockily
pokily15309062_p_okily
smokily1635372s_mokily
snoopily1345552snoopily
snootily1136252snootily
sootily101810522s_ootily
sparkily1735022sparkily
spikily1635872sp_ikily
spongily1444902spongily
spookery17264142spookery
spookier14175492spookier
spooking15269802spooking
spookish1744642spookish
spooky15418092spook__y
sportily1337732sportily
spottily1335152spottily
spunkily1733772spunkily
stockily1735442stockily
bloodily1445183bloodily
boozily2135623_boozily
broodily1445503broodily
cockily1838493_cockily
croakily1744733croakily
doomily1336133_doomily
droopily1443943droopily
gloomily1443753gloomily
goofily14105353_goofily
hokily16409093__hokily
jokily20306533__jokily
loonily1037073_loonily
loopily1236803_loopily
moodily1358203_moodily
moonily1248943_moonily
oozily18328073__oozily
pawkily1934203_pawkily
perkily1637813_perkily
peskily1635083_peskily
phonily1537103_phonily
podgily1435213_podgily
poorly1137893_poo_rly
prosily12611633_prosily
roomily1237283_roomily
savorily1445043savorily
shakily1736903s_hakily
shoddily1643573shoddily
shoofly1634353shoo_fly
showily1636223s_howily
silkily14236963s_ilkily
slinkily1534853slinkily
sloppily1544613sloppily
smirkily1753333smirkily
smoothly16203643smoothly
snakily1436913s_nakily
snarkily1534583snarkily
sneakily1544423sneakily
snobbily1544233snobbily
snooking133010583snooking
snottily1145553snottily
snowily1336883s_nowily
soapily1237963s_oapily
soggily1235953s_oggily
soothly13186923s_oothly
sorrily1039833s_orrily
sparkly16348133spark_ly
speedily1465183speedily
spicily1438653sp_icily
spiffily19153483spiffily
spoil75818653sp_o_il_
spoils84614533sp_o_ils
spoilt85016593sp_o_ilt
spoking143212223sp_oking
spoofery16354313spoofery
spoofing14228363spoofing
spoofy14498553spoo__fy
spook115416043spook___
spooked144510473spook_ed
spookiest15156393spookiest
spooks124312933spook__s
spool75219043spoo__l_
spooling113212563spooling
spools85115913spoo__ls
spoonbill13112473spoonbill
spooney12418243spoo_ney
spoonier10167653spoonier
spoonies101911753spoonies
spooning112811443spooning
spoony114111793spoo__ny
spooring113111463spooring
stalkily1534823stalkily
stickily1736083stickily
stodgily1343903stodgily
stonily1049433s_tonily
stooking132711143stooking
stormily1345243stormily
sulkily14218113s_ulkily
swankily1833833swankily
woozily2234383_woozily

Search took 8 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 Filter1786911461620.453394461.4
2DLD Change Limit146162996.73621698.6
3Display Results99990.0303300.0
 (SQL Overall)178691997.21924752.9
 
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.