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

180 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
spackling1826649(None) 
shackling19286171shackling
sparkling16226341sparkling
speckling18235581speckling
cackling172610942_cackling
crackling18157002crackling
hackling183310162_hackling
mackling172710062_mackling
packing164420722_pack_ing
pickling17239202_pickling
sacking144122702s_ack_ing
shacking184014082shack_ing
sickling152910332s_ickling
slacking153914132slack_ing
smacking173510762smack_ing
snacking153411702snack_ing
spacing123614492spac__ing
spalling113213462spa_lling
spanceling1543942spanceling
spangling1336372spangling
spanking153911972spank_ing
sparking152812532spark_ing
sparling112714522spa_rling
specking17359732speck_ing
stacking154215082stack_ing
stickling1647002stickling
suckling152410022s_uckling
tackling153211122_tackling
ankling122912063__ankling
backing165523443_back_ing
blacking174213603black_ing
buckling17259113_buckling
chuckling2144193chuckling
clacking173313493clack_ing
cockling172310393_cockling
cracking174013903crack_ing
cracklings19143523cracklings
crankling16147293crankling
darkling1437483_darkling
duckling16247703_duckling
flacking184311793flack_ing
freckling1934703freckling
hacking173720613_hack_ing
heckling18257163_heckling
jacking214515263_jack_ing
keckling14245523_keckling
knacking14296713knack_ing
knuckling1542753knuckling
lacking143821543_lack_ing
maculing13219583_maculing
nickling15278703_nickling
pacing114522753_pac__ing
packaging1945163_packaging
packeting1836853_packeting
packings174310063_pack_ings
paddling13218643_paddling
paiking143814813_paik_ing
paling93530133_pa__ling
palling104024483_pa_lling
paneling111013623_paneling
parceling1438443_parceling
parking143423043_park_ing
parling103823763_pa_rling
paroling113316213_paroling
pecking164017783_peck_ing
picking163418333_pick_ing
pocking163916763_pock_ing
prickling1836533prickling
quacking2436743quack_ing
racking144323663_rack_ing
rankling132610113_rankling
repacking1838283repack_ing
retackling1744433retackling
rockling15259383_rockling
ruckling15258573_ruckling
sackings15389633s_ack_ings
sacklike1337303s_acklike
sacring103115983s_ac_ring
saddling11239593s_addling
sailing83927373s_a_iling
sampling13510643s_ampling
sandling102214413s_andling
sapling103217863s_a_pling
scabbling1634863scabbling
scaling103519373s__caling
scantling12107233scantling
sealing83528563sea__ling
shaking153317253sha_k_ing
shambling1735593shambling
shanking163612283shank_ing
sharking163912973shark_ing
shauling1249393sha_uling
shaveling1646843shaveling
shawling1558223sha_wling
shocking184311533shock_ing
shucking18339433shuck_ing
sicking143720173s_ick_ing
sicklying1943883s_icklying
skanking12288743skank_ing
slackening1744343slackening
slaking123717473sla_k_ing
slicking153712593slick_ing
smocking17349103smock_ing
snaffling1643753snaffling
snailing92912973sna_iling
snaking123915303sna_k_ing
snarling92513183sna_rling
snicking153610233snick_ing
soaking123116613soa_k_ing
socking143518603s_ock_ing
spacings13287043spac__ings
spackle15369563spackl__e
spackled17297793spackl_ed
spackles16319943spackl_es
spading113114383spa__ding
spaeing103413543spa__eing
spamming15317603spa_mming
spancelling1643343spancelling
spankings16215003spank_ings
spanning113311083spa_nning
sparging122611133spa_rging
sparing104823873spa__ring
sparklier1554353sparklier
sparlings12257143spa_rlings
sparring113112223spa_rring
spasming13227203spa_sming
spatting113111763spa_tting
spawning14296913spa_wning
spaying133014623spa__ying
speaking153212493speak_ing
speccing15306643spec_cing
speeling112713123sp_eeling
speiling113612973sp_eiling
spelling113315233sp_elling
spicing123914533spic__ing
spieling113212523sp_ieling
spiking144312883sp_ik_ing
spiling102919703sp__iling
spilling113113943sp_illing
spindling13136273spindling
spiraling1237953spiraling
spoiling112911553sp_oiling
spoking143212223sp_ok_ing
spooking15269803spook_ing
spooling113212563sp_ooling
spraddling1542313spraddling
sprattling1363053sprattling
sprawling15175123sprawling
sprinkling1743823sprinkling
spunking15258063spunk_ing
stabling112913653sta_bling
staking123919803sta_k_ing
staling83925423sta__ling
stalking133512223stalk_ing
stalling95116703sta_lling
stapling112813153sta_pling
starling93017123sta_rling
startling1037373startling
sticking153513463stick_ing
stocking152912503stock_ing
strickling1744953strickling
sucking143217413s_uck_ing
sucklings16225113s_ucklings
swaddling1543813swaddling
swanking16399963swank_ing
tacking144421483_tack_ing
tacklings16235853_tacklings
thacking183110043thack_ing
tickling15309433_tickling
trachling1537823trachling
tracking153715463track_ing
trickling1647723trickling
truckling1645073truckling
unpacking1835133unpack_ing
unshackling2141653unshackling
upscaling1444653upscaling
weakling16106763wea_kling
whacking21377483whack_ing
wracking18349963wrack_ing
yacking174315683_yack_ing

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 Filter1786911486410.1531167915.0
2DLD Change Limit1486411808.28317945.3
3Display Results1801800.0762368.4
 (SQL Overall)1786911808.51220992.8
 
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.