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

314 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
marishes1351255(None) 
marshes123615371mar_shes
parishes13314751parishes
arises65233802_aris_es
banishes131812462banishes
danishes121710492danishes
famishes1658282famishes
garfishes16167082garfishes
garnishes13198812garnishes
lavishes1457402lavishes
marches143921172mar_ches
marines93928012mari_nes
marish114319052marish__
marses84827112mar_s_es
mashes115030002ma__shes
mavises122812992mavis_es
merises93421422meris_es
minishes13310582minishes
monishes13311482monishes
oarfishes15156952oarfishes
parises94827182paris_es
perishes13313752perishes
radishes1269462radishes
ravishes1478042ravishes
tarnishes12188892tarnishes
vanishes141610752vanishes
varnishes15207912varnishes
abashes12510373_abashes
airshed11258533_airshed
airsheds12274963_airsheds
aisles64721143_a_isles
ambushes1535803ambushes
anises64826693_anis_es
arches114822043_ar_ches
arise56436433_aris_e_
arisen65316793_aris_en
aristas7413523_aristas
aristos7312373_aristos
arrises71617583arris_es
arses55733873_ar_s_es
arsines73518813_arsines
artistes83213343_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
calashes13310533calashes
caliches153812263caliches
camises114218463camis_es
caresses10314063caresses
caribes113715643cari_bes
carices114220953cari_ces
caries85147623cari__es
carioles10817073carioles
caroches15710693caroches
carses85233653car_s_es
carwashes1745773carwashes
cashes114729883ca__shes
catfishes1746303catfishes
cerises94722253ceris_es
cherishes1767563cherishes
crashes124618403_crashes
crises84529433_cris_es
crushes124215133_crushes
cuishes122810823_cuishes
daises74318983da_is_es
daisies84217093da_isies
darioles9710693darioles
dashes106124983da__shes
dervishes1644933dervishes
dishes104622653__dishes
earaches13411303earaches
emprises12311003empris_es
enriches1337263enriches
evanishes1545603evanishes
famished1766023famished
farinhas14325363farinhas
farsides1237993farsides
fashes124524023fa__shes
fetishes1437153fetishes
finishes1438983finishes
fishes125221343__fishes
fraises104215693frais_es
freshes133515823_freshes
frisees104411693_frisees
frises94124273_fris_es
furbishes1745243furbishes
furnishes1536233furnishes
galoshes1236903galoshes
gamashes1456943gamashes
garigues1034953garigues
garish104516923garish__
garishly1545693garishly
garishness1445743garishness
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
larches124416443lar_ches
lashes94831003la__shes
lavashes1445573lavashes
lavished1555133lavished
lavisher1445083lavisher
lavishers1564643lavishers
lavishest1554883lavishest
lorises73918593loris_es
maches134827233ma__ches
madrases112610003madras_es
magister1136283magister
magisters1235803magisters
maharishis1852603maharishis
maihem1366213ma_i_hem
maihems1444303ma_i_hems
mailes84329113ma_i_les
maists85817573ma_is_ts
maizes175115733ma_i_zes
malaises10312333malais_es
malices114316623mali_ces
malines93625603mali_nes
malisons1048783malisons
mamies104626243mami__es
manches143818623ma_nches
manilles102312603manilles
maniples12269423maniples
manses84225513ma_ns_es
mantises10317923mantis_es
marascas1247383marascas
marasmus1244473marasmus
marbles114516653mar_bles
marched153813403mar_ched
marchen143312073mar_chen
marcher143912973mar_cher
marchers153710813mar_chers
marchesa15346883mar_chesa
marchese15358913mar_chese
marchesi15337323mar_chesi
mares76457633mar___es
marges94525713mar__ges
mariachis1644703mariachis
marimbas1444363marimbas
marinades12268973marinades
marinas93519383mari_nas
marinates112516383marinates
marine84230403mari_ne_
mariner93315993mari_ner
mariners103113863mariners
marksmen1644533marksmen
marlines103818713marlines
marlites103415263marlites
marmites122212793marmites
marquees19206243marquees
marques182610863mar_ques
marquises20225703marquis_es
marriages1247383marriages
marries93825283mar_ries
marse76231153mar_s_e_
marsh105320853mar_sh__
marshal1238973mar_shal
marshals1337783mar_shals
marshier1337593mar_shier
marshiest1438103mar_shiest
marshy14558333mar_sh_y
mashed125325043ma__shed
masher114123203ma__sher
mashers124621053ma__shers
mashies12318253ma__shies
masses85028713ma__sses
mastiches1647333mastiches
matches143219783ma_tches
matinees102110423matinees
matrasses1157293matrasses
matrices12312083matri_ces
matrixes1738063matri_xes
mavies114923193mavi__es
maxixes1535253maxi_xes
maybushes1942443maybushes
menshes12310453m_enshes
merches144013763mer_ches
merisis93213173meris_is
meristem1245743meristem
meristems1343553meristems
meshes115019443m__eshes
metisses1036833metisses
miches134320733m__iches
minished1437873minished
mises74740563m__is_es
misses85130873m__isses
mitises9315543mitis_es
modistes1138643modistes
monished1438133monished
morasses1038903morasses
morrises10711073morris_es
mortises10713613mortis_es
moshes115222873m__oshes
mudfishes1844193mudfishes
muriates10312083muriates
murices112612283muri_ces
murines93718223muri_nes
mushes114124563m__ushes
nourishes12116733nourishes
onrushes1135213onrushes
orishas1036473_orishas
orrises71312233orris_es
panfishes1737593panfishes
parches143720003par_ches
pareses94718883pares_es
pariahs123812343pariah_s
paries84742513pari__es
parietes10714543parietes
parish115022353parish__
parities10522973parities
parses85534703par_s_es
parvises133911913parvis_es
pashes115828393pa__shes
pavises125315493pavis_es
pavisses13397103pavisses
perished14310083perished
pharisees1444633pharisees
pishes114722103__pishes
planishes14138523planishes
polishes13711783polishes
praises94121103prais_es
prises84133173_pris_es
prisses94816713_prisses
punishes1338113punishes
qurshes19228573qur_shes
qurushes2034943qurushes
raises64826543ra_is_es
rarifies11311933rarifies
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
smashes123914613sma__shes
squishes20198393squishes
starfishes1646153starfishes
swishes133411373_swishes
tamises92715973tamis_es
tapises92914013tapis_es
tarbushes1444883tarbushes
tarnished13196063tarnished
thrashes1487653thrashes
threshes1437383threshes
thrushes1436523thrushes
tovarishes1643353tovarishes
trashes104119263_trashes
unwishes14147483unwishes
uprises92012733upris_es
uprushes13194863uprushes
valises103516263valis_es
vanished15207743vanished
vanisher14167453vanisher
vanishers15186613vanishers
variates111214983variates
varices123313573vari_ces
varies94330873vari__es
varioles11711123varioles
varnished16195603varnished
varnisher15195403varnisher
varnishers16174343varnishers
varuses10310623varus_es
wampishes1944303wampishes
warisons1136903warisons
warsles103413643war_sles
washes124425493wa__shes
whishes16309443_whishes
wishes124920953__wishes
writhes134811703_writhes

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623146.70321805.5
3Display Results3143140.1402242.9
 (SQL Overall)1786913147.26324602.9
 
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.