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

202 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
spangling133637(None) 
angling92816042__angling
bespangling1742102bespangling
dangling112611232_dangling
gangling112411402_gangling
jangling17249622_jangling
mangling122312622_mangling
paneling111013622_paneling
panging113319112_pang_ing
pungling12228662_pungling
sandling102214412s_andling
scantling12107232scantling
shingling14136972shingling
singling101913002s_ingling
slanging103413432slang_ing
spackling18266502spackling
spalling113213462spa_lling
spanceling1543942spanceling
spanglier1244192spanglier
spanking153911972span_king
spanning113311082span_ning
sparging122611132sparg_ing
sparkling16226352sparkling
sparling112714532spa_rling
spindling13136272spindling
sponging1238822spong_ing
stanging104013652stang_ing
strangling1256402strangling
swingling14156202swingling
tangling101712542_tangling
twangling1434452twangling
wangling132310992_wangling
wrangling1456222wrangling
aneling82719503__aneling
angeling102811733__angeling
anglings10228273__anglings
ankling122912063__ankling
argling92812733__argling
banging114019863_bang_ing
bantling112612003_bantling
brandling1348253brandling
bungling12269543_bungling
canaling112016413_canaling
candling122313873_candling
changeling1745673changeling
changing153211513chang_ing
clanging124012123clang_ing
crankling16147293crankling
daggling12237063_daggling
dandling112511733_dandling
danging103716093_dang_ing
draggling1354613draggling
eagling91113603_ea_gling
eanling81416673_ean_ling
empaneling1573403empaneling
entangling1244313entangling
fenagling1434553fenagling
finagling1434703finagling
flanging132710583flang_ing
gaggling10217463_gaggling
ganging103216193_gang_ing
gargling11239203_gargling
haggling14227273_haggling
handling132312713_handling
hanging123518703_hang_ing
impaneling1573373impaneling
jingling17188573_jingling
mantling112012613_mantling
mingling122010933_mingling
paddling13218643_paddling
paging104020403_pa_g_ing
paling93530133_pa__ling
palling104024483_pa_lling
pandying15217663_pandying
panelings12107453_panelings
panelling1239073_panelling
pangolin1147773_pangolin_
pangolins1247373_pangolins
panning104019393_pan_ning
panting104025423_pan_ting
parging113318603_parg_ing
parling103823763_pa_rling
paroling113316213_paroling
pindling122110983_pindling
pinging113419553_ping_ing
ponging113416153_pong_ing
pranging123012723prang_ing
ranging94120263_rang_ing
rankling132610113_rankling
repaneling1345733repaneling
saddling11239593s_addling
sagging103116103s_a_gging
sailing83927373s_a_iling
sampling13510643s_ampling
sandaling112010563s_andaling
sanding93520603s_an_ding
sandlings11238093s_andlings
sanguine947633s_anguine
saning75127643s_an__ing
sapling103217863s_a_pling
scabbling1634863scabbling
scaling103519373sca__ling
scandaling14195453scandaling
scanning113310773scan_ning
scanting113914763scan_ting
scantlings1393313scantlings
seagoing1038193sea_going
sealing83528563sea__ling
shackling19286173shackling
shagging14349053sha_gging
shambling1735593shambling
shanking163612283shan_king
shauling1249393sha_uling
shaveling1646843shaveling
shawling1558223sha_wling
signaling1136563signaling
singeing10209933s_ingeing
singing93221423s_ing_ing
skanking12288743skan_king
slagging113711573sla_gging
slanting94115093slan_ting
slinging103312863sling_ing
smuggling1433243smuggling
snaffling1643763snaffling
snagging11319373sna_gging
snailing92912973sna_iling
snarling92513183sna_rling
sniggling1244413sniggling
snuggling1243473snuggling
spacing123614493spa__cing
spading113114383spa__ding
spaeing103413543spa__eing
spamming15317603spa_mming
spancelling1643343spancelling
spangle1038403spangl__e
spangled1236153spangl_ed
spangles1138893spangl_es
spangliest1345153spangliest
spangly1336473spangl__y
spankings16215003span_kings
sparing104823873spa__ring
sparking152812543spa_rking
sparlings12257153spa_rlings
sparring113112223spa_rring
spasming13227203spa_sming
spatting113111763spa_tting
spawning14296913spa_wning
spaying133014623spa__ying
speaning113512243spean__ing
speckling18235583speckling
speeling112713123sp_eeling
speiling113612973sp_eiling
spelling113315233sp_elling
spending122712433spen_ding
spieling113212523sp_ieling
spiling102919703sp__iling
spilling113113943sp_illing
spinning113310813spin_ning
spiraling1237953spiraling
spoiling112911553sp_oiling
spongin1036373spong_in_
spongins1136563spong_ins
spooling113212563sp_ooling
spraddling1542313spraddling
sprattling1363053sprattling
sprawling15175123sprawling
sprigging1435893sprigging
springeing1444373springeing
springing1338743spring_ing
sprinkling1743823sprinkling
spunking15258063spun_king
stabling112913653sta_bling
stagging113310513sta_gging
staging93818373sta_g_ing
staling83925423sta__ling
stalling95116703sta_lling
stanching1538083stanching
standing103413633stan_ding
staning83922243stan__ing
stapling112813153sta_pling
starling93017123sta_rling
startling1037373startling
stinging103213453sting_ing
straggling1344303straggling
swaddling1543813swaddling
swagging14328093swa_gging
swaging124210633swa_g_ing
swanking16399963swan_king
swanning12338813swan_ning
swindling14135833swindling
swingeing14144693swingeing
swinging133411113swing_ing
tanging93419523_tang_ing
tangoing10177893_tangoing
tingling102210823_tingling
twanging13287063twang_ing
untangling1244123untangling
waggling14197063_waggling
weanling12118643wean_ling
whanging16267143whang_ing
yeanling12107063yean_ling
youngling1463273youngling

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486412026.57622603.6
3Display Results2022020.0802525.0
 (SQL Overall)1786912026.81226231.8
 
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.