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

126 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
parceners133746(None) 
larceners1136001larceners
parcener1238471parcener_
careeners1138552careeners
coparceners1752342coparceners
darkeners1435162darkeners
gardeners1136612gardeners
hardeners1338092hardeners
harkeners1636082harkeners
larcener1036492larcener_
parcenary1643902parcenary
pardners11269192par_dners
pardoners12208212pardoners
parleyers1444702parleyers
partners102711132par_tners
preeners102712812p_reeners
sarcenets1146962sarcenets
warreners1236202warreners
acceders1334793_acceders
alieners889823_alieners
archers124414573_arc_hers
archness1337513_archness
arenes64928393_ar_ene_s
ascenders1235693_ascenders
bareness10912813bar_eness
barrener1038343barrener_
bartenders1344243bartenders
barterers11269643barterers
batteners11238183batteners
burdeners1245063burdeners
cancelers13247863cancelers
carcanets1347313carcanets
careener1039333careener_
careerers1137243careerers
careers95218783car_e_ers
carpenters1445853carpenters
coparcener1652643coparcener_
dampeners1444663dampeners
darkener1335993darkener_
darners83815773dar__ners
earners74016453ear__ners
falconers1445323falconers
farcers124713443farc__ers
farceurs13464723farce_urs
fasteners12237063fasteners
fatteners12236883fatteners
gardener1037113gardener_
garners83815993gar__ners
hardener1238883hardener_
harkener1537573harkener_
hasteners12267823hasteners
hearkeners1743983hearkeners
hearteners1346213hearteners
larcenies1147533larcenies
larcenous1145013larcenous
largeness1038273largeness
lateeners945573lateeners
marcellers1443833marcellers
marchers153710813marc_hers
mariners103113863mar_iners
marketers1545993marketers
narceines1146583narceine_s
pacers105124543pa_c__ers
packers153818893pa_c_kers
packness1636933pa_ckness
paleness10312983pa_leness
palterers11249543palterers
pamperers15236863pamperers
panderers12229153panderers
pangenes112612823pangene_s
panners93621273pa__nners
paperers122410453pa_perers
paraders113113113par_aders
parameters1448123parameters
parceled1338343parcele_d
parcels113712663parc__els
parcenaries1555853parcenaries
parches143720003parc_he_s
pardner10239473par_dner_
pardoner11189443pardoner_
parents93418123par_en_ts
parers85530743par___ers
pareses94718883par_ese_s
parietes10714543pariete_s
parkers133816873par__kers
parleyer1335633parleyer_
parriers103612903par_riers
parroters1156773parroters
parsers94118153par__sers
partakers1536563partakers
parterres1148083parterres
partiers103514243par_tiers
partner92811393par_tner_
partyers13277763par_tyers
parvenues1444643parvenues
parvenus1335653parven_us
passengers1343223passengers
patchers153413303patc_hers
patterers112410133patterers
pawners124311073pa__wners
perceivers1743893perceivers
percents122713373percen_ts
perchers153611523perc_hers
pilseners1144943pilseners
prawners1346003p_rawners
preener93114833p_reener_
prefers123713333p_r_efers
preyers124412363p_r_eyers
pruners93710723p_r_uners
pureness101110183pur_eness
pyrenes123511223pyr_ene_s
rareness81112853rar_eness
ratteners9237273ratteners
raveners11309133ra_veners
sarcenet10413313sarcene_t
sarsenets946523sarsenets
scarceness1444763scarceness
screeners1136743screeners
sharpeners1543893sharpeners
sorcerers1145323sorcerers
spareness1139863spar_eness
sparseness1245493sparseness
wakeners1535843wa_keners
warners103315563war__ners
warrener1136923warrener_
yarners104312203yar__ners

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.423422437.4
2DLD Change Limit1486411267.75019179.5
3Display Results1261260.0632000.0
 (SQL Overall)1786911268.23621696.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.