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

399 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
pardners1126919(None) 
pardner10239471pardner_
pardoners12208211pardoners
partners102711131partners
carders104820352card_ers
darners83815772dar_ners
earners74016452ear_ners
gardeners1136602gardeners
garners83815982gar_ners
hardeners1338082hardeners
hardness122411082hardness
larders83516942lard_ers
mariners103113862mariners
padders113312872pa_dders
paddlers12329152paddlers
panders103423732pand_ers
panners93621272pa_nners
paraders113113112paraders
parceners1337452parceners
pardoner11189442pardoner_
parers85530742par__ers
parkers133816872par_kers
parriers103612902parriers
parsers94118152par_sers
partiers103514242partiers
partner92811392partner_
partyers13277762partyers
pawners124311072pa_wners
prawners1346002prawners
pruners93710722p_runers
warders113416812ward_ers
warners103315562war_ners
yarders113211592yard_ers
yarners104312202yar_ners
adders84315703_a_dders
aiders74524633_aid_ers
alders74218423_ald_ers
aliners74717723_aliners
almners9399563_almners
apartness1146053apartness
archers124414573_archers
ardebs937013_ard_ebs
ardors74416863_ard_ors
ardours8368873_ardours
arenes64928393_arene_s
arguers8489023_arguers
aridness939223_aridness
armers85520273_ar_mers
atoners75013953_atoners
awarders1245073award_ers
badgers114812643ba_dgers
badness1039573ba_dness
baldness1137043baldness
banders104324563band_ers
banners94018713ba_nners
barbers114317503bar_bers
bardes95026933bard_e_s
bareness10912813bareness
barkers134318513bar_kers
barneys12569563bar_neys
baroness101210063baroness
baronets101410903baronets
barriers104311883barriers
barters94223033bar_ters
birders103913263bird_ers
boarders11408623board_ers
borders104317533bord_ers
branders114313093branders
branners104010923branners
briners94315633_briners
burdeners1245063burdeners
burners94115673bur_ners
cadgers114711993ca_dgers
candlers114214103candlers
caners84629193ca__ners
canners93822663ca_nners
carder94524183card_er_
careeners1138533careeners
careers95218783car_eers
carers85133953car__ers
carnets93918403car_nets
carneys124310543car_neys
carolers103314173carolers
carpers114521253car_pers
carriers103614203carriers
carters95327243car_ters
carvers124817533car_vers
copartners1443573copartners
corders104520873cord_ers
corners94723313cor_ners
coroners104016223coroners
cradlers11309183cradlers
curdlers11368493curdlers
damners104112113da_mners
danders93921183dand_ers
dandlers103912053dandlers
darers75921873dar__ers
darkeners1435153darkeners
darkness13247343darkness
darnels83710433dar_nels
darner74017303dar_ner_
darters84017603dar_ters
daunders10278473daunders
dawdlers13375673dawdlers
drainers92811253drainers
droners84114383_droners
earner63617223ear_ner_
faders105117463fa_d_ers
fanners103914653fa_nners
farcers124713443far_cers
fardels11389893fard_els
farers95924053far__ers
farmers124315263far_mers
farness102912203far_ness
farriers113610743farriers
fawners13388493fa_wners
gadders103611503ga_dders
gainers84214593ga_iners
ganders93521703gand_ers
garblers113810283garblers
gardener1037103gardener_
gardens93312093gard_ens
garglers10418263garglers
garner73917003gar_ner_
garnets84115403gar_nets
garters84218223gar_ters
girders9379943gird_ers
girdlers10195403girdlers
graders94715993grad_ers
grainers93012073grainers
guarders1035873guard_ers
handers114224333hand_ers
handlers124014143handlers
hardener1238883hardener_
hardens113815023hard_ens
harder105022403hard_er_
hardier114721543hardier_
hardies114923233hardie_s
hardiness132310353hardiness
harkeners1636073harkeners
harmers124116593har_mers
harness102413933har_ness
harpers124916203har_pers
harriers113712433harriers
herders113914123herd_ers
hoarders12307433hoard_ers
hurdlers12337493hurdlers
ironers74813543_ironers
ladders94115173la_dders
laders74927763la_d_ers
ladlers84613563la_dlers
landers84026213land_ers
landlers94312833landlers
lanners73618323la_nners
larceners1135993larceners
larder73720973lard_er_
lardier83518343lardier_
larkers113014513lar_kers
lauders84012893laud_ers
launders9358743launders
learners8398153lear_ners
loriners839963loriners
madders113513213ma_dders
madness10310073ma_dness
manners93417833ma_nners
marblers12319233marblers
marchers153710813marchers
mariner93315993mariner_
marines93928013marine_s
markers133516103mar_kers
marrers93414313mar_rers
marriers103312473marriers
maunders11348343maunders
murders103311363murd_ers
orders74315993_ord_ers
pacers105124543pa__cers
packers153818893pa_ckers
packness1636933packness
padder103415493pa_dder_
paddies113715723paddie_s
paddler113711553paddler_
paddles113515633paddle_s
padles95221113pa_dle_s
padnags1135083pa_dnags
padres95016983pa_dre_s
padrones112711043padrone_s
pagers94423253pa__gers
painters103013023painters
palavers1337993palavers
paleness10312983paleness
palmers113513623pa_lmers
palters94021683pa_lters
pampers133615933pa_mpers
pander93725523pand_er_
panderers12229153panderers
pandies104224503pandie_s
pandoors11258983pandoors
pandores11312453pandores
pandours11317983pandours
panels84716523pa__nels
panes76148693pa__ne_s
paniers94717333pa_niers
panner84224763pa_nner_
pannes85522853pa_nne_s
panniers10488853panniers
panthers13510783panthers
panzers184012013pa_nzers
paperers122410453paperers
papers105125323pa__pers
parader103914863parader_
parades104121463parade_s
paradores12259653paradores
paradors113411893paradors
parangs104314373paran_gs
paranoeas1147513paranoeas
parapets1239763parapets
parcels113712663par_cels
parcener1238463parcener_
parches143720003parche_s
pardahs13289673pard_ahs
pardee93922023pard_e_e
pardie96021443pardie__
pardine103616723pardine__
pardoned12189333pardone_d
pardons103817623pard_ons
pards85634333pard___s
parents93418123paren_ts
pareos87023773par__eos
parer75839903par__er_
pares77164483par__e_s
pareses94718873parese_s
pareus85420743par__eus
parges94529543par_ge_s
pargets105215193par_gets
paries84742513par_ie_s
parings104219213parin_gs
parises94827183parise_s
parker124121373par_ker_
parles86334393par_le_s
parleyers1444683parleyers
parleys125212373par_leys
parlors9312913par_lors
parlours1036153parlours
parodies11313693parodie_s
parolees104313973parolees
paroles95025883parole_s
paronyms1546553paronyms
parquets1936413parquets
parrels94713493par_rels
parrier93717653parrier_
parries93925843parrie_s
parroters1156763parroters
parrs75928673par___rs
parsecs11429913par_secs
parser84822373par_ser_
parses85534703par_se_s
parsleys1335083parsleys
parsnips1245533parsnips
partakers1536563partakers
partier93520713partier_
parties93230863partie_s
partlets102811513partlets
partnered1244473partnered
partyer12337873partyer_
parures9512693parure_s
parvenus1335653parvenus
passers94717753pa_ssers
pasters94531733pa_sters
pastness102510503pastness
patchers153413303patchers
paters84935823pa__ters
patines95225763patine_s
patness92912283pa_tness
patroness1137483patroness
patters94825193pa_tters
patzers184210573pa_tzers
paupers114311073pa_upers
pausers94113223pa_users
pavanes123612653pavane_s
pavers115021823pa__vers
pavisers13387443pavisers
pawers114818783pa__wers
pawnees12298173pa_wnees
pawner114212923pa_wner_
pawnors12297203pa_wnors
payers114621823pa__yers
pearlers1039023pear_lers
peartness1137773peartness
peddlers12298533peddlers
pedlers103013273p_edlers
penners93414183p_enners
perchers153611523perchers
perdues103511333perdue_s
perdures11289683perdures
pertness10310093pertness
perusers10328803perusers
piddlers12359593piddlers
pilsners1035533pilsners
pinders103720473pind_ers
pinners93518593p_inners
planers94517943p_laners
planners10399933planners
pledgers12387643pledgers
plodders1235523plodders
plunders11329823plunders
polders103617373pold_ers
ponders103618843pond_ers
porkers134314933por_kers
porters93722703por_ters
pounders113113263pounders
powders134111553powd_ers
praisers103410833praisers
prancers123210333prancers
praters94921643p_raters
prawner1246803prawner_
prayers124212853p_rayers
preeners102712813preeners
prefers123713333p_refers
preyers124412363p_reyers
pricers113915063p_ricers
priers84521193p_r_iers
primers114215673p_rimers
prinkers143010383p_rinkers
printers103214903p_rinters
prizers183911843p_rizers
probers113514573p_robers
prodders1237453prodders
propers113619033p_ropers
prosers94219643p_rosers
provers123817793p_rovers
pruner83413453p_runer_
prunes83419063p_rune_s
pryers115012243p_r_yers
puddlers12298683puddlers
punners94114233p_unners
pureness101110183pureness
purflers13216963purflers
purgers104714003pur_gers
purines94420763purine_s
pursers93916093pur_sers
pursuers10376523pursuers
pyrenes123511223pyrene_s
pyrones123113303pyrone_s
raiders84615143raid_ers
rareness81112853rareness
raveners11309123raveners
saddlers10289753saddlers
sadness8310613sa_dness
sanders84025943sand_ers
sardars83112903sard_ars
sardines92815563sardine_s
sarsnets836783sarsnets
sorners73416863sor_ners
spaders104214473spa_d_ers
spanners103710773spa_nners
spareness1139863spareness
sparers94519613spar__ers
spargers11389733spar_gers
sparkers144111313spar_kers
sparklers15315633sparklers
spawners13396493spa_wners
spurners10288493spur_ners
tanners74018393ta_nners
tardier859719993tardier_
tardies84225863tardie_s
tardiness10229913tardiness
tarriers83411713tarriers
tarsiers8298533tarsiers
tartness82210133tartness
traders84316943trad_ers
trainers83114633trainers
turners73912893tur_ners
upwardness1642653upwardness
vanners103612843va_nners
variers103712663var_iers
wadders123812443wa_dders
waddlers13298333waddlers
waders109120643wa_d_ers
wagoners1235463wagoners
wakeners1535843wakeners
wanders114221333wand_ers
warblers13319103warblers
wardenry1542973wardenry
wardens113711903ward_ens
warder104020273ward_er_
wardless12249303wardless
wardress12256163wardress
wariness11313213wariness
warmers124514293war_mers
warmness1337063warmness
warner93717223war_ner_
warpers123413583war_pers
warreners1236193warreners
warslers11328073warslers
yarder103813973yard_er_
yarner93313063yar_ner_
yawners13367183ya_wners
yearners11346373year_ners
zanders173015793zand_ers

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.1561145455.1
2DLD Change Limit1461623996.93621073.0
3Display Results3993990.1562557.7
 (SQL Overall)1786913997.24824653.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.