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

283 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
soapily123796(None) 
dopily123510462do_pily
foamily1546542foamily
hoarily1338972hoarily
loopily1236802loopily
ropily113312442ro_pily
roupily1246652roupily
sappily1437162sappily
scarily12311702scarily
shadily1437722shadily
shakily1736902shakily
shapely1536892shapely
sloppily1544612sloppily
snakily1436912snakily
snappily1544322snappily
snoopily1345552snoopily
soapier93411712soapier
soaping103616222soaping
soapy106114782soap__y
soggily1235952soggily
sootily101810522sootily
sorrily1039832sorrily
stagily1139052stagily
apply125111393__apply
aptly105111813__aptly
beadily1378843beadily
beamily1477393beamily
bodily12310993bo_dily
bonnily1236873bonnily
boozily2135623boozily
bossily1237563bossily
boxily1877843bo_xily
bumpily1665653bumpily
cagily12411563_cagily
campily1638273campily
charily15310283charily
choppily2044133choppily
coalify1536683coalify
coaly105521593coa__ly
cockily1838493cockily
compile13312443compile
comply152810383comp_ly
cornily12410853cornily
cosily113613853co_sily
cozily20349703co_zily
crazily2136923crazily
croakily1744733croakily
croupily1544743croupily
daily95922333_da_ily
doily95321033do__ily
doomily1336133doomily
dottily1147283dottily
dowdily1534953dowdily
dozily19329103do_zily
droopily1443943droopily
dumpily1566233dumpily
easily9313023_easily
family143311703_family
flakily1736293flakily
floppily1843773floppily
foggily1535053foggily
foxily1947253fo_xily
gaily95020973_ga_ily
gamily123712183_gamily
glazily2035383glazily
godlily1235343godlily
goofily14105353goofily
gorily10612503go_rily
goutily1137933goutily
haply135915063_hap_ly
happily1745763happily
hazily2179063_hazily
headily1478623headily
heavily1665903heavily
hokily16409093ho_kily
holily123612953ho_lily
homily144712333ho_mily
hornily1338283hornily
horsily1338843horsily
inaptly1244413inaptly
jokily20306533jo_kily
jollily1745773jollily
joltily1746323joltily
jumpily2174983jumpily
lacily11612763_lacily
lazily1859713_lazily
leakily1436473leakily
loathly1334713loathly
loftily1336353loftily
logily1039833lo_gily
loonily1037073loonily
lousily1038333lousily
lowlily1335353lowlily
lumpily1476563lumpily
mazily20610393_mazily
meatily12311093meatily
moodily1358203moodily
moonily1248943moonily
mousily1239393mousily
nippily1444713nippily
nobbily1436693nobbily
noily86120993no__ily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683no_sily
oilily93111723_oilily
oily77932253_o__ily
oozily18328073_oozily
peppily1335123peppily
pily96132733___pily
pockily1846233pockily
podgily1435213podgily
pokily15309063po_kily
pulpily1436103pulpily
quakily2336693quakily
racily11715173_racily
rapidly1336523_rapidly
raptly11338913_raptly
readily11711403readily
reapply1434323reapply
roily86121113ro__ily
roomily1237283roomily
rosily93914713ro_sily
rowdily1436083rowdily
sadly94519123s_a_dly
safely12249393s_afely
sagely102811383s_agely
sail45447163s_a_il_
sails55738103s_a_ils
salify12311373s_alify
sally85129713s_a_lly
saltily10310543saltily
sanely93114613s_anely
sanity9316203s_anity
sapid84720933s_api_d
sappy125413473s_ap_py
sassily1038723sassily
satiny93817983s_atiny
saucily1237913saucily
savvily1634323savvily
sawfly1535133s_awfly
scabbily1763943scabbily
scaly104718723sca__ly
scantily1337583scantily
scantly12419553scantly
scaping123715693scaping
scapula1136343scapula
scarify1537443scarify
scrappily1842673scrappily
seedily1178583seedily
sexily1638853s_exily
shabbily1873903shabbily
shadfly1733783shadfly
shaggily1643773shaggily
shaly114322863sha__ly
shaping133116183shaping
sharply15406833sharply
shily115222013s__hily
shinily13268933shinily
shoaly124010773shoa__ly
shoddily1643573shoddily
showily1636223showily
silkily14236963silkily
sillily10209783sillily
simply133010523simp_ly
skimpily1963053skimpily
slackly1635263slackly
slangily1235383slangily
slantly10399323slantly
sleazily2044103sleazily
sleepily1344823sleepily
slily85820033s__lily
slimily1247713slimily
slippily1544193slippily
smarmily1543523smarmily
smartly12497433smartly
smokily1635373smokily
snail57020203sna_il_
snails64816653sna_ils
snappy1366103snap_py
snarkily1534583snarkily
snarly93815003sna_rly
sneakily1544423sneakily
snippily1543573snippily
snobbily1544233snobbily
snootily1136253snootily
snottily1145553snottily
snowily1336883snowily
soaking123116613soaking
soap65831133soap___
soapbox1843123soapbox
soaped95817973soap_ed
soaper84517873soap_er
soapers93715923soapers
soapiest102412843soapiest
soaplike1436903soaplike
soaps75120713soap__s
soaring83521893soaring
soaringly1337273soaringly
soberly1236943soberly
sodality12127323sodality
softly12457763so_ftly
soil46138833so__il_
soils55327983so__ils
solely93714213so_lely
solidly1137353solidly
solubly1255283solubly
sonly85718053so__nly
soothly13186923soothly
sopapilla1352303sopapilla
sophy136611763so_p_hy
sopite84917713so_pite
soppier112711583soppier
sopping123917203sopping
soppy125113523so_p_py
sordidly1344663sordidly
sorely94618013so_rely
soundly1136683soundly
soupier93111753soupier
souping104215533souping
soupy106115403soup__y
sourly93612213so_urly
soymilk1642363soymilk
spail74921553spa_il_
spails84817823spa_ils
spangly1336473spangly
sparely123410673sparely
sparkily1735023sparkily
sparkly16348133sparkly
spicily1438653spicily
spicy125417713s__picy
spikily1635873spikily
spiky146014113s__piky
spile75230083s__pile
spill74821163s__pill
spilt75532223s__pilt
spiny104921303s__piny
spiry105017353s__piry
spongily1444903spongily
spookily1744173spookily
spoonily1335233spoonily
sportily1337733sportily
spottily1335153spottily
stabile9312063stabile
stably113314123sta_bly
staidly1136683staidly
stalely1039213stalely
stalkily1534823stalkily
staple84415823stap_le
starkly14277033starkly
stately10310223stately
steadily1236213steadily
steamily1335803steamily
stockily1735443stockily
stodgily1343903stodgily
stonily1049433stonily
stormily1345243stormily
stupidly1442633stupidly
suably112814533sua_bly
suavely1376493suavely
suavity1336313suavity
sulkily14218113sulkily
sunnily1037833sunnily
supply1346893s_upply
surlily10310003surlily
swail86217163swa_il_
swails94913123swa_ils
swankily1833833swankily
sweatily1435473sweatily
tearily10311153tearily
torpidly1483643torpidly
unaptly1244793unaptly
vapidly1635063_vapidly
warily122915093_warily
waspily1535513waspily
wavily15219483_wavily
waxily19218413_waxily
wearily1338783wearily
wispily1535653wispily
woozily2234383woozily
wordily1437853wordily
zanily18310183_zanily
zoophily2544913zoophily

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.1401276364.3
2DLD Change Limit1340272837.05019010.9
3Display Results2832830.0933043.0
 (SQL Overall)1786912837.28324535.4
 
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.