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

152 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
applying163465(None) 
allying113011662a_llying
appalling1444922appalling
apposing1337402apposing
dappling1436842dappl_ing
implying1635532implying
plying124312082__plying
reapplying1843022reapplying
replying14269402replying
supplying1774042supplying
abying124410413a__bying
addling10229833addl_ing
ailing74331013a_il_ing
allaying12339303allaying
alloying12339143alloying
ambling121411793ambl_ing
amping114317573amp__ing
amplifying2144123amplifying
analysing1345933analysing
analyzing2245153analyzing
aneling82719503anel_ing
angling92816043angl_ing
ankling122912063ankl_ing
annoying1246543annoying
aping87327233a_p__ing
appealing1446493appealing
appearing1436893appearing
appeasing1446343appeasing
appending1536283appending
applauding1642103applauding
applied1247483appl_ied
applier1137903appl_ier
applies11311213appl_ies
apply125111393apply___
appoint11612483app_oint
apprising1447963apprising
apprizing2347193apprizing
approving1745053approving
aproning11311793aproning
argling92812733argl_ing
arraying1238753arraying
aspiring1138873aspiring
assaying1236003assaying
avulsing1234433avulsing
bellying14359073bellying
belying133612443_belying
bullying14329293bullying
capping143819673capp__ing
collying14319543collying
complying1936113complying
copying153411983cop_ying
cullying14297503cullying
dallying13368493dallying
dapping133714793dapp__ing
deploying1636153deploying
dollying13407413dollying
employing1765343employing
emptying1634243emptying
epoxying2133033epoxying
espying1336193esp_ying
flying134612153__flying
gallying13328933gallying
gapping134214783gapp__ing
gillying13306813gillying
gipsying1533373gipsying
grappling1544993grappl_ing
gullying13367243gullying
gypsying1842183gypsying
happening1735593happening
happing153817233happ__ing
hoppling16206763hoppl_ing
inlying1168153_inlying
jellying19306173jellying
jollying19316053jollying
lappering14258843lappering
lapping124117023lapp__ing
lying95717453___lying
mapping143413993mapp__ing
misapplying2152463misapplying
mislying1437843mislying
napalming1443173napalming
napping123514183napp__ing
opposing1336383opposing
outlying1248813outlying
paling93530133_pal_ing
palling104024483_palling
palming123914013_palming
palping124112873_palping
palsying1436233palsying
pandying15217663pandying
papering132213313papering
parlaying1537303parlaying
parleying1536113parleying
parling103823763parl_ing
parrying14168133parrying
partying14168893partying
paying123722163__paying
pelting102917273_pelting
piling95025593_pil_ing
pilling103722563_pilling
pitying132910243_pitying
playing133816093_playing
ploying132811573_ploying
poling93526503_pol_ing
polling102920383_polling
ponying133312123_ponying
poppling12227323poppl_ing
praying133717323_praying
preapplying1842193preapplying
preying133114553_preying
prying124114803__prying
puling93621403_pul_ing
pulling103821073_pulling
pulping123612323_pulping
pulsing103712863_pulsing
rallying12289013rallying
rappeling1435963rappeling
rappelling1544363rappelling
rapping123619103rapp__ing
reflying15268173reflying
relying112914613_relying
repaying142712393repaying
replaying15259603replaying
rippling13197573rippl_ing
sallying12309853sallying
sampling13510643sampl_ing
sapling103217863sapl_ing
sapping123519313sapp__ing
spalling113213463spalling
spaying133014623_spaying
spelling113315233spelling
spiling102919703spil_ing
spilling113113943spilling
splaying14219303splaying
spraying14299883spraying
spying123913253_sp_ying
sullying12328513sullying
suppling1359043suppl_ing
tallying12318833tallying
tapping123317133tapp__ing
taxpaying2242343taxpaying
tippling13196703tippl_ing
toppling13197353toppl_ing
unpaying1456943unpaying
updrying1534013updrying
upfling1337093upfl_ing
uppiling1335853uppiling
upping114013703upp__ing
wapping153514603wapp__ing
willying15306713willying
yapping153412613yapp__ing
zapping213211473zapp__ing

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621526.95321021.4
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.43624030.5
 
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.