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

149 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
parcener123847(None) 
larcener1036491larcener
parceners1337451parceners
barrener1038332barrener
careener1039332careener
coparcener1652642coparcener
darkener1335992darkener
gardener1037102gardener
hardener1238882hardener
harkener1537572harkener
larceners1135992larceners
parceled1338342parceled
parcenary1643902parcenary
pardner10239472par_dner
pardoner11189442pardoner
parleyer1335632parleyer
partner92811392par_tner
preener93114832p_reener
sarcenet10413312sarcenet
warrener1136912warrener
acceder1235363_acceder
aliener71011193_aliener
arcane81216743_arcane_
archer115016243_arc_her
arene55329413_ar_ene_
arenes64928393_ar_enes
ascender1136733_ascender
bartender1244603bartender
barterer102711633barterer
battener10369393battener
burdener1136143burdener
canceler12238913canceler
carcanet12316353carcanet
careened1139193careened
careeners1138543careeners
career85822243car_e_er
careerer1038583careerer
carpenter1346503carpenter
coparceners1752343coparceners
dampener1335533dampener
darkened1435943darkened
darkeners1435153darkeners
darneder1033983darneder
darner74017303dar__ner
earner63617223ear__ner
falconer1346043falconer
farcer115016083farc__er
farceur12525273farce_ur
fastener11227833fastener
fattener11268113fattener
gardened1137003gardened
gardeners1136603gardeners
garner73917003gar__ner
greener83111713_greener
hardened1338613hardened
hardeners1338083hardeners
harkened1637483harkened
harkeners1636073harkeners
hastener11259133hastener
hearkener1644213hearkener
heartener1256763heartener
larcenies1147533larcenies
larceny1234853larcen_y
lateener835763lateener
marceller1345153marceller
marcher143912973marc_her
mariner93315993mar_iner
marketer1437383marketer
narceine1046753narceine_
narceines1146583narceines
obscener1244323obscener
pacer96131613pa_c__er
pacier105018683pa_c_ier
packer144223403pa_c_ker
palterer102411283palterer
pamperer14228333pamperer
panderer112210913panderer
pangene102711963pangene_
pangenes112612823pangenes
panner84224763pa__nner
paperer113111903pa_perer
parader103914863par_ader
parameter1349123parameter
parcel103915473parc__el
parcelled1445783parcelled
parcels113712663parce_ls
parched154013693parc_hed
parches143720003parc_hes
pardee93922023parde_e_
pardine103616723pardine_
pardners11269193par_dners
pardoned12189333pardoned
pardoners12208213pardoners
parent83230423par_en_t
parented11912213par_ented
parents93418123par_ents
parer75839903par___er
pareses94718883par_eses
pareve114613013par_eve_
pargeted1238683pargeted
parietes10714543parietes
parker124121373par__ker
parleyed1436243parleyed
parleyers1444703parleyers
parrier93717653par_rier
parroter1058203parroter
parser84822373par__ser
partaker1436873partaker
parterre1036993parterre
partier93520713par_tier
partners102711133par_tners
partyer12337873par_tyer
parvenu1247023parven_u
parvenue1344923parvenue
parvenues1444643parvenues
parvenus1335653parvenus
passenger1243413passenger
patcher143515143patc_her
patchier15319663patchier
patienter1145553patienter
pattened11299393pattened
patterer103112173patterer
pawner114212923pa__wner
perceiver1644553perceiver
percent113520603percen_t
percents122713373percents
percher143313423perc_her
pilsener1044753pilsener
porcine11312843porcine_
prawner1246803p_rawner
preened103214993p_reened
preeners102712813p_reeners
prefer113813203p_r_efer
preyer114413733p_r_eyer
pruner83413453p_r_uner
pyrene113210733pyr_ene_
pyrenes123511223pyr_enes
rattener8238533rattener
ravener104110743ra_vener
sarcenets1146953sarcenets
sarsenet8412943sarsenet
screener1037573screener
serener73415763ser_ener
sharpener1444583sharpener
sorcerer1036433sorcerer
wakener1446913wa_kener
warner93717223war__ner
warreners1236193warreners
yarner93313063yar__ner

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621497.40619735.6
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.92222556.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.