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

214 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
showily163622(None) 
snowily1336881snowily
hokily16409092_hokily
holily123612952_holily
homily144712332_homily
phonily1537102phonily
shadily1437722shadily
shadowily1982022shadowily
shakily1736902shakily
shily115222012sh__ily
shinily13268932shinily
shoaly124010772sho_aly
shoddily1643572shoddily
shoofly1634352shoofly
shortly13387572shortly
showery16437242showery
showier1339102showier
showing143814662showing
showy145714012show__y
slowly1237152slow_ly
smokily1635372smokily
sootily101810522sootily
stonily1049432stonily
blowfly1843243blowfly
blowsily1643953blowsily
blowzily2542733blowzily
bodily12310993_bodily
boozily2135623boozily
boxily1877843_boxily
charily15310283charily
choppily2044133choppily
chowing164412773chowing
cosily113613853_cosily
cozily20349703_cozily
dewily1338343_dewily
dhooly13457143dho_oly
doily95321033_do_ily
doomily1336133doomily
dopily123510463_dopily
dowdily1534953_dowdily
dozily19329103_dozily
drowsily1583723drowsily
foxily1947253_foxily
frowzily2642673frowzily
ghostly14355103ghostly
glowfly1742673glowfly
goofily14105353goofily
gorily10612503_gorily
growly13499173grow_ly
hazily2179063_hazily
hoarily1338973_hoarily
holly114824433_ho_lly
holy106333433_ho__ly
homely145313173_homely
hominy144511483_hominy
hooly115022223_ho_oly
hornily1338283_hornily
horsily1338843_horsily
hostly124210863_hostly
hotly115815483_ho_tly
hourly12369623_hourly
howdy155711413_how_dy
howl107625693_how_l_
howls116219223_how_ls
jokily20306533_jokily
jowly186410903_jow_ly
logily1039833_logily
loonily1037073loonily
loopily1236803loopily
lowlily1335353_lowlily
lowly114113333_low_ly
moodily1358203moodily
moonily1248943moonily
noily86120993_no_ily
nosily93712683_nosily
oily77932253__o_ily
oozily18328073_oozily
pokily15309063_pokily
prosily12611633prosily
roily86121113_ro_ily
roomily1237283roomily
ropily113312443_ropily
rosily93914713_rosily
rowdily1436083_rowdily
saltily10310543saltily
sappily1437163sappily
sassily1038723sassily
saucily1237913saucily
savorily1445043savorily
savvily1634323savvily
sawfly1535133s_awfly
scarily12311703scarily
scorify1535203scorify
scowing133812093scowing
scowl1012012973scow_l_
scowls11549593scow_ls
seedily1178583seedily
sexily1638853s_exily
shabbily1873903shabbily
shadfly1733783shadfly
shaggily1643773shaggily
shaly114322863sh__aly
shapely1536893shapely
sharply15406833sharply
shawing143514883shawing
shawl116217573shaw_l_
shawls125411973shaw_ls
sheerly13337703sheerly
sheila969843sh_eila
shelly124414473sh_elly
shewing143812193shewing
shiftily1744553shiftily
shill85325333sh__ill
shingly143210813shingly
shiny115122143sh__iny
shoal83920273sho_al_
shoals94215793sho_als
shoddy1434543sho_ddy
shoebill1344213shoebill
shoeing113211883shoeing
shogi95014013shogi__
shogis103810943shogi_s
shoji15419963shoji__
shojis16348493shoji_s
shooing112112913shooing
shool84523153sho_ol_
shools94919013sho_ols
shopboy1743803shopboy
shoring112820073shoring
shorl84720253sho_rl_
shorls94516203sho_rls
shorty124313203sho_rty
should1038033sho_uld
shovel124611323shovel_
shovels13378393shovels
shoving142910643shoving
show106229193show___
showable1636583showable
showbiz2453223showbiz
showbizzy285783showbizzy
showed135016973show_ed
shower124315113show_er
showers134612683showers
showgirl1542083showgirl
showgirls1641763showgirls
showiest1438783showiest
showings15246883showings
showman15257293showman
showmanly2041903showmanly
showmen15227173showmen
shown115216483show__n
showoff1943893showoff
showring1548323showring
shows115324583show__s
showtime1643773showtime
shrewdly1842543shrewdly
shrill94712303sh_rill
shrilly13318563shrilly
shyly144811573sh__yly
silkily14236963silkily
sillily10209783sillily
slily85820033s__lily
slimily1247713slimily
sloppily1544613sloppily
slowing112814743slowing
slowish1337633slowish
snakily1436913snakily
snobbily1544233snobbily
snoopily1345553snoopily
snootily1136253snootily
snottily1145553snottily
snowier1038793snowier
snowing113913453snowing
snowy115011563snow__y
soapily1237963soapily
softly12457763s_oftly
soggily1235953soggily
soil46138833s_o_il_
soils55327983s_o_ils
solely93714213s_olely
solidly1137353s_olidly
sonly85718053s_o_nly
soothly13186923soothly
sorely94618013s_orely
sorrily1039833sorrily
sourly93612213s_ourly
sowing104222913s_owing
spicily1438653spicily
spikily1635873spikily
spoil75818653spo_il_
spoils84614533spo_ils
spoilt85016593spo_ilt
spongily1444903spongily
spookily1744173spookily
spoonily1335233spoonily
sportily1337733sportily
spottily1335153spottily
stagily1139053stagily
stockily1735443stockily
stodgily1343903stodgily
stolidly1243833stolidly
stormily1345243stormily
stoutly1035833stoutly
stowing113315133stowing
sulkily14218113sulkily
sunnily1037833sunnily
surlily10310003surlily
swill83417373s__will
swirly12439253s__wirly
thornily1444163thornily
unholily1444133unholily
wholly15366573who_lly
wily106428813___wily
woozily2234383woozily

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.406440125.6
2DLD Change Limit1340272146.48320673.6
3Display Results2142140.0762815.8
 (SQL Overall)1786912146.96525655.6
 
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.