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

215 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
partials10191195(None) 
partial92616261partial_
hartals10313022hart_als
martial92415412martial_
martians103111612martians
pariahs123812342par_iahs
parians93519732par_ians
parrals94414572par_rals
partans94418282part_ans
partially1449032partially
partible1238062partible
particle1239532particle
particles1339802particles
partiers103514242partiers
parties93230862parti_es
partings113513732partings
partisans1167482partisans
partitas10310252partitas
partizans2055242partizans
pastils94416172pasti_ls
portals94015562port_als
tertials8510072tertials
aerials74017553_aerials
antiars7314623_antiars
argals75517703_ar_gals
argils75213623_argi_ls
arias55438023_ar_ia_s
ariels65119373_ar_iels
arils58732203_ar_i_ls
arrivals1145933_arrivals
artal55525473_art_al_
artels66216233_art_els
arterials949683_arterials
article9310923_article
articles10310243_articles
artily92814713_arti_ly
artisans888523_artisans
artists74215583_artists
astrals75515243_astrals
atrial65418943_atrial_
barbitals1345253barbitals
bartisans1165553bartisans
bartizans2053703bartizans
burials93612083bur_ials
cantals93919573cant_als
capitals12209443capitals
caracals12310743caracals
cardiacs1376903cardiacs
cardias10715093cardia_s
cardinals1247983cardinals
caritas93316943carita_s
carnivals1444483carnivals
carpals113414623car_pals
cartels94618123cart_els
cattails1038553cattails
cordials1139603cordials
curtails10318243curtails
curtals93111623curt_als
facials123310743fa_cials
fantails1139693fantails
farfals13268503far_fals
fetials103711743_fetials
gavials1136603ga_vials
gharials1245123ghar_ials
hartal9415473hart_al_
impartial1345183impartial_
initials848103initials
kartings13418523kartings
labials9299873la_bials
lacteals1095663lacteals
lanitals837723lanitals
lariats7615053lar_iats
latrias71913213latria_s
marginals1245993marginals
marital92314183marital_
marshals1337783marshals
martially1448173martially
martian93514683martia_n
martingals1343313martingals
martinis103311613martinis
martins93322063marti_ns
mortals93914003mort_als
narial6317953nar_ial_
narwals1036983nar_wals
narwhals1443613narwhals
nuptials1044303nuptials
pactions122613503pactions
pails75833063pa__i_ls
palatals1037773palatals
palatial10410623palatial_
pallial92911253pallial_
panties94230933panti_es
pantile93918483panti_le
pantiles103617153pantiles
paphians1545593paphians
paras76143043par__a_s
parasails1147583parasails
parasols1039263parasols
parboils1237433parboils
parcels113712663par_cels
pardahs13289673par_dahs
pareiras1038183pareiras
paretics122312443pareti_cs
parfaits1346913parfaits
pargings123410163pargings
pariah114320583par_ia_h
parian83223963par_ia_n
paries84742513par_i_es
parietals1146863parietals
parings104219213par_ings
paris75145943par_i__s
parises94827183par_ises
parities10522973parities
parkas125018023par_ka_s
parkings153610673parkings
parkways2043973parkways
parlays123910453par_lays
parols84722613par__ols
parotids112610413paroti_ds
parotitis1149173parotitis
parral85517533par_ral_
parrels94713493par_rels
parriers103612903parriers
parries93925843parri_es
partake1339643part_ake
partakes1449923partakes
partan83820563part_a_n
partiality1546783partiality
partied103516553parti_ed
partier93520713parti_er
parting103527383parti_ng
partisan1058423partisan
partisanly1543463partisanly
partita9310863parti_ta
partite9317133parti_te
partizan1955643partizan
partlets102811513partlets
partly116315473part__ly
partners102711133partners
partons94620513part_ons
parts77743373part___s
partway1535923partwa_y
partyers13277763partyers
paruras9310533parura_s
parvis116114803parvi__s
parvises133911913parvises
pascals11610013pa_scals
paschals1566473paschals
pastas85422873past_a_s
pastels95215183past_els
pasties94529813pasti_es
pastil85018323pasti_l_
pastille1038943pastille
pastilles1148703pastilles
pastimes123611903pastimes
pastinas103712153pastinas
pastis84924323pasti__s
pastises103616053pastises
pastorals1147953pastorals
patinas96318523pa_tinas
patines95225763pa_tines
patins87528783pa_ti_ns
patios85221783pa_ti_os
patriate10311933patriate
patriates11311363patriates
patriots1038053patriots
patrols93513513pa_trols
patties93425143patti_es
perils84121853per_i_ls
pertains102113413pertains
perusals1047143perusals
petals84719813p_et_als
peytrals1355493peytrals
phials1158873p__hials
pigtails1146033pigtails
pintails10310163pintails
pistils93314303pisti_ls
pluvials1343713pluvials
pontils9312213ponti_ls
portal84218463port_al_
porticos1238373porticos
portions10514393portions
portrays1345293portrays
postals93716373post_als
practicals1645533practicals
pratfall1344153pratfall
pratfalls1443863pratfalls
pretrials1158143pretrials
prills84015613p_r_ills
puritans1037633puritans
radials83614633ra_dials
ramtils938413ramti_ls
ratals64219583ra_t_als
rattails837133rattails
retrials8510823retrials
rials55026673__r_ials
serials73919743ser_ials
spartinas1135793spartinas
spatial9310323spa_tial_
tarsals72512603tar_sals
tarsias74013373tarsia_s
tartans72615823tart_ans
tartars73313403tart_ars
tartily103511573tarti_ly
tertial7313853tertial_
tertians839103tertians
trials64319883_tr_ials
urials64415193_ur_ials
varias95019903var_ia_s
verticals1457233verticals
wagtails1244443wagtails
warrigals1343773warrigals
wartimes1336963wartimes
yautias1046333yautia_s
zaptiahs2242063zaptiahs

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622158.17017890.1
3Display Results2152150.0962239.6
 (SQL Overall)1786912158.43921174.4
 
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.