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

269 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
stonily104943(None) 
loonily1037072loonily
moonily1248942moonily
phonily1537102phonily
shinily13268932shinily
showily1636222showily
smokily1635372smokily
snowily1336882snowily
sonly85718052s_on_ly
sootily101810522sootily
spongily1444902spongily
spoonily1335232spoonily
stagily1139052stagily
stingily1236792stingily
stockily1735442stockily
stodgily1343902stodgily
stolidly1243832stolidly
stonefly1443472stonefly
stoney96217352ston_ey
stonier72013792stonier
stoning83717442stoning
stonish10410652stonish
stony85818642ston__y
stormily1345242stormily
stoutly1035832stoutly
strongly1245952strongly
sunnily1037832sunnily
tinily94014432_tinily
astonied978983astonied
astonies8815103astonies
astonish1148463astonish
astony9510523aston__y
atonal6514023atonal_
atonally1148633atonally
atonia63816513atoni_a
atonias73315993atonias
atonic83420473atoni_c
atonics93613713atonics
atonies75320953atonies
atoning83514873atoning
atoningly1365373atoningly
atony87218853aton__y
bodily12310993_bodily
bonnily1236873bonnily
boozily2135623boozily
boxily1877843_boxily
cannily1239263cannily
cornily12410853cornily
cosily113613853_cosily
cozily20349703_cozily
doily95321033_do_ily
doomily1336133doomily
dopily123510463_dopily
dottily1147283dottily
dozily19329103_dozily
etoile6312263eto_ile
fondly13299043_fondly
foxily1947253_foxily
funnily1336373funnily
goofily14105353goofily
gorily10612503_gorily
hokily16409093_hokily
holily123612953_holily
homily144712333_homily
hornily1338283hornily
itchily1574493itchily
jokily20306533_jokily
logily1039833_logily
lonely92912473_lonely
longly10279603_longly
loopily1236803loopily
moodily1358203moodily
noily86120993_no_ily
nonoily1049543_nonoily
nosily93712683_nosily
oily77932253__o_ily
only75319723__on_ly
oozily18328073_oozily
pokily15309063_pokily
pronely12310253pronely
prosily12611633prosily
punily11311773_punily
rainily10310433rainily
roily86121113_ro_ily
roomily1237283roomily
ropily113312443_ropily
rosily93914713_rosily
saintly1039343saintly
saltily10310543saltily
sanely93114613s_anely
sanity9316203s_anity
saponify1644183saponify
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savorily1445043savorily
savvily1634323savvily
scantily1337583scantily
scantly12419553scantly
scarily12311703scarily
scorify1535203scorify
secondly1443663secondly
seedily1178583seedily
senile63420213s_enile
sexily1638853s_exily
shadily1437723shadily
shakily1736903shakily
shily115222013s__hily
shingly143210813shingly
shoaly124010773sho_aly
shoddily1643573shoddily
shoofly1634353shoofly
shortly13387573shortly
signify1444853signify
silkily14236963silkily
sillily10209783sillily
singly104015853s_ingly
slangily1235383slangily
slantly10399323slantly
slily85820033s__lily
slimily1247713slimily
slinkily1534853slinkily
sloppily1544613sloppily
slowly1237153slo_wly
snakily1436913snakily
snobbily1544233snobbily
snoopily1345553snoopily
snootily1136253snootily
snottily1145553snottily
soapily1237963soapily
softly12457763s_oftly
soggily1235953soggily
soil46138833s_o_il_
soils55327983s_o_ils
solely93714213s_olely
solidly1137353s_olidly
sonic75225293s_oni_c
sonics84315633s_onics
sonny85016103s_on_ny
sonsy86416373s_on_sy
soothly13186923soothly
sorely94618013s_orely
sorrily1039833sorrily
soundly1136683soundly
sourly93612213s_ourly
spangly1336473spangly
spicily1438653spicily
spikily1635873spikily
spindly13257383spindly
spoil75818653spo_il_
spoils84614533spo_ils
spoilt85016593spo_ilt
spongy1236743spon_gy
spookily1744173spookily
sportily1337733sportily
spottily1335153spottily
spunkily1733773spunkily
stabile9312063stabile
stably113314123st_ably
staidly1136683staidly
stalely1039213stalely
stalkily1534823stalkily
stanchly1644443stanchly
standby1334423standby
stanine73417073stanine
staning83922243staning
stanol6310723stanol_
stanols739733stanols
starkly14277033starkly
stately10310223stately
steadily1236213steadily
steamily1335803steamily
steely93612573st_eely
steeply1236293steeply
stenchy15256213stenchy
stencil946893stencil_
stencils1046403stencils
stenoky1444253stenoky
sterile7316603sterile
sternly1037853sternly
stickily1736083stickily
stiffly16235173stiffly
stile54931573st__ile
still54922083st__ill
stilly93714093st_illy
stilt54831983st__ilt
stimy105114743st__imy
stingy105213203stin_gy
stinky134611073stin_ky
stoai55417873stoai__
stocky15369153sto_cky
stodgy11415733sto_dgy
stogey105811543sto_gey
stogie7311323stogi_e
stogies8413693stogies
stogy95414083sto__gy
stoic7317253sto_i_c
stoics8311113sto_ics
stoking123615593stoking
stole54928813sto__le
stolid74213183stoli_d
stomal85213313stomal_
stonable1039843stonable
stone55431183ston__e
stoned75923143ston_ed
stoner65823203ston_er
stoners74817953stoners
stones65130033ston_es
stoniest8413543stoniest
stool55619893sto_ol_
stoolie739723stoolie
stools65117023sto_ols
stoping103716623stoping
stopple1156583stopple
storey95217613sto_rey
storied8515163storied
stories7324273stories
storing83921123storing
stormy115510733sto_rmy
story86723033sto__ry
stotin63215063stoti_n
stotins73213873stotins
stoury9529943sto_ury
stowing113315133stowing
straitly1136563straitly
stringily1346003stringily
stringy114111073stringy
stripy115812743st_ripy
strobil936963strobil_
strobila1044933strobila
strobile1047033strobile
strobili1044933strobili
strobils1046563strobils
strongyl1243553strongyl
stubbily1564243stubbily
stubbly1444473stubbly
studly10397693st_udly
stuffily17124163stuffily
stupidly1442633stupidly
sturdily1245083sturdily
sulkily14218113sulkily
surlily10310003surlily
swankily1833833swankily
tangly104413933_tangly
tawnily1335443tawnily
thinly1238673_thinly
thornily1444163thornily
tidily102811393_tidily
tingly103815983_tingly
tinkly134811153_tinkly
tinnily1047363tinnily
toil46536283_to_il_
toile54626493_to_ile
toils54527493_to_ils
tonal53724303_tonal_
tonally10311373_tonally
toney86027413_ton_ey
tonic74727653_toni_c
tonics83617863_tonics
tonier65520713_tonier
toning74025793_toning
tonish93415903_tonish
tonishly1445523_tonishly
tonsil6311873_tonsil_
tonsils7310183_tonsils
tony75635153_ton__y
woozily2234383woozily
wrongly1434553wrongly
zanily18310183_zanily

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272696.53320515.4
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.01625469.1
 
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.