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

181 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
parceling143844(None) 
parcelling1546171parcelling
barreling1238042barreling
canceling14310162canceling
marcelling1545592marcelling
marveling1537102marveling
paneling111013622pa_neling
parching164313052parc_hing
pargeting1338282pargeting
parleying1536112parleying
parling103823762par__ling
paroling113316212par_oling
spanceling1543942spanceling
acceding1446093_acceding
aneling82719503_a_neling
angeling102811733_angeling
appareling1543423appar_eling
arcading1239763_arcading
arching136216693_arc_hing
arcing95819643_arc__ing
arcking145811963_arc_king
argling92812733_ar_gling
atheling1249203_atheling
barbering14229693barbering
barrelling1345453barrelling
bartering122313653bartering
cackling172610943ca_ckling
cageling12310843ca_geling
cancelling1547213cancelling
caracoling1545633caracoling
careening12310013careening
careering12311203careering
carling103727063car__ling
caroling113317003car_oling
carolling1259413carolling
carpeting1439483carpeting
circling1338423circ_ling
corbeling1439033corbeling
crackling18157003crackling
creeling113513363_creeling
darkening1535683darkening
darkling1437483dar_kling
darling93418363dar__ling
dartling1039563dar_tling
earthling1346193earthling
faceting1438783fa_ceting
farcing133514003farc__ing
farseeing1344383farseeing
ferreling13136273ferreling
garbling12249453gar_bling
gardening1236513gardening
gargling11239203gar_gling
garnering11298093garnering
gartering112111593gartering
gaveling133410163ga_veling
graveling1457383graveling
grueling1078273_grueling
hackling183310163ha_ckling
hanseling1338063hanseling
hardening1438023hardening
harkening1746923harkening
hatcheling1943693hatcheling
hatchling1844953hatchling
hireling121210993hir_eling
hirseling1396273hirseling
kerneling1464403kerneling
labeling11311653la_beling
lacewing1435843la_cewing
laureling1035643laureling
mackling172710063ma_ckling
maculing13219583ma_culing
marbling13179883mar_bling
marching164312193marc_hing
marketing1636513marketing
marling103322773mar__ling
marvelling1645363marvelling
morseling1238073morseling
narcein936293narce_in_
narceine1046753narce_ine
narceins1036413narce_ins
pacing114522753pa_c__ing
packeting1836853packeting
packing164420723pa_c_king
paddling13218643pa_ddling
paling93530133pa___ling
palleting1238743palleting
palling104024483pa__lling
paltering122612903paltering
pampering1638383pampering
pancaking1836383pancaking
pandering133211963pandering
panelings12107453pa_nelings
panelling1239083panelling
papering132213313pa_pering
parading12313863par_ading
paralleling1463103paralleling
parawing14310583par_awing
parbaking1877203parbaking
parboiling1545173parboiling
parbuckling2251463parbuckling
parcel103915473parcel___
parceled1338343parcel_ed
parcelled1445783parcelled
parcels113712663parcel__s
pardoning1338763pardoning
parenting12611583parenting
pargetings1443713pargetings
pargetting1444943pargetting
parging113318603par__ging
pargyline1544653pargyline
parhelia1346713parheli_a
parhelic1547093parheli_c
parhelion1444223parhelion
paring94236493par___ing
parking143423043par__king
parlaying1537303parlaying
parodying1655423parodying
parqueting2243633parqueting
parring103222063par__ring
parroting1239153parroting
parrying14168133par_rying
parsing103819553par__sing
partaking1698673partaking
parting103527383par__ting
partnering1345553partnering
partying14168893par_tying
parvolin1376933parvolin_
parvoline1477173parvoline
parvolins1486693parvolins
patching163212753patc_hing
patrolling1345693patrolling
pattering122314433pattering
paupering1437273paupering
pearling11912013pear__ling
peeling102919873p__eeling
penciling1437413penciling
percaline13410953percaline
perceiving1844663perceiving
perching163711633perc_hing
periling11316863per_iling
perilling12410003perilling
pickling17239203p_ickling
pommeling1643873pommeling
porcelain1344133porcelain_
porcelains1444383porcelains
portering122012303portering
prattling1246303prattling
preceding15129363preceding
preeing103817673p_r_eeing
preening113115843p_reening
preying133114553p_r_eying
prickling1836533prickling
prilling113413413p_rilling
princeling1544653princeling
prowling1449993p_rowling
pummeling1643603pummeling
pureeing1137273pur_eeing
purfling1467763pur_fling
purling103620293pur__ling
purpling1368543pur_pling
purveying1843573purveying
quarreling2043663quarreling
rappeling1435963rappeling
raveling123414373ra_veling
reeling83126863__reeling
spackling18266503spa_ckling
spancelling1643343spancelling
sparkling16226353spar_kling
sparling112714533spar__ling
starveling1444263starveling
streeling10189483streeling
tackling153211123ta_ckling
targeting1137303targeting
tasseling1035853tasseling
trachling1537823trachling
trameling1249053trameling
traveling1349053traveling
unreeling1038983unreeling
warbling14198943war_bling
warsling12198593war_sling
warstling1335063warstling

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411816.87621617.4
3Display Results1811810.0762381.6
 (SQL Overall)1786911817.37524229.3
 
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.