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

255 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
sappily143716(None) 
happily1745761happily
snappily1544321snappily
apply125111392_app_ly
campily1638272campily
nippily1444712nippily
peppily1335122peppily
saltily10310542saltily
sappier113613112sappier
sapping123519312sapping
sappy125413472sapp__y
sassily1038722sassily
saucily1237912saucily
savvily1634322savvily
scrappily1842672scrappily
slippily1544192slippily
sloppily1544612sloppily
snippily1543572snippily
soapily1237962soapily
supply1346892supp_ly
waspily1535512waspily
aerily93017013_aerily
airily93014823_airily
amply125012913_amp_ly
appal95315223_appal_
appall10379743_appall
appals104812943_appals
appel94615893_appel_
appels104312793_appels
apple94517673_app_le
aptly105111813_a_ptly
artily92814713_artily
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
bawdily1635803bawdily
bumpily1665653bumpily
cagily12411563ca_gily
cannily1239263cannily
capably1639253capably
capping143819673capping
cattily123210853cattily
choppily2044133choppily
daffily1735133daffily
daily95922333da__ily
damply14337893damp_ly
dandily12279633dandily
dapperly1643003dapperly
dapping133714793dapping
dapple1138853dapp_le
daylily1434983daylily
dopily123510463_dopily
drippily1643033drippily
dumpily1566233dumpily
easily9313023ea_sily
emptily1445813emptily
family143311703fa_mily
fancily1538253fancily
fattily13379463fattily
floppily1843773floppily
gaily95020973ga__ily
gamily123712183ga_mily
gappier12369843gappier
gapping134214783gapping
gappy136212033gapp__y
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
hammily1736063hammily
handily143610873handily
haply135915063ha_p_ly
happier143312033happier
happing153817233happing
happy155813533happ__y
hardily143310273hardily
hastily133010663hastily
hazily2179063ha_zily
jazzily2533373jazzily
jumpily2174983jumpily
lacily11612763la_cily
lankily1437123lankily
lapping124117023lapping
lazily1859713la_zily
loopily1236803loopily
lumpily1476563lumpily
mangily1339753mangily
manlily1238743manlily
mapping143413993mapping
mazily20610393ma_zily
misapply1742883misapp_ly
nappie104112263nappi_e
nappier114411173nappier
nappies114613393nappies
napping123514183napping
nappy126312333napp__y
nastily103011033nastily
nattily103610323nattily
papally1437973papally
pappi84810893pappi__
pappier103511593pappier
pappies103214823pappies
pappy114713803papp__y
pawkily1934203pawkily
pily96132733___pily
preppily1444583preppily
pulpily1436103pulpily
racily11715173ra_cily
rainily10310433rainily
rapidly1336523rapidly
rappel104211953rappel_
rappels11448803rappels
rapping123619103rapping
rappini11347573rappini
raptly11338913ra_ptly
reapply1434323reapp_ly
ripply13348003ripp_ly
ropily113312443_ropily
roupily1246653roupily
sadly94519123sa__dly
safely12249393sa_fely
sagely102811383sa_gely
sail45447163sa__il_
sails55738103sa__ils
saintly1039343saintly
salably121610743salably
salify12311373sa_lify
sally85129713sa__lly
salpian938493salpian
salpid9510873salpi_d
salpids1038193salpids
salpinx1636093salpinx
salsify1334703salsify
sample104215013samp_le
sandfly1435643sandfly
sandpile1146773sandpile
sanely93114613sa_nely
sanity9316203sa_nity
sapid84720933sa_pi_d
sapidity1446433sapidity
sapling103217863sapling
saponify1644183saponify
sapped114422013sapp_ed
sapper103822353sapp_er
sappers113518893sappers
sapphic1644553sapphic
sapphics1743413sapphics
sapphire1543793sapphire
sapphism1743803sapphism
sapphist1545763sapphist
sappiest122612573sappiest
satiny93817983sa_tiny
savorily1445043savorily
sawbill1255293sawbill
sawfly1535133sa_wfly
sawmill1244073sawmill
scabbily1763943scabbily
scantily1337583scantily
scarily12311703scarily
seedily1178583seedily
sexily1638853s_exily
shabbily1873903shabbily
shadily1437723shadily
shaggily1643773shaggily
shakily1736903shakily
shapely1536893shapely
sharply15406833sharp_ly
shily115222013s__hily
shinily13268933shinily
showily1636213showily
silkily14236963silkily
sillily10209783sillily
simply133010523simp_ly
sipping123117433sipping
skimpily1963053skimpily
slangily1235383slangily
slapping133510833slapping
sleepily1344823sleepily
slily85820033s__lily
slimily1247713slimily
smarmily1543523smarmily
smokily1635373smokily
snakily1436913snakily
snappier1266213snappier
snapping13349653snapping
snappish1545233snappish
snappishly2052193snappishly
snappy1366103snapp__y
snarkily1534583snarkily
snoopily1345553snoopily
snowily1336883snowily
soggily1235953soggily
sootily101810513sootily
soppier112711583soppier
sopping123917203sopping
soppy125113523sopp__y
sorrily1039823sorrily
spail74921553s_pail_
spails84817823s_pails
spangly1336473spangly
sparely123410663sparely
sparkily1735013sparkily
sparkly16348123sparkly
speil75618643s_peil_
speils84116223s_peils
spicily1438653spicily
spicy125417713s__picy
spikily1635873spikily
spiky146014113s__piky
spile75230083s__pile
spill74821163s__pill
spilt75532223s__pilt
spiny104921303s__piny
spiry105017353s__piry
spoil75818643s_poil_
spoils84614533s_poils
spoilt85016593s_poilt
spryly1435513s_pryly
stagily1139053stagily
stalkily1534823stalkily
stonily1049433stonily
stupidly1442633stupidly
sulkily14218113sulkily
sunnily1037833sunnily
supping123814533supping
supple10410203supp_le
supplely1543043supplely
surlily1039993surlily
swankily1833833swankily
swapping16348673swapping
tackily1637503tackily
tapping123317133tapping
tardily11269583tardily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tawnily1335443tawnily
tipsily1236043tipsily
unhappily1982083unhappily
uppile10178503_uppile
uppity1335103_uppity
vapidly1635063vapidly
wackily1936053wackily
wapping153514603wapping
warily122915093wa_rily
wavily15219483wa_vily
waxily19218413wa_xily
wispily1535653wispily
yapping153412613yapping
yappingly2043793yappingly
yuppify2042163yuppify
zanily18310183za_nily
zappier20458373zappier
zapping213211473zapping
zappy21548943zapp__y

Search took 9 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.1531167915.0
2DLD Change Limit1340272558.03316684.6
3Display Results2552550.0932741.9
 (SQL Overall)1786912558.27921583.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.