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

412 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
pariahs12381234(None) 
pardahs13289671pardahs
pariah114320581pariah_
parians93519731parians
arias55438022_aria_s
jarrahs1735452jarrahs
lariats7615052lariats
paraphs1439312paraphs
paras76143042par_a_s
pardah123412822pardah_
parian83223962paria_n
paries84742512pari_es
parings104219212parings
paris75145942pari__s
parises94827182parises
parish115022352parish_
parishes13314752parishes
parkas125018022parka_s
parlays123910452parlays
parrals94414572parrals
partans94418282partans
partials101911952partials
purdahs13285482purdahs
shariahs14206392shariahs
varias95019902varia_s
aahs716428563_a__ahs
aerials74017553aerials
agrias74315393agria_s
airths95414253_airths
alias55834603_alia_s
aliyahs13395323_aliyahs
almahs118611613_almahs
amahs107819063_a_mahs
amias75831473_amia_s
apiarians1146653apiarians
aporias9315153aporia_s
araks94820883_ar_aks
areas55935773_area_s
argals75517713_argals
arhats9312973_arhats
aria46245423_aria__
ariary94114203_ariary
ariels65119373_ariels
aright103817663_aright
arils58732203_ari_ls
arises65233803_arises
arras55626133_arra_s
arrays95311683_arrays
avians93711563_avians
ayahs116813523_a_yahs
banians9312033banians
barcas101016603barca_s
barites94322333barites
bariums1139143bariums
briars84814823_briars
briths115113863_briths
burials93612083burials
caliphs1436753caliphs
capias10318353capia_s
carats85929023car_ats
carcass11310513carcass
cardiacs1376913cardiacs
cardias10715113cardia_s
caribes113715643caribes
carices114220953carices
caries85147623cari_es
carinas93622403carinas
carious93320283carious
caritas93316953caritas
carpals113414623carpals
carwash1535993carwash
casbahs1436463casbahs
caviars1238623caviars
cerias83321983ceria_s
ceriphs1484753ceriphs
darbars10510093darbars
darics94314113dari_cs
darings93713653darings
durians839573durians
earings84517713earings
earlaps936393earlaps
earths95014593ear_ths
eparchs14196243epar_chs
facials123310743facials
facias113415803facia_s
faiths124610273fa_iths
farads104713273far_ads
farfals13268503farfals
farinas103215233farinas
farinha13357063farinha
farinhas14325363farinhas
ferias95020393feria_s
friars93812093_friars
friths124313583_friths
galahs105512673ga_lahs
ganjahs18104003ganjahs
garish104516923garish_
garths104111503gar_ths
gavials1136603gavials
gerahs1039413ger_ahs
gharials1245123gharials
griths105211653_griths
hadiths1436023hadiths
hallahs133912463hallahs
halvahs16417533halvahs
hamzahs24134373hamzahs
harass9313943har_ass
hardass1139753hardass
hariana10310243hariana
harianas1139163harianas
harijans1845723harijans
hartals10313023hartals
horahs126313873hor_ahs
hurrahs13336773hurrahs
jarinas143712183jarinas
jarrah1636683jarrah_
kaiaks937043ka_iaks
kalians11310183kalians
kaliphs1634293kaliphs
karats106420493kar_ats
karmas123013733karma_s
kasbahs1634363kasbahs
labials9299873labials
laichs115110893la_ichs
laighs10508803la_ighs
lamias85020613lamia_s
lariat6629043laria_t
laris54737463lari__s
larvas9310233larva_s
latrias71913213latria_s
mafias113913573mafia_s
magians10310753magians
maniacs114313063maniacs
manias84029033mania_s
maras75443283mar_a_s
margays1337493margays
maria75032883maria__
mariachi1544493mariachi
mariachis1644703mariachis
marinas93519383marinas
marines93928013marines
marish114319053marish_
marishes13512553marishes
markas124717003marka_s
marrams11310123marrams
martians103111613martians
matsahs1236563matsahs
matzahs2134483matzahs
myriads1334353myriads
naiads739013na_iads
nairas6312783naira_s
narial6317953naria_l
naris55735293nari__s
narwals1036983narwals
norias65518203noria_s
pacas96029403pa_ca_s
pachas135017143pacha_s
padis86227143padi__s
padishahs1841663padishahs
padnags1135083padnags
padshahs17113153padshahs
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
pagings114411063pagings
pagurians1243393pagurians
paiks114719853pa_i_ks
pails75833063pa_i_ls
pains75138283pa_i_ns
paints85921833pa_ints
pairings11398313pairings
pairs75325833pa_i_rs
paisans93614753paisans
paisas84317493pa_isas
pakehas1635313pakehas
palais8420423pa_lais
palikars1445083palikars
palings103915823palings
palish114718273palish_
pampas124913993pampa_s
pandas95521963panda_s
pangas99921103panga_s
panics103815363pani_cs
paniers94717333paniers
papains11312363papains
papas94927493pa_pa_s
papaws13419113pa_paws
paphians1545593paphians
papisms13238543papisms
papists112110453papists
papricas1447053papricas
paprikas1643853paprikas
para65242173par_a__
parade94720643par_ade
parades104121463parades
parados103816053parados
parae76335703par_a_e
paramo102614643par_amo
paramos113213513paramos
parang93715513par_ang
parangs104314373parangs
paraph13311263par_aph
parashahs1744743parashahs
parbake1538353parbake
parbakes1638343parbakes
parcels113712663parcels
parch125123003par_ch_
parches143720003parches
pardons103817623pardons
pards85634333par__ds
pareiras1038183pareiras
parents93418123parents
pareos87023773par_eos
parers85530743par_ers
pares77164483par__es
pareses94718883pareses
paresis93315093paresis
pareus85420743par_eus
parfait12312053parfait
parfaits1346913parfaits
parges94529543par_ges
pargets105215193pargets
pargings123410163pargings
pargos95719043par_gos
parietals1146863parietals
parietes10714543parietes
paring94236493pari_ng
parities10522973parities
parity114719873pari_ty
parka115120883parka__
parkade1437583parkade
parkades1538273parkades
parkers133816873parkers
parkings153610683parkings
parks116134463par__ks
parkways2043973parkways
parlay113713993parla_y
parles86334403par_les
parleys125212373parleys
parlors9312913parlors
parlous9414293parlous
parodos103011753parodos
paroles95025883paroles
parols84722613par_ols
parous84024163par_ous
parral85517533parra_l
parrels94713493parrels
parriers103612903parriers
parries93925843parries
parrots9312743parrots
parrs75928673par__rs
pars67560793par___s
parsecs11429923parsecs
parsers94118153parsers
parses85534703par_ses
parsons93516873parsons
partake1339643partake
partakes1449923partakes
partan83820563parta_n
partial92616263partia_l
partiers103514243partiers
parties93230863parties
partings113513733partings
partisans1167483partisans
partitas10310253partitas
partizans2055243partizans
partons94620513partons
parts77743373par__ts
paruras9310533paruras
parures9512693parures
parvis116114803par_vis
parvises133911913parvises
parvos116614753par_vos
pascals11610013pascals
pashas115117063pasha_s
pastas85422873pasta_s
paths105521383pa__ths
patinas96318523patinas
patines95225763patines
patins87528783pati_ns
patios85221783pati_os
patriarchs1752303patriarchs
patriate10311933patriate
patriates11311363patriates
patriots1038053patriots
pavans115715593pa_vans
pavings134011633pavings
pavins114919663pavi_ns
paviors1237603paviors
pavis106422733pavi__s
pavises125315493pavises
pawpaws1732823pawpaws
paydays1634433paydays
pearlash1344133pearlash
perhaps1446123perhaps
perianths1445473perianths
periapt11313413periapt
periapts1237273periapts
perils84121853peri_ls
periods10312243periods
peris75537073peri__s
perish114619063perish_
perishes13313753perishes
peritus9311803peritus
pharaohs1644493pharaohs
phials1158873p_hials
phreaks1634543phreaks
pians75126963p__ians
pias66542553p__ia_s
piths105817543p__iths
pleiads1045223pleiads
porisms113713453porisms
portals94015563portals
praams10459643p_raams
prahu105013973p_r_ahu
prahus11458243p_r_ahus
praises94121103praises
prams96125513p_r_ams
praos74923563p_r_aos
prats76333393p_r_ats
praus74621753p_r_aus
prays105022433p_r_ays
priapi1037923p_riapi
priapus1134353p_riapus
prices104524543p_rices
pricks144414263p_ricks
prides94324183p_rides
priers84521193p_riers
pries74339533p_ri_es
prigs85219703p_ri_gs
prills84015613p_rills
primas104418103p_rimas
primes104225263p_rimes
primos104514423p_rimos
primps124711823p_rimps
prims95425933p_ri_ms
primus103712173p_rimus
prinks124315383p_rinks
prints84320103p_rints
prions84317783p_rions
priors83914483p_riors
prises84133173p_rises
prisms104915503p_risms
priss74623893p_ri_ss
prizes173819813p_rizes
proas75028803p_roa_s
pujahs18404943p_ujahs
punkahs16284783punkahs
purdah12288753purdah_
purdas92612263purda_s
purines94420763purines
purins83722653puri_ns
puris75332023puri__s
purisms114110833purisms
purists94014073purists
puritans1037633puritans
pyrans11411063pyr_ans
pyrites12812203pyrites
pyurias1236713pyuria_s
radials83614633radials
radians83013823radians
raias54631123ra_ia_s
rajahs16497663ra_jahs
rayahs12579193ra_yahs
rials55026673__rials
rias45540593__ria_s
rupiahs1253333rupiahs
sarans64224433sar_ans
sardars83112903sardars
sarins63932623sari_ns
saris54544953sari__s
sarsars73512143sarsars
saurians837763saurians
serials73919743serials
shariah132210533shariah_
sharias102516003sharia_s
sirrahs10377303sirrahs
sparids103512123spari_ds
surahs94515543sur_ahs
tafias93111963tafia_s
tariffs1334593tariffs
tarmacs1138323tarmacs
tarpans92513533tarpans
tarsals72512603tarsals
tarsias74013373tarsia_s
tartans72615823tartans
tartars73313403tartars
tarzans16329923tarzans
torahs95115643tor_ahs
triacs83913223_triacs
triads74513533_triads
trials64319883_trials
urials64415193_urials
varas86028193var_a_s
varia85824203varia__
variant10316803variant
variants1139203variants
variate101316433variate
variates111214983variates
varices123313573varices
variers103712663variers
varies94330873vari_es
various103113103various
varnas94212823varna_s
wallahs13409473wallahs
warmths1583783warmths
warpaths1643973warpaths
warsaws1335763warsaws
wraiths1355033wraiths
zamias174212923zamia_s
zaptiahs2242063zaptiahs
zaribas1836043zaribas

Search took 7 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.410435831.7
2DLD Change Limit1340274126.31021240.4
3Display Results4124120.1402942.9
 (SQL Overall)1786914126.86026048.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.