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

218 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
perished1431008(None) 
perishes13313751perishes
cherished1865192cherished
parishes13314752parishes
peised94817682pe_is_ed
perched154713242per_ched
periled10316322peri_led
perilled11410112perilled
perish114619062perish__
persisted1247142persisted
perused103112192perus_ed
pished124817062p__ished
plenished1584952plenished
polished1468432polished
prised94322202p_ris_ed
prissed103311262p_rissed
punished1436042punished
relished1239432relished
aeried74221863aeri__ed
aerified121310133aerified
airshed11258533air_shed
apprised1337713appris_ed
banished14189063banished
bekissed1543163bekissed
bemisted1368383bemisted
berimed124912283beri_med
beringed1298173beringed
berthed13259123ber_thed
blemished1763783blemished
brisked144210003_brisked
brushed133811213_brushed
burnished1544923burnished
cerise84822043ceris_e_
cerises94722253ceris_es
cherisher1765233cherisher
cherishes1767563cherishes
crashed134214203_crashed
creeshed1435693creeshed
crisped124010103_crisped
crushed134111963_crushed
deashed123411303de_ashed
dehisced1583683dehisced
delisted10310563delisted
demised113613683demis_ed
derided102914253deri_ded
derived123912763deri_ved
dervishes1644933dervishes
desisted1039783desisted
devised123712563devis_ed
dished114318713__dished
enisled82510223_enisled
enriched1435863enriched
erased74816753_eras_ed
existed1538473_existed
famished1766023famished
fetishes1437153fetishes
finished1536483finished
fished134316313__fished
flemished1853633flemished
freshed143312593_freshed
frisked15478823_frisked
furbished1843773furbished
furnished1644583furnished
garnished14196143garnished
heisted113210653he_isted
irised73913153_iris_ed
lavished1555133lavished
leashed113211163le_ashed
marishes13512553marishes
merises93421423meris_es
meristem1245743meristem
merited10313853meri_ted
meshed124415933me__shed
minished1437873minished
monished1438133monished
neighed12135893ne_ighed
nourished1374603nourished
oersted839553oer_sted
overfished2045673overfished
parched154013693par_ched
parises94827183paris_es
parish115022353parish__
parsed96323893par_s_ed
pashed125923143p__ashed
peached154315883pe_ached
peched144915343pe__ched
pedicled1436463pedicled
peined94918843pe_i_ned
peise75825773pe_is_e_
peises84125043pe_is_es
pelisse967063pelisse_
pelisses1048483pelisses
penises9318193penis_es
percher143313423per_cher
perches143717953per_ches
percussed1444803percussed
perdured12287403perdured
perfumed1654543perfumed
perfused1445833perfused
periblem1445513periblem
perigee101113393peri_gee
perigees1189503perigees
perinea9313033peri_nea
period9314983peri__od
periodid1248163periodid
periostea1144783periostea
periphery1943843periphery
peripter1278753peripter
perique1837523perique_
periques1937653periques
peris75537073peris___
perisarc1245363perisarc
perishing1539533perishing
perjured18286273perjured
perked134617693per__ked
perkish16258823perkish__
permed115217353per__med
permitted1446653permitted
permuted1336713permuted
perse75429523per_s_e_
perses85428063per_s_es
persister1146833persister
perspex1834183per_spex
peruked14367893per_uked
peruse84016843perus_e_
peruser93511373perus_er
peruses94018163perus_es
pervaded1535373pervaded
petioled1137993petioled
petrified1548333petrified
phrased1387383phras_ed
pisher114317753p__isher
pishes114722103p__ishes
pissed94816933p__issed
pithed124615613p__ithed
planished1566123planished
plashed133712643p_lashed
plenishes1487083plenishes
poetised1138523poetis_ed
poised94918473p_ois_ed
polisher1388073polisher
polishes13711783polishes
praised104214813prais_ed
preached163412063preached
precised133213413precis_ed
premised133013193premis_ed
prerinsed1246323prerinsed
presided12410553presided
pressed103317313p_ressed
prevised143611073previs_ed
prewashed1843923prewashed
priced115018883p_ri_ced
pricked164613833p_ricked
prided103618033p_ri_ded
pried84426863p_ri__ed
priested1138393p_riested
prigged12398933p_rigged
prilled104713003p_rilled
primed115118913p_ri_med
primmed14388853p_rimmed
primped14479153p_rimped
prinked143412163p_rinked
printed104016373p_rinted
prise74632613p_ris_e_
prises84133173p_ris_es
prisoned1138813p_risoned
prisses94816713p_risses
prithee1239933p_rithee
prized184415393p_ri_zed
prosed94921093p_ros_ed
published1744343published
punisher1335773punisher
punishes1338113punishes
purified1438743purified
pursed95220883pur_s_ed
pursued10388133pur_sued
pushed125017463p__ushed
ravished1555713ravished
refreshed1685613refreshed
rehashed1536063rehashed
relishes11311953relishes
relisted9312623relisted
remised103516843remis_ed
reprised112012203repris_ed
reraised9312353rerais_ed
rerigged1136243rerigged
rerise64325633reris_e_
rerisen73613643reris_en
rerises73525883reris_es
resisted9312693resisted
revised113815483revis_ed
rewashed1546243rewashed
risked115514633__risked
rushed104419863__rushed
seised74218123se_is_ed
seriated92717023seriated
serifed11811463seri_fed
seriffed1594973seriffed
spearfished2052103spearfished
squished21186393squished
swished14418843_swished
tarnished13196063tarnished
thrashed1555363thrashed
threshed1535643threshed
trashed113514703_trashed
unfished15218293unfished
unrushed12247573unrushed
unwished15237833unwished
uprushed14234473uprushed
vanished15207743vanished
varnished16195603varnished
verified151510393verified
versed104515513ver_s_ed
weighed15135933we_ighed
welshed14277203we_lshed
whished17428023_whished
wished134417513__wished
writhed14389623_writhed

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.410435831.7
2DLD Change Limit1461622186.78021557.8
3Display Results2182180.0932344.1
 (SQL Overall)1786912187.28324535.4
 
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.