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 “spalling” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
spalling11321346(None) 
palling104024481_palling
sparling112714531sparling
spelling113315231spelling
spilling113113941spilling
stalling95116701stalling
appalling1444922appalling
balling104424762_balling
calling103826772_calling
dialling10310782dialling
falling113621582_falling
galling93921962_galling
lalling83519622_lalling
malling103623662_malling
paling93530132_pa_ling
palming123914012_palming
palping124112872_palping
parling103823762_parling
pilling103722562_pilling
polling102920382_polling
psalming1375472psalming
pulling103821072_pulling
sailing83927372s_ailing
sallying12309852s_allying
salting84120792s_alting
salving113913152s_alving
sapling103217862s_apling
scalding12339392scalding
scaling103519372sca_ling
scalping133410452scalping
sculling112910992sculling
sealing83528562sea_ling
selling83225832s_elling
shauling1249392shauling
shawling1558222shawling
shelling123515212shelling
shilling123315382shilling
skilling132911332skilling
skulling13258102skulling
smelling113712722smelling
snailing92912972snailing
snarling92513182snarling
snelling93913562snelling
spacing123614492spa_cing
spackling18266502spackling
spading113114382spa_ding
spaeing103413542spa_eing
spamming15317602spamming
spangling1336372spangling
spanking153911972spanking
spanning113311082spanning
sparging122611132sparging
sparing104823872spa_ring
sparking152812542sparking
sparkling16226352sparkling
sparlings12257152sparlings
sparring113112222sparring
spasming13227202spasming
spatting113111762spatting
spawning14296912spawning
spaying133014622spa_ying
speeling112713122speeling
speiling113612972speiling
spellings12296552spellings
spieling113212522spieling
spiling102919702sp_iling
spiralling1343962spiralling
splaying14219302splaying
spoiling112911552spoiling
spooling113212562spooling
sprawling15175122sprawling
squalling1935172squalling
stabling112913652stabling
staling83925422sta_ling
stalking133512222stalking
stapling112813152stapling
starling93017122starling
stilling93415322stilling
swelling123212752swelling
swilling123511932swilling
vialling1237222vialling
walling113520972_walling

Search took 5 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 Filter1786911210590.436409841.7
2DLD Change Limit121059823.62633386.4
3Display Results82820.0302733.3
 (SQL Overall)178691824.09243668.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.