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

353 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
partial9261626(None) 
martial92415411martial
partials101911951partials
artal55525472_art_al
atrial65418942_atrial
hartal9415472hart_al
impartial1345182impartial
marital92314182marital
martian93514682martian
narial6317952nar_ial
palatial10410622palatial
pallial92911252pallial
pariah114320582par_iah
parian83223962par_ian
parral85517532par_ral
partan83820562part_an
partially1449032partially
partible1238062partible
particle1239532particle
partied103516552partied
partier93520712partier
parties93230862parties
parting103527382parting
partisan1058422partisan
partita9310862partita
partitas10310252partitas
partite9317132partite
partizan1955642partizan
partway1535922partway
pastil85018322pasti_l
portal84218462port_al
spatial9310322spa_tial
tertial7313862tertial
actinal9312293_actinal
actual8311023_actual
aecial84817313_aecial
aerial64625713_aerial
antiar6317173_antiar
antral65719413_antral
aortal65217513aort_al
areal55928733_ar_eal
argal65023393_ar_gal
argil65116883_argi_l
aria46245423_ar_ia_
arias55438023_ar_ias
ariel55228973_ar_iel
aril45843023_ar_i_l
arrival1037563_arrival
artel56122743_art_el
arterial8313633_arterial
artful968273_artful
article9310923_article
artier63419733_artier
artily92814713_artily
artisan759463_artisan
artist64125543_artist
arval86017013_ar_val
astral66919283_astral
atria56022343_atria_
audial7312993_audial
axial124515193_a_xial
barbal104016663bar_bal
barbital1247053barbital
baronial1049483baronial
bartisan1056163bartisan
bartizan1954413bartizan
bestial9311643bestial
burial84117623bur_ial
cambial134010763cambial
cantal84122033cant_al
canthal12410053canthal
capital112311523capital
caracal11312513caracal
cardia9916373cardia_
cardiac1278813cardiac
cardiae10713703cardiae
cardias10715113cardias
cardinal1139563cardinal
carinal94318233carinal
caritas93316953caritas
carnal83919203car_nal
carnival1345613carnival
carotidal1245133carotidal
carpal103716253car_pal
cartel85022533cart_el
carting104228283carting
cattail939183cattail
cordial10312943cordial
cortical12412213cortical
cranial92114683cranial
curial84019153cur_ial
curtail9299663curtail
curtal83914543curt_al
darting94020663darting
datival1135583da_tival
eparchial1644403eparchial
facial113615633fa_cial
factual1246723factual
fantail10310233fantail
farcical1546953farcical
farfal123410183far_fal
farting114120753farting
fascial1258303fascial
fatal84819373fa_t_al
faucial1257323faucial
ferial94621253fer_ial
fetial95716193_fetial
gastral8329553gastral
gavial10310083ga_vial
gharial1137343ghar_ial
haptical1547343haptical
hartals10313023hart_als
hernial10310433hernial
iatrical1049273iatrical
inertial8411723inertial
initial7311883initial
karting123716063karting
labial84714343la_bial
lacteal966813lacteal
lanital7310913lanital
lariat6629043lar_iat
larval948503lar_val
latria62313593latria_
latrias71913213latrias
marginal1137603marginal
maria75032883mar_ia_
marshal1238973marshal
martially1448183martially
martians103111613martians
martin84122523marti_n
marting103325013marting
martingal1244063martingal
martini93613873martini
martins93322063martins
matinal9312603ma_tinal
mortal84616853mort_al
narwal938943nar_wal
narwhal1344333narwhal
nasial6413283na_sial
natal53921493na_t_al
nautical1057703nautical
nuptial946633nuptial
ovarial1037613ovar_ial
paction112713963paction
paginal10269493paginal
pail66141833pa__i_l
palatal9310153palatal
paleal84716673pa_leal
pallia83015593pallia_
palpal104112053pa_lpal
paludal1035683paludal
pantie84326473panti_e
panties94230933panties
pantile93918483pantile
panting104025423panting
papal95820673pa__pal
paphian1437453paphian
papyral1445773papyral
para65242173par__a_
paradisal1246883paradisal
parae76335703par__ae
paras76143043par__as
parasail1049233parasail
parasol939553parasol
parboil1138323parboil
parcel103915473par_cel
pardah123412823par_dah
pardi85723953pardi__
pardie96021443pardi_e
pardine103616723pardine
pareira937533pareira
pareiras1038183pareiras
parental10310943parental
paretic113016673pareti_c
paretics122312443paretics
parfait12312053parfait
parfocal1565393parfocal
parging113318603parging
pariahs123812343par_iahs
parians93519733par_ians
paries84742513par_ies
parietal1048773parietal
paring94236493par_ing
paris75145943par_i_s
parish115022353par_ish
parities10522973parities
parity114719873par_ity
parka115120883par_ka_
parkas125018023par_kas
parking143423043parking
parkway1934553parkway
parlay113713993par_lay
parling103823763parling
parochial1646183parochial
parodical1447563parodical
parol74826273par__ol
parotic112518043paroti_c
parotid102915513paroti_d
parotids112610413parotids
parrals94414573par_rals
parrel84515983par_rel
parried103615723parried
parrier93717653parrier
parries93925843parries
parring103222063parring
parsing103819553parsing
part65967463part___
partake1339643partake
partans94418283partans
parted94228683part_ed
partiality1546783partiality
particles1339803particles
partiers103514243partiers
partings113513733partings
partisanly1543463partisanly
partisans1167483partisans
partizans2055243partizans
partlet92720363partlet
partly116315473part_ly
partner92811393partner
parton84720993part_on
partons94620513partons
partook1337313partook
parts77743373part__s
party106630613part__y
partyer12337873partyer
partying14168893partying
parura8310583parura_
paruras9310533paruras
parvis116114803parvi_s
parvise124211693parvise
pascal10812373pa_scal
paschal14157243paschal
pasta76624533past_a_
pastas85422873past_as
pastel85918713past_el
pastie85525523pasti_e
pastier94320383pastier
pasties94529813pasties
pastille1038943pastille
pastils94416173pastils
pastime114611973pastime
pastina93914593pastina
pastinas103712153pastinas
pasting103826553pasting
pastis84924323pasti_s
pastoral10310483pastoral
pastural1038413pastural
patagial1157173patagial
patin76832853pa_ti_n
patina86022193pa_tina
patinae95414403pa_tinae
patinas96318523pa_tinas
patine85328123pa_tine
patins87528783pa_tins
patio74426353pa_ti_o
patios85221783pa_tios
patriate10311933patriate
patriot9314533patriot
patrol83213023pa_trol
patronal1048653patronal
pattie84020963patti_e
patties93425143patties
patting103722343patting
pausal81511963pa_usal
penial84120893p_enial
pereia85217983pereia_
peridial11411923peridial
peril75425953per_i_l
permian112612283permian
peroral9314793peroral
pertain92714963pertain
perusal939193perusal
petal76526893p_et_al
peytral1287503peytral
phial10313203p__hial
phrasal1246163phrasal
phratral1344373phratral
pial65636703p___ial
pigtail1046623pigtail
pintail9311183pintail
piratical1348663piratical
pistil83915073pisti_l
plastral1046913plastral
pluvial1245433pluvial
poetical12311533poetical
pontil8315463ponti_l
portals94015563port_als
portico11310143portico
porting103021783porting
portion9615493portion
portray1237483portray
postal84317533post_al
practical1548843practical
praedial1178763praedial
prandial1149643prandial
pratfall1344153pratfall
prating103424453prating
predial103815413predial
pretrial10511983pretrial
prill74117943p_r_ill
primal104014623p_rimal
puparial1246313pupar_ial
puritan939283puritan
purtier93214093purtier
pyrexial20234973pyrexial
pyritical1646983pyritical
rachial122012173rachial
racial83419243ra_cial
radial74020393ra_dial
ramtil8311023ramti_l
ratal55025113ra_t_al
rattail737803rattail
retial64724993_retial
retrial7615553retrial
rial45938093__r_ial
sartorial948383sartorial
serial64625863ser_ial
spacial1138763spa_cial
spartan948333spart_an
spartina1037983spartina
spartinas1135793spartinas
spathal1236263spa_thal
tactical1248843tactical
tactual936203tactual
tarnal63716503tar_nal
tarsal63315273tar_sal
tarsia65514273tarsia_
tarsias74013373tarsias
tartan64217513tart_an
tartar63214753tart_ar
tartier74123263tartier
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
tertials8510073tertials
tertian7511193tertian
trial54926353_tr_ial
urial54823023_ur_ial
varia85824203var_ia_
varias95019903var_ias
vatical1239983va_tical
vertical13410433vertical
virtual1045913virtual
vortical1348863vortical
wagtail1145043wagtail
warrigal1244313warrigal
wartier103413913wartier
wartime1237743wartime
yautia937253yautia_
yautias1046333yautias
zaptiah2144293zaptiah
zoarial1646923zoar_ial

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273537.59617644.4
3Display Results3533530.1532307.2
 (SQL Overall)1786913538.15521911.8
 
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.