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

519 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
pardner1023947(None) 
pardners11269191pardners
pardoner11189441pardoner
partner92811391partner
carder94524182card_er
darner74017302dar_ner
earner63617222ear_ner
gardener1037102gardener
garner73917002gar_ner
hardener1238882hardener
harder105022402hard_er
hardier114721542hardier
larder73720972lard_er
lardier83518342lardier
mariner93315992mariner
padder103415492pa_dder
paddler113711552paddler
pander93725522pand_er
panner84224762pa_nner
parader103914862parader
parcener1238472parcener
pardee93922022pard_ee
pardie96021442pardie_
pardine103616722pardine_
pardoned12189332pardoned
pardoners12208212pardoners
parer75839902par__er
parker124121372par_ker
parrier93717652parrier
parser84822372par_ser
partier93520712partier
partners102711132partners
partyer12337872partyer
pawner114212922pa_wner
prawner1246802prawner
pruner83413452p_runer
tardier859719992tardier
warder104020272ward_er
warner93717222war_ner
yarder103813972yard_er
yarner93313062yar_ner
adder75419593_a_dder
aider65431133_aid_er
alder65421913_ald_er
aliner65621983_aliner
almner85710723_almner
aproned10311503aproned
archer115016243_archer
ardeb8314523_ard_eb
ardent73022613_ardent
ardor64617863_ard_or
ardour74110903_ardour
arene55329413_arene_
arenes64928393_arenes
arguer74510543_arguer
arider74717743_arider
armer76924443_ar_mer
artier63419733_artier
atoner64817193_atoner
awarder1135893award_er
badder103817513ba_dder
badger105415073ba_dger
balder95318863bald_er
bander93928223band_er
banner84421503ba_nner
barber104419323bar_ber
barde85330773bard_e_
barded105426423bard_ed
bardes95026933bard_es
barer74535803bar__er
barker124822863bar_ker
barkier133814483barkier
barmier114313043barmier
barned95623583bar_ned
barney115314453bar_ney
barnier93213673barnier
baronet91022203baronet
barrener1038333barrener
barrier94017733barrier
barter85525373bar_ter
bawdier13378203bawdier
birder94915493bird_er
boarder103910323board_er
border94419973bord_er
brander103915823brander
branner94212373branner
briner84519043_briner
burdener1136143burdener
burner83819203bur_ner
cadger105013903ca_dger
candler103516593candler
caner75334773ca__ner
canner84625983ca_nner
carded105424903card_ed
carders104820353card_ers
careener1039323careener
career85822243car_eer
carer74942333car__er
carnet84732873car_net
carney115315703car_ney
caroler93816753caroler
carper104923633car_per
carrier93619583carrier
carter84932273car_ter
carver114420143car_ver
copartner1343563copartner
corder94322883cord_er
corner84625623cor_ner
coroner94218203coroner
cradler102910513cradler
curdier103312623curdier
curdler103511563curdler
damner95213433da_mner
dander811222993dand_er
dandier93714573dandier
dandler94414273dandler
darer65230793dar__er
darkener1335993darkener
darker114718693dar_ker
darned85018483dar_ned
darnel74312183dar_nel
darners83815773dar_ners
darter75320363dar_ter
daunder9348893daunder
dawdler12356793dawdler
drainer83012843drainer
droner74717673_droner
earlier72612743earlier
earned74818333ear_ned
earners74016453ear_ners
faddier1237783faddier
fader94421513fa_d_er
fainer94717243fa_iner
fanner94218183fa_nner
farcer115016083far_cer
farded114518953fard_ed
fardel104712593fard_el
farer86733143far__er
farmer115017373far_mer
farrier103514893farrier
farther1348343farther
fawner125910463fa_wner
gadder93714713ga_dder
gainer74117493ga_iner
gander84322763gand_er
garbler104012563garbler
garden84215083gard_en
gardened1137003gardened
gardeners1136603gardeners
gardens93312093gardens
gargler93710263gargler
garners83815983gar_ners
garnet73928413gar_net
garter74420513gar_ter
gaudier938453gaudier
girder84312063gird_er
girdler9227313girdler
grader84919693grad_er
grainer83714063grainer
grander93315873grander
guarder936463guard_er
hander104526433hand_er
handier113817443handier
handler113516163handler
harden105718533hard_en
hardened1338613hardened
hardeners1338083hardeners
hardens113815023hardens
hardies114923233hardies
hardness122411083hardness
hardset113415833hardset
harkener1537573harkener
harmer114719553har_mer
harper115018403har_per
harrier104417753harrier
harsher13310363harsher
herder104516463herd_er
hoarder11329233hoard_er
hurdler113610003hurdler
ironer64216453_ironer
kroner104612573_kroner
ladder84617623la_dder
lader65633723la_d_er
ladler74314933la_dler
lander74028483land_er
landler84113203landler
lanner64920603la_nner
larcener1036493larcener
larded84319093lard_ed
larders83516943lard_ers
larger74417513lar_ger
larine63927043larine_
larker104519243lar_ker
larkier113711523larkier
lauder73815013laud_er
launder8309143launder
learner7319383lear_ner
loriner7511893loriner
madder103515593ma_dder
manner84020513ma_nner
marbler113511673marbler
marcher143912973marcher
marine84230403marine_
mariners103113863mariners
marines93928013marines
marker124420393mar_ker
marlier92614773marlier
marrer83716673mar_rer
marrier93817523marrier
maunder10328683maunder
murder93613783murd_er
nardine82712573nardine_
narine63422553narine_
nerdier83110353nerdier
order65019363_ord_er
pacer96131613pa__cer
pacier105018683pa_cier
packer144223403pa_cker
padded114113503pa_dded
padders113312873pa_dders
paddies113715723paddies
paddle104615143paddle_
paddled123612023paddled
paddlers12329153paddlers
paddles113515643paddles
padle84522343pa_dle_
padles95221123pa_dles
padnag1036073pa_dnag
padre86018163pa_dre_
padres95016983pa_dres
padrone102512073padrone_
padrones112711043padrones
pager84728203pa__ger
pained95622853pa_ined
painter93814563painter
palaver1238753palaver
paler75436933pa__ler
palier85023563pa_lier
pallier94417163pallier
palmer105816543pa_lmer
palmier113312173palmier
palter84423263pa_lter
pamper124316663pa_mper
panderer112210913panderer
panders103423733pand_ers
pandied113913443pandied
pandies104224503pandies
pandoor10358583pandoor
pandore10411853pandore
pandour10408213pandour
pane64950293pa__ne_
paned85437183pa__ned
panel76023623pa__nel
panes76148693pa__nes
panier84425503pa_nier
panne76623653pa_nne_
panned94123433pa_nned
panners93621273pa_nners
pannes85522853pa_nnes
pannier93613353pannier
panther12611443panther
panzer174213233pa_nzer
paper95128663pa__per
paperer113111903paperer
pappier103511593pappier
parade94720643parade_
paraded114014263paraded
paraders113113113paraders
parades104121463parades
parador103311413parador
parae76335703par_ae_
parang93715513paran_g
parangs104314373parangs
paranoea1048553paranoea
parapet11317643parapet
parcel103915473par_cel
parceners1337453parceners
parched154013693parched
parches143720003parches
pard76441323pard___
pardah123412823pard_ah
pardahs13289673pardahs
pardi85723953pard__i
pardon94618733pard_on
pardons103817623pardons
pards85634333pard__s
pardy115523953pard__y
pare66760843par__e_
pared86946763par__ed
parent83230423paren_t
parented11912213parented
parents93418123parents
pareo74632603par__eo
parers85530743par__ers
pares77164483par__es
pareses94718883pareses
pareu74928743par__eu
pareve114613013pareve_
parge85831853par_ge_
parged104922043par_ged
parges94529543par_ges
parget94529393par_get
paries84742513par_ies
paring94236493parin_g
parings104219213parings
parises94827183parises
parked134425143par_ked
parkers133816873par_kers
parle75836163par_le_
parled94626283par_led
parles86334403par_les
parley116718353par_ley
parleyer1335623parleyer
parlor8312673par_lor
parlour937263parlour
parodied1238333parodied
parodies11313693parodies
parole84425253parole_
paroled104217623paroled
parolee94119633parolee
paroles95025883paroles
paronym1437503paronym
parquet18311583parquet
parr65731153par___r
parred95024073par_red
parrel84515983par_rel
parried103615723parried
parriers103612903parriers
parries93925843parries
parroter1058203parroter
parse75236993par_se_
parsec105914483par_sec
parsed96323893par_sed
parsers94118153par_sers
parses85534703par_ses
parsley1247793parsley
parsnip1146323parsnip
partaker1436873partaker
parted94228683par_ted
partied103516553partied
partiers103514243partiers
parties93230863parties
partlet92720363partlet
partnered1244473partnered
partyers13277763partyers
parure8312523parure_
parures9512693parures
parve109824853par_ve_
parvenu1247023parvenu
passer84721033pa_sser
paster85734373pa_ster
pastier94320383pastier
patcher143515143patcher
pater74740723pa__ter
patine85328123patine_
patined105114783patined
patines95225763patines
patter84628263pa_tter
patzer173111643pa_tzer
pauper103511943pa_uper
pauser84415963pa_user
pavane114113443pavane_
pavanes123612653pavanes
paver104225833pa__ver
paviser12489093paviser
pawer104422973pa__wer
pawkier16236613pawkier
pawned124513283pa_wned
pawnee113115403pa_wnee
pawners124311073pa_wners
pawnor11357243pa_wnor
payer105125723pa__yer
pearler9310373pear_ler
pearlier1037323pearlier
pearter9412743pear_ter
peddler113210493peddler
pedler93614613p_edler
penner84616663p_enner
percher143313423percher
perdie94718513perdie_
perdue93912633perdue_
perdues103511333perdues
perdure10379623perdure
perinea9313033perinea
perkier133813123perkier
perter84422283per_ter
peruser93511373peruser
piddler112911523piddler
pilsner935343pilsner
pinder94523453pind_er
pinner84521503p_inner
plainer93811983plainer
planer84122653p_laner
planner93511623planner
pledger11359153pledger
plodder1146003plodder
plunder103810493plunder
polder94019253pold_er
ponder94521693pond_er
porker124917543por_ker
porkier133712343porkier
pornier93413133pornier
porter84224413por_ter
pounder103313993pounder
powder123611903powd_er
praiser93413943praiser
prancer113613383prancer
prater84825353p_rater
prawned1346743prawned
prawners1346003prawners
prayer114815293p_rayer
preener93114833preener
prefer113813203p_refer
preyer114413733p_reyer
pricer103918293p_ricer
prier75027763p_r_ier
primer105118683p_rimer
prinker133412743p_rinker
printer93917303p_rinter
prizer174714883p_rizer
prober104516073p_rober
prodder1147953prodder
prone75332623p_rone_
proper104319953p_roper
proser84223463p_roser
prover113819723p_rover
prower114218123p_rower
prune75119633p_rune_
pruned93413113p_runed
pruners93710723p_runers
prunes83419063p_runes
pryer104415313p_r_yer
puddler112910753puddler
punner84918153p_unner
purer75127903pur__er
purfler12248733purfler
purger94717233pur_ger
purine85321893purine_
purines94420763purines
purpler11289263purpler
purser85020473pur_ser
pursier94012753pursier
pursuer9338893pursuer
purtier93214093purtier
pyrene113210733pyrene_
pyrenes123511223pyrenes
pyrone112714473pyrone_
pyrones123113303pyrones
raider74318743raid_er
randier83618473randier
rarer54731703rar__er
ravener104110733ravener
sadder82916973sa_dder
saddler93811963saddler
sander74828533sand_er
sandier84017843sandier
saner54334323sa__ner
sardar73013173sard_ar
sardine83317393sardine_
sardined10268663sardined
sardines92815563sardines
sarkier113413313sarkier
sarsnet7314813sarsnet
serener73415753serener
sorner64720393sor_ner
spader94317133spa_d_er
spanner94312563spa_nner
sparer84524963spar__er
sparger103613083spar_ger
sparker133914363spar_ker
sparkier14298033sparkier
sparkler14317983sparkler
sparrier10329143sparrier
sparser94311483spar_ser
spawner12347363spa_wner
spurner9269653spur_ner
tanner63722283ta_nner
tardies84225863tardies
tarrier74323173tarrier
tarsier74119253tarsier
tarter64023563tar_ter
tartier74123263tartier
trader75218763trad_er
trainer73316793trainer
turner63914613tur_ner
vainer93714573va_iner
vanner94215843va_nner
varier94619353var_ier
wadder114215483wa_dder
waddler124010793waddler
wader95325363wa_d_er
wagoner1136093wagoner
wakener1446913wakener
wander104423713wand_er
wanner94019623wa_nner
warbler123211463warbler
warded115021043ward_ed
warden104515513ward_en
wardenry1542973wardenry
wardens113711903wardens
warders113416813ward_ers
warier93722893war_ier
warmer113816733war_mer
warned104018913war_ned
warners103315563war_ners
warper114015583war_per
warrener1136913warrener
warsler10289893warsler
wartier103413913wartier
wordier112511213wordier
yarded114714023yard_ed
yarders113211593yard_ers
yardmen1335423yardmen
yarer84321573yar__er
yarned105514023yar_ned
yarners104312203yar_ners
yawner12428473ya_wner
yearner10336873year_ner
zander163417113zand_er

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340275196.92319359.7
3Display Results5195190.1862790.3
 (SQL Overall)1786915197.26224606.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.