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

355 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
pickling1723920(None) 
nickling15278701nickling
picking163418331pick_ing
prickling1836531prickling
sickling152910331sickling
tickling15309431tickling
buckling17259112buckling
cackling172610942cackling
cockling172310392cockling
dicking153617612dick_ing
duckling16247702duckling
hackling183310162hackling
heckling18257162heckling
inkling122911302_inkling
keckling14245522keckling
kicking133314022kick_ing
licking144118282lick_ing
mackling172710062mackling
nickeling1645392nickeling
nicking143516322nick_ing
packing164420722pack_ing
pecking164017782peck_ing
pickaxing2543102pickaxing
picketing1835682picketing
pickings17359382pick_ings
picolin11310882picolin_
picoline12310852picoline
picolins1239852picolins
picoting1338882picoting
piddling13208952piddling
piffling1745132piffling
piking133719642pi_k_ing
piling95025592pi__ling
pilling103722562pi_lling
pindling122110982pindling
pinking143918942pink_ing
pocking163916762pock_ing
pricking173212602prick_ing
ricking143920232rick_ing
rockling15259382rockling
ruckling15258572ruckling
sicking143720172sick_ing
sicklying1943882sicklying
spackling18266502spackling
speckling18235582speckling
stickling1647002stickling
suckling152410022suckling
tackling153211122tackling
ticking143218752tick_ing
tinkling13239232tinkling
trickling1647722trickling
wicking173414772wick_ing
winkling16298292winkling
ailing74331013ai__ling
ankling122912063_ankling
arcking145811963arck_ing
backing165523443back_ing
becking164416073beck_ing
bickering1837663bickering
bicycling1942883bicycling
biking135018173bi_k_ing
bilking144413553bilk_ing
billing103823853bi_lling
birling104317053bi_rling
bricking173911403brick_ing
bucking163617573buck_ing
chuckling2144193chuckling
circling1338423circling
clicking173610983click_ing
cling86424673__c_ling
cocking163619983cock_ing
crackling18157003crackling
cricking173412653crick_ing
crinkling16145863crinkling
cycling1537213cyc_ling
darkling1437483darkling
decking153915593deck_ing
dialing94318173di_aling
dialling10310783dialling
dibbling14247333dibbling
dicing105718763dic__ing
dickering1737463dickering
dicliny1337673dic_liny
diddling12228743diddling
diking124320243di_k_ing
dimpling14199023dimpling
dindling112411163dindling
dinking133618283dink_ing
dirking133812603dirk_ing
dirling93316073di_rling
disking134615493disk_ing
docking153615013dock_ing
ducking154315053duck_ing
ducklings17204013ducklings
fiddling14217873fiddling
filing103823763fi__ling
filling113520803fi_lling
finking154016603fink_ing
fizzling20264993fizzling
flicking184110043flick_ing
freckling1934703freckling
fucking173212283fuck_ing
gecking154111363geck_ing
giggling10227043giggling
gilling93520383gi_lling
girdling1146823girdling
hacking173720613hack_ing
higgling14217163higgling
hiking143617103hi_k_ing
hilling113821773hi_lling
hireling121210993hireling
hirpling1467223hirpling
hirsling1277543hirsling
hocking173417243hock_ing
hoicking1836053hoick_ing
icing86017753_ic__ing
idling8912883_i_dling
inking115119053_ink_ing
inklings13246383_inklings
irking114611753_irk_ing
isling71213883_i_sling
jacking214515263jack_ing
jiggling18226363jiggling
jingling17188573jingling
jinking193613543jink_ing
kecking134111883keck_ing
kibbling17225703kibbling
killing123118723ki_lling
kindling14229623kindling
kinking113615153kink_ing
kitling123313573ki_tling
kittling1336063kittling
knuckling1542753knuckling
lacking143821543lack_ing
libeling1139873libeling
lichting14268513lichting
lickings15298143lick_ings
liking114319583li_k_ing
linking123818253link_ing
locking143718153lock_ing
lucking143615833luck_ing
maculing13219583maculing
miauling1137343miauling
miching152911803mic_hing
middling13249343middling
miking134218463mi_k_ing
milking143712763milk_ing
milling103223683mi_lling
mingling122010933mingling
mizzling19255443mizzling
mocking163614453mock_ing
mucking163213823muck_ing
necking143913893neck_ing
neckline1496363neckline
nibbling13256503nibbling
niching133612433nic_hing
nickelling1743643nickelling
nickering1636573nickering
niggling11227443niggling
nilling83619563ni_lling
nocking143615113nock_ing
oiling74925313oi__ling
oinking123714713oink_ing
pacing114522753pac__ing
packaging1945163packaging
packeting1836853packeting
packings174310063pack_ings
paddling13218643paddling
paiking143814813paik_ing
paling93530133p__aling
palling104024483p_alling
paneling111013623paneling
panicking1835293panick_ing
parceling1438443parceling
parking143423043park_ing
parling103823763p_arling
paroling113316213paroling
peaking144317693peak_ing
pealing104123203p_ealing
pearling11912013pearling
pebbling1535073pebbling
peching154513903pec_hing
pedaling122412133pedaling
peddling13217973peddling
peeking144414953peek_ing
peeling102919873p_eeling
penciling1437413penciling
peopling1338353peopling
periling11316863periling
perking143716463perk_ing
pestling111010253pestling
pettling1168213pettling
piaffing1733923piaffing
picholine1646643picholine
pickeering1943533pickeering
pickier153912973pick_ier
pickle144215653pickl__e
pickled164011883pickl_ed
pickles153215443pickl_es
picklock1743613picklock
pickwick2042293pickwick
picolines1339623picolines
picturing1436033picturing
piecing12410453pi_ecing
pieing93917653pi__eing
piercing1346663piercing
pigging123614673pi_gging
piing85218833pi___ing
pilings103313613pi__lings
piloting1139693piloting
pimping143812123pi_mping
pinching163711053pinching
pinging113419553pi_nging
pining93726533pi__ning
pinkening1634993pinkening
pinkings15338143pink_ings
pinning103417853pi_nning
pipeline12149503pipeline
piping114017453pi__ping
pipkin14248603pipk_in_
pipkins15328183pipk_ins
pipping113414743pi_pping
piquing1935873pi_quing
pirating11314513pirating
pishing134314373pi_shing
pissing103914803pi_ssing
pistoling1268493pistoling
pitching163411113pitching
pithing134014053pi_thing
pitting103618873pi_tting
pitying132910243pi_tying
pivoting1436183pivoting
plinking153611243plink_ing
plucking17357723pluck_ing
pocketing1875853pocketing
poking133819303p_ok_ing
poling93526503p__oling
polkaing1534633polkaing
polling102920383p_olling
pooling103219093p_ooling
poppling12227323poppling
porking143515813pork_ing
pricing123417343pric__ing
prickings18315653prick_ings
pricklier17245063pricklier
prilling113413413prilling
princeling1544653princeling
prinking153212453prink_ing
prowling1449993prowling
puckering1835883puckering
puddling13218033puddling
puking133913063p_uk_ing
puling93621403p__uling
pulling103821073p_ulling
pungling12228663pungling
purfling1467763purfling
purling103620293p_urling
purpling1368543purpling
puzzling19225393puzzling
racking144323663rack_ing
rankling132610113rankling
recking144319923reck_ing
ricing94822763ric__ing
riddling11249443riddling
ridgling11258203ridgling
riesling939013riesling
riffling1556113riffling
rifling112815013ri_fling
riling74227973ri__ling
rilling84023623ri_lling
rimpling13219663rimpling
rippling13197573rippling
risking123914243risk_ing
rivaling1239913rivaling
rocking143619633rock_ing
rocklings16224843rocklings
rucking143216673ruck_ing
runkling13217613runkling
sacking144122703sack_ing
scaling103519373_scaling
shackling19286173shackling
sibling10814423si_bling
siccing12319513sic_cing
sickening1635993sickening
sicklied1546583sicklied
sicklier1457213sicklier
sicklies14710013sicklies
sicklily1744293sicklily
sideling101012183sideling
sidling9915423si_dling
silking123715593silk_ing
singling101913003singling
sinking123320543sink_ing
sizzling17225783sizzling
slicking153712593slick_ing
snicking153610233snick_ing
socking143518603sock_ing
sparkling16226353sparkling
specking17359733speck_ing
spicing123914533spic__ing
spieling113212523spi_eling
spiking144312883spi_k_ing
spiling102919703spi__ling
spilling113113943spi_lling
spindling13136273spindling
spiraling1237953spiraling
sprinkling1743823sprinkling
sticking153513463stick_ing
strickling1744953strickling
sucking143217413suck_ing
sucklings16225113sucklings
tacking144421483tack_ing
tacklings16235853tacklings
ticcing12308633tic_cing
ticketing1635633ticketing
tickings15368583tick_ings
ticklish1755283ticklish
tiling73426553ti__ling
tilling83522783ti_lling
tingling102210823tingling
tinklings14224663tinklings
tippling13196703tippling
tirling83315733ti_rling
titling83715793ti_tling
tricking152714513trick_ing
truckling1645073truckling
tucking143415183tuck_ing
twinkling1743643twinkling
unpicking1834883unpick_ing
upscaling1444653upscaling
vialing113614163vi_aling
vialling1237223vialling
vicing124014243vic__ing
viking143414613vi_k_ing
vittling1236143vittling
weakling16106763weakling
wickings18357183wick_ings
widdling14228743widdling
wiggling14217293wiggling
wildling13248083wildling
wiling103024293wi__ling
willing113821613wi_lling
wimbling16186543wimbling
wimpling16207483wimpling
windling132212263windling
winking153317963wink_ing
wintling12249923wintling
witling113215813wi_tling
wricking18349493wrick_ing
wrinkling17144953wrinkling
yacking174315683yack_ing
yocking173712373yock_ing
yucking173211693yuck_ing
zincking2435463zinck_ing
zizzling16233923zizzling

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623556.39022873.6
3Display Results3553550.1562275.6
 (SQL Overall)1786913556.95225703.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.