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

345 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
perishes1331375(None) 
parishes13314751parishes
perished14310081perished
cerises94722252ceris_es
cherishes1767562cherishes
dervishes1644932dervishes
fetishes1437152fetishes
marishes13512552marishes
merises93421422meris_es
parises94827182paris_es
peises84125042pe_is_es
pelisses1048482pelisses
penises9318192penis_es
perches143717952per_ches
perigees1189502perigees
periques1937652periques
perish114619062perish__
perses85428062per_s_es
peruses94018162perus_es
pishes114722102p__ishes
plenishes1487082plenishes
polishes13711782polishes
prises84133172p_ris_es
prisses94816712p_risses
punishes1338112punishes
relishes11311952relishes
rerises73525882reris_es
aegises8311373aegis_es
aeries64737783aeri__es
aerifies111313393aerifies
aperies9423203aperi__es
apprises12310963appris_es
arises65233803_aris_es
arrises71617583arris_es
banishes131812463banishes
bekisses1434243bekisses
berimes115216643beri_mes
betises94816123betis_es
blemishes1665083blemishes
brashes124518463_brashes
brises84927613_bris_es
brisses94314313_brisses
brushes124014663_brushes
burnishes1436643burnishes
cerastes101111093cerastes
cercises12410933cercis_es
ceriphs1484753ceriph_s
cerise84822043ceris_e_
cerites94823433ceri_tes
ceruses93716233cerus_es
ceviches1834843ceviches
cherished1865193cherished
cherisher1765233cherisher
cherishers1854553cherishers
clerisies1147253clerisies
crashes124618403_crashes
creeshes1336953creeshes
crises84529433_cris_es
crushes124215133_crushes
cuishes122810823_cuishes
danishes121710493danishes
deashes113313903de_ashes
dehisces1464713dehisces
demises103719563demis_es
derides93420853deri_des
derives114017813deri_ves
dermises112512023dermis_es
derrises93012783derris_es
devisees12358283devisees
devises114116763devis_es
dishes104622653__dishes
egises7312493_egis_es
enisles72312603_enisles
enriches1337263enriches
erases64425403_eras_es
eroses65327053_eros_es
erses55826803_er_s_es
famishes1658283famishes
ferities111416713ferities
fetiches1636953fetiches
finishes1438983finishes
fishes125221343__fishes
flemishes1765243flemishes
freshes133515823_freshes
frisees104411693_frisees
frises94124273_fris_es
furbishes1745243furbishes
furnishes1536233furnishes
garfishes16167083garfishes
garnishes13198813garnishes
geishas1135083ge_ishas
girshes11248293gir_shes
gurshes112210033gur_shes
heresies11312693heresies
inrushes1136273inrushes
irises64221173_iris_es
jewfishes2543383jewfishes
kermises14248313kermis_es
knishes1438263_knishes
krises105016083_kris_es
lavishes1457403lavishes
leashes103514403le_ashes
lewises1039133lewis_es
lorises73918593loris_es
marshes123615373mar_shes
menshes12310453me_nshes
merches144013763mer_ches
merisis93213173meris_is
meristem1245743meristem
meristems1343553meristems
meshes115019443me__shes
metisses1036833metisses
minishes13310583minishes
monishes13311483monishes
nebbishes1642973nebbishes
nourishes12116733nourishes
oarfishes15156953oarfishes
onrushes1135213onrushes
orishas1036473_orishas
orrises71312233orris_es
overfishes1947013overfishes
panfishes1737593panfishes
parches143720003par_ches
pareses94718883pares_es
pariahs123812343pariah_s
paries84742513pari__es
parietes10714543parietes
parish115022353parish__
parities10522973parities
parses85534703par_s_es
parvises133911913parvis_es
pashes115828393p__ashes
pavises125315493pavis_es
pavisses13397103pavisses
peaches144120053pe_aches
pearlashes1543263pearlashes
peases85229473pe_as_es
pedicles1338683pedicles
peeresses1138473peeresses
peeries93623023peeri__es
peise75825773pe_is_e_
peised94817683pe_is_ed
pelisse967063pelisse_
pelites93821993peli_tes
pelvises1337273pelvis_es
penoches1538933penoches
pensees9311203pe_nsees
penuches1536943penuches
pepsines1239883pepsines
percales12313803percales
perched154713243per_ched
percher143313423per_cher
perchers153611523per_chers
percusses1346503percusses
perdues103511333per_dues
perdures11289683perdures
peres76246643per___es
perfidies1546603perfidies
perfumes1555893perfumes
perfuses1358663perfuses
periapses1346053periapses
periapts1237273periapts
periblem1445513periblem
periblems1543483periblems
pericopes1547873pericopes
peridots1138323peridots
perigee101113393peri_gee
perigons11310083perigons
periled10316323peri_led
perillas10310823perillas
perilled11410113perilled
perilous10310693perilous
perils84121853peri__ls
perilunes1147163perilunes
perinea9313033peri_nea
periods10312243peri_ods
periostea1144783periostea
periphery1943843periphery
peripter1278753peripter
peripters1368123peripters
perique1837523perique_
peris75537073peri___s
perisarc1245363perisarc
perisarcs1344093perisarcs
periscopes1646353periscopes
perishables1852823perishables
perishing1539533perishing
peristomes1446053peristomes
peristyles1543863peristyles
peritus9311803peri_tus
periwigs1444193periwigs
perjures17268083perjures
perkish16258823perkish__
perlites10316363perlites
permutes1238713permutes
perniones1148593perniones
perries93226603per_ries
perse75429523per_s_e_
persisted1247143persisted
persister1146833persister
persisters1246273persisters
persists1049183persists
persons93717013per_sons
perspex1834183per_spex
pertusses1145383pertusses
perukes133210113per_ukes
perusals1047143perusals
peruse84016843perus_e_
perused103112193perus_ed
peruser93511373perus_er
perusers10328803perusers
pervades1437353pervades
petioles10311643petioles
petites93820203peti_tes
petrifies14310363petrifies
pharisees1444633pharisees
phereses1348093pheres_es
phrases12711463phras_es
pigfishes1845003pigfishes
pinfishes1746243pinfishes
pipefishes2043793pipefishes
pished124817063p__ished
pisher114317753p__isher
pishers123815753p__ishers
pisses84525083p__isses
pistes85325633p__istes
planishes14138523planishes
plashes124417393p_lashes
plenished1584953plenished
pleurisies1243173pleurisies
plisses94411773p_lisses
plushes124313673p_lushes
poetises10313953poetis_es
poises84226543p_ois_es
polished1468433polished
polisher1388073polisher
polishers1477603polishers
porches143815673por_ches
porisms113713453poris_ms
potashes1337833potashes
potiches1539203potiches
praises94121103prais_es
prases84429023p_ras_es
preaches153214893preaches
precises123218333precis_es
premises123018273premis_es
premisses13288763premisses
prerinses1138813prerinses
presides11414913presides
presses93523153p_resses
previses133814283previs_es
prewashes1744753prewashes
prices104524543p_ri_ces
prides94324183p_ri_des
pries74339533p_ri__es
primes104225263p_ri_mes
princes113015143p_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
purifies13311923purifies
purines94420763puri_nes
purisms114110833puris_ms
purists94014073puris_ts
purities10316283purities
purses84826373pur_s_es
pursues94111373pur_sues
pushes114621663p__ushes
pyrites12812203pyri_tes
qurshes19228573qur_shes
qurushes2034943qurushes
radishes1269463radishes
rashes95330153__rashes
ravishes1478043ravishes
redfishes1645793redfishes
refreshes1595953refreshes
rehashes1436953rehashes
relished1239433relished
remises93423483remis_es
reprises102615463repris_es
reraises8415643rerais_es
rerise64325633reris_e_
rerisen73613643reris_en
reshes94124363__reshes
revises104220533revis_es
rewashes1447033rewashes
riches115022083__riches
rises55244043__ris_es
rishis9312453__rishis
rushes94724363__rushes
seiches12513813se_iches
seises64026713se_is_es
semises93916553semis_es
seriates82620673seriates
series64540973seri__es
serines74229543seri_nes
seviches1635803seviches
spearfishes1953163spearfishes
speises93813933spe_is_es
speisses10245693spe_isses
squishes20198393squishes
swishes133411373_swishes
tarnishes12188893tarnishes
thrashes1487653thrashes
threshes1437383threshes
thrushes1436523thrushes
trashes104119263_trashes
unwishes14147483unwishes
uprises92012733upris_es
uprushes13194863uprushes
vanishes141610753vanishes
varnishes15207913varnishes
verifies141313483verifies
verismos13284693verismos
verisms123011253veris_ms
verists103613673veris_ts
verites103822263veri_tes
verities111418043verities
verses94223763ver_s_es
versines112213823versines
verstes104014283ver_stes
viperfishes2252503viperfishes
welshes13379093we_lshes
whishes16309443_whishes
wishes124920953__wishes
writhes134811703_writhes
xeroses143612823xeros_es
xeruses143010753xerus_es
yperites13310153yperi_tes

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.406440125.6
2DLD Change Limit1461623457.50019488.3
3Display Results3453450.1402464.3
 (SQL Overall)1786913458.04622208.7
 
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.