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

378 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
parishes1331476(None) 
marishes13512551marishes
parises94827191paris_es
perishes13313751perishes
arises65233802_aris_es
banishes131812462banishes
danishes121710492danishes
famishes1658282famishes
garfishes16167082garfishes
garnishes13198812garnishes
lavishes1457402lavishes
marshes123615372mar_shes
oarfishes15156952oarfishes
panfishes1737592panfishes
parches143720002par_ches
pareses94718882pares_es
pariahs123812342pariah_s
paries84742522pari__es
parietes10714552parietes
parish115022352parish__
parities10522982parities
parses85534702par_s_es
parvises133911922parvis_es
pashes115828392pa__shes
pavises125315492pavis_es
pavisses13397102pavisses
perished14310092perished
pharisees1444632pharisees
pishes114722102p__ishes
planishes14138522planishes
polishes13711782polishes
praises94121112prais_es
prises84133172p_ris_es
prisses94816712p_risses
punishes1338112punishes
radishes1269462radishes
ravishes1478042ravishes
tarnishes12188892tarnishes
vanishes141610762vanishes
varnishes15207912varnishes
abashes12510373_abashes
airshed11258533_airshed
airsheds12274963_airsheds
aisles64721143_a_isles
anises64826693_anis_es
apprises12310963appris_es
arches114822043_ar_ches
arise56436433_aris_e_
arisen65316793_aris_en
aristas7413523_aristas
aristos7312383_aristos
arrises71617583arris_es
arses55733873_ar_s_es
arsines73518833_arsines
artistes83213353_artistes
ashes86230613_a__shes
axises134413993_axis_es
babiches1735253babiches
banished14189063banished
banisher13169183banisher
banishers14258053banishers
baristas1039723baristas
barites94322333bari_tes
bashes115631393ba__shes
batfishes1746583batfishes
batistes1039713batistes
boarfishes1844973boarfishes
braises93818873brais_es
brashes124518463_brashes
brises84927613_bris_es
brisses94314313_brisses
brushes124014663_brushes
burnishes1436643burnishes
calashes13310543calashes
caliches153812273caliches
camises114218463camis_es
caresses10314063caresses
caribes113715643cari_bes
carices114220953cari_ces
caries85147623cari__es
carioles10817083carioles
caroches15710693caroches
carses85233653car_s_es
carwashes1745783carwashes
cashes114729883ca__shes
catfishes1746303catfishes
cerises94722253ceris_es
cherishes1767563cherishes
crashes124618403_crashes
crises84529433_cris_es
crushes124215133_crushes
cuishes122810823_cuishes
daises74318983da_is_es
daisies84217093da_isies
darioles9710703darioles
dashes106124983da__shes
dervishes1644933dervishes
dishes104622653__dishes
earaches13411313earaches
enriches1337263enriches
evanishes1545603evanishes
famished1766023famished
farinhas14325373farinhas
farsides1237993farsides
fashes124524023fa__shes
fetishes1437153fetishes
finishes1438983finishes
fishes125221343__fishes
fraises104215693frais_es
freshes133515823_freshes
frisees104411693_frisees
frises94124273_fris_es
furbishes1745243furbishes
furnishes1536233furnishes
galoshes1236913galoshes
gamashes1456953gamashes
garigues1034963garigues
garish104516923garish__
garishly1545693garishly
garishness1445763garishness
garnished14196143garnished
garnishee13185763garnishee
garnishees14184173garnishees
garnisher13195853garnisher
garnishers14174863garnishers
gashes105725153ga__shes
girshes11248293gir_shes
gurshes112210033gur_shes
hagfishes1945153hagfishes
harasses11311033harasses
harissas1145983harissas
harshen1339283har_shen
harshens1437603har_shens
harsher13310363har_sher
harshest14310193har_shest
hashes125024803ha__shes
hashishes1444393hashishes
inrushes1136273inrushes
irises64221173_iris_es
kaddishes1844093kaddishes
karosses1236493karosses
knishes1438263_knishes
krises105016083_kris_es
lapises93513463lapis_es
larches124416453lar_ches
lashes94831003la__shes
lavashes1445573lavashes
lavished1555133lavished
lavisher1445083lavisher
lavishers1564643lavishers
lavishest1554883lavishest
lorises73918593loris_es
marches143921173mar_ches
marines93928033mari_nes
marish114319053marish__
marses84827113mar_s_es
mashes115030003ma__shes
mavises122812993mavis_es
merises93421423meris_es
minishes13310583minishes
monishes13311483monishes
nourishes12116733nourishes
onrushes1135213onrushes
orishas1036473_orishas
orrises71312233orris_es
pacifies15311233pacifies
padishah1742483padishah
padishahs1841663padishahs
painches1588923painches
paisans93614753pa_isans
paisas84317493pa_is_as
paise75028333pa_is_e_
paisley1235553pa_isley
paisleys1333353pa_isleys
palisades1245613palisades
palish114718273palish__
palsies94420273pa_lsies
panaches15310293panaches
panicles121010123panicles
panoches1548123panoches
pansies94521983pa_nsies
papisms13238543papis_ms
papists112110453papis_ts
parables121613573parables
parades104121473par_ades
paradises122513213paradis_es
paraphs1439313paraph_s
parashah1646453parashah
parashahs1744743parashahs
parashot13410143parashot
parasites11313163parasites
parasols1039273parasols
parbakes1638343parbakes
parched154013693par_ched
parchesi15358213par_chesi
pardahs13289673pardah_s
pares77164483par___es
paresis93315093pares_is
parfleshes1842973parfleshes
parges94529543par__ges
pariah114320583pariah__
parians93519743pari_ans
parings104219223pari_ngs
paris75145943pari___s
parkades1538273parkades
parles86334413par__les
parodies11313693parodies
parolees104313993parolees
paroles95025893par_oles
parridges1384563parridges
parries93925853par_ries
parritches1743233parritches
parse75236993par_s_e_
parsec105914483par_s_ec
parsecs11429923par_secs
parsed96323893par_s_ed
parser84822373par_s_er
parsers94118153par_sers
parsley1247803par_sley
parsleys1335093par_sleys
parsons93516873par_sons
partakes1449923partakes
particles1339813particles
parties93230873par_ties
partisans1167493partisans
parures9512693par_ures
parvise124211693parvis_e_
pases75346503pa__s_es
pashas115117063pa__shas
pashed125923143pa__shed
passes86030473pa__sses
passives13228823passives
pastes85233913pa__stes
pastiches1637453pastiches
pastises103616053pastis_es
patches143320383pa_tches
patines95225773pati_nes
patriates11311363patriates
patsies93919483pa_tsies
paunches1568173paunches
pauses84621473pa_us_es
pavise114714803pavis_e_
paviser12489093pavis_er
pavisers13387443pavisers
pavisse12546813pavisse_
pearlashes1543263pearlashes
peises84125043p_eis_es
pelisses1048483pelisses
penises9318193penis_es
perches143717953per_ches
perigees1189503perigees
periques1937663periques
perish114619063perish__
perses85428063per_s_es
peruses94018163perus_es
pharisee1347613pharis_ee
pharoses13310323pharos_es
phrases12711463phras_es
pigfishes1845003pigfishes
pinfishes1746243pinfishes
pished124817063p__ished
pisher114317753p__isher
pishers123815753p__ishers
pisses84525083p__isses
pistes85325633p__istes
planished1566123planished
planisher1495853planisher
planishers1584773planishers
plashes124417393p_lashes
plenishes1487083plenishes
plisses94411773p_lisses
plushes124313673p_lushes
poises84226543p_ois_es
polarises11514073polaris_es
polished1468433polished
polisher1388073polisher
polishers1477603polishers
porches143815673por_ches
porisms113713453poris_ms
potashes1337833potashes
potiches1539203potiches
prairies10411463prairies
praise84419413prais_e_
praised104214813prais_ed
praiser93413943prais_er
praisers103410843praisers
prases84429023p_ras_es
praxises1739063praxis_es
presses93523153p_resses
prices104524543p_ri_ces
prides94324183p_ri_des
pries74339533p_ri__es
primes104225263p_ri_mes
princes113015153p_rinces
prise74632613p_ris_e_
prised94322203p_ris_ed
priseres10310823p_riseres
prisms104915503p_ris_ms
prisons9313223p_risons
priss74623893p_ris__s
prissed103311263p_rissed
prissies101712003p_rissies
prithee1239933p_rithee
privies122414263p_rivies
prizes173819813p_ri_zes
proses84733473p_ros_es
prosses94019513p_rosses
publishes1645933publishes
puisnes937423p_uisnes
punished1436043punished
punisher1335773punisher
punishers1434973punishers
pupfishes1944313pupfishes
purifies13311933purifies
purines94420773puri_nes
purisms114110833puris_ms
purists94014073puris_ts
purities10316283purities
purses84826373pur_s_es
pursues94111373pur_sues
pushes114621663p__ushes
pyrites12812203pyri_tes
qurshes19228573qur_shes
qurushes2034943qurushes
raises64826543ra_is_es
rarifies11311943rarifies
rarities8316333rarities
rashes95330153__rashes
ratfishes1546103ratfishes
ravished1555713ravished
ravisher1465463ravisher
ravishers1564783ravishers
relishes11311953relishes
rerises73525883reris_es
reshes94124363__reshes
riches115022083__riches
rises55244043__ris_es
rishis9312453__rishis
rushes94724363__rushes
saroses73619333saros_es
sashes94728483sa__shes
sawfishes1845743sawfishes
spearfishes1953163spearfishes
squishes20198393squishes
starfishes1646153starfishes
swishes133411373_swishes
tamises92715973tamis_es
tapises92914013tapis_es
tarbushes1444883tarbushes
tarnished13196063tarnished
thrashes1487653thrashes
threshes1437383threshes
thrushes1436523thrushes
tovarishes1643353tovarishes
trashes104119263_trashes
unwishes14147483unwishes
upraises10188473uprais_es
uprises92012733upris_es
uprushes13194863uprushes
valises103516263valis_es
vanished15207753vanished
vanisher14167463vanisher
vanishers15186613vanishers
variates111214983variates
varices123313573vari_ces
varies94330873vari__es
varioles11711133varioles
varnished16195603varnished
varnisher15195403varnisher
varnishers16174343varnishers
varuses10310623varus_es
wampishes1944303wampishes
warisons1136903warisons
warsles103413643war_sles
washes124425493wa__shes
whishes16309443_whishes
wishes124920953__wishes
writhes134811703_writhes

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.436409841.7
2DLD Change Limit1461623787.97018339.0
3Display Results3783780.1562423.1
 (SQL Overall)1786913788.56220870.2
 
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.