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

104 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
spoonily133523(None) 
spookily1744171spookily
loonily1037072_loonily
moonily1248942_moonily
phonily1537102_phonily
snoopily1345552snoopily
snootily1136252snootily
sootily101810522s_ootily
spongily1444902spongily
spoonbill13112472spoonbill
spooney12418242spoon_ey
spoonier10167652spoonier
spoonies101911752spoonies
spooning112811442spooning
spoony114111792spoon__y
sportily1337732sportily
spottily1335152spottily
stonily1049432s_tonily
bloodily1445183bloodily
bonnily1236873_bonnily
boozily2135623_boozily
broodily1445503broodily
cornily12410853_cornily
doomily1336133_doomily
droopily1443943droopily
gloomily1443753gloomily
goofily14105353_goofily
hornily1338283_hornily
loopily1236803_loopily
moodily1358203_moodily
nonoily1049543_nonoily
oozily18328073__oozily
opsonify1642273opsonify
pockily1846233_pockily
podgily1435213_podgily
pokily15309063_p_okily
poorly1137893_poo_rly
pronely12310253_pronely
prosily12611633_prosily
punily11311773_p_unily
roomily1237283_roomily
saponify1644183saponify
savorily1445043savorily
secondly1443663secondly
shinily13268933s_hinily
shoddily1643573shoddily
shoofly1634353shoo_fly
showily1636223s_howily
sloppily1544613sloppily
smokily1635373s_mokily
smoothly16203643smoothly
snobbily1544233snobbily
snottily1145553snottily
snowily1336883s_nowily
soapily1237963s_oapily
soggily1235953s_oggily
sonly85718053s__on_ly
soothly13186923s_oothly
sorrily1039833s_orrily
soundly1136683s_oundly
spangly1336473sp_angly
sparkily1735023sparkily
speedily1465183speedily
spicily1438653sp_icily
spiffily19153483spiffily
spikily1635873sp_ikily
spindly13257383sp_indly
spoil75818653sp_o_il_
spoils84614533sp_o_ils
spoilt85016593sp_o_ilt
spongy1236743sp_on_gy
spoofery16354313spoofery
spoofing14228363spoofing
spoofy14498553spoo__fy
spookery17264143spookery
spookier14175493spookier
spooking15269803spooking
spookish1744643spookish
spooky15418093spoo__ky
spool75219043spoo__l_
spooling113212563spooling
spools85115913spoo__ls
spoon74719443spoon___
spoonbills1482253spoonbills
spooned103412443spoon_ed
spooneys13314583spooneys
spoonful1343753spoonful
spoonfuls1452863spoonfuls
spooniest11178133spooniest
spoons84116023spoon__s
spooring113111463spooring
springily1545583springily
spunkily1733773spunkily
stockily1735443stockily
stodgily1343903stodgily
stormily1345243stormily
strongly1245953strongly
sunnily1037833s_unnily
swoonier11185133swoonier
swooning12278203swooning
swooningly1742463swooningly
swoony12408263swoon__y
thornily1444163thornily
woozily2234383_woozily

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621046.42322756.0
3Display Results1041040.0303466.7
 (SQL Overall)1786911046.85926052.0
 
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.