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

317 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
apheses1261070(None) 
aphesis12610511aphesis
achenes12313492achenes
adheres11310162adheres
antheses11311472antheses
apexes1539132ap_exes
aphereses1466422aphereses
aphides134711202aphides
appeases1238662appeases
apposes11511472apposes
apses76823912ap__ses
asceses938622asceses
askeses1136462askeses
auxeses1435622auxeses
ephebes1436152ephebes
pareses94718882pareses
phases114618402_phases
physes14399782_physes
sphenes123013162sphenes
spheres123114352spheres
theses96517972_theses
abases85720773a_bases
abbess10509773abbes_s
abbesses1235333abbesses
abeles84719393a_beles
abioses9311493abioses
abuses85119103a_buses
abysses1234863abysses
accedes1237713accedes
access1037673acces_s
accesses1287493accesses
accuses114112193accuses
achene11313813achene_
aches106132293ach__es
achieves1645523achieves
ackees124914573acke_es
adhere10310333adhere_
adhered1239233adhered
adherer1137563adherer
adherers1296913adherers
adhesives1643093adhesives
advises11138973advises
aedes64625143a__edes
aegises8311373aegises
agenes74720253a_genes
ageneses939303ageneses
agrees74915323agre_es
akees96119243a_ke_es
akenes104817343a_kenes
aldoses8311203aldoses
aliases7914493aliases
alkenes114212753alkenes
allees64521483alle_es
alleges84212563alleges
alleles73812033alleles
alphosis1347273alphosis
amasses93912853amasses
amperes11313983amperes
amuses85117943a_muses
anaphases1446523anaphases
aneles64626293a_neles
anises64826693a_nises
ankuses1148203ankuses
anlases72514903anlases
annexes1437203annexes
anopheles1446633anopheles
anthesis11312493anthesis
anureses837973anureses
anuses66218773a_nuses
apaches143411833apaches
apeek114711873ap_e_ek
aperies9423203aperies
apers76629133ap_e_rs
apes66047433ap___es
aphaereses1553163aphaereses
aphasia122510873aphasia
aphasias132710433aphasias
aphasic142810063aphasic
aphasics15257233aphasics
aphelia1249423aphelia
apheresis1475333apheresis
aphetic142912853aphetic
aphids125110843aph_ids
aphis105917133aph__is
aphorises14310003aphorises
apices104916263ap_ices
apiece10510083apiece_
aplites9314933aplites
apneas83211383apne_as
apoapses1244713apoapses
apodoses1136653apodoses
apogees1037103apogees
apophases1647973apophases
apophyses1946113apophyses
apotheces1644013apotheces
apotheoses1543853apotheoses
appeals11378673appeals
appears11308953appears
appease1137913appease_
appeased1335793appeased
appeaser1245953appeaser
appeasers1345263appeasers
appels104312793appe_ls
appends1236393appends
apples104315763ap_ples
applies11311213applies
appose10411993appose_
apposed1247853apposed
apposer1147483apposer
apposers1236283apposers
apprises12310963apprises
appulses1234893appulses
apres75426403ap__res
apse67725383ap__se_
apsides103911303apsides
apsis75718293ap__sis
aptest82917513aptes_t
aptness9268573aptnes_s
aptnesses11168993aptnesses
apyrases1337243apyrases
arcuses94814693arcuses
arenes64928393a_renes
aretes64425353a_retes
arguses84711743arguses
arises65233803a_rises
arkoses113910833arkoses
arouses74921293arouses
arrases71214543arrases
arrests73312683arrests
arrises71617583arrises
arses55733873a__rses
ascesis938373ascesis
asepses946363asepses
ashes86230613ash__es
ashless10318453ashles_s
askesis1136123askesis
asperses104111673asperses
aspises9611643aspises
asses55629283a__sses
assess65710463asses_s
assesses737383assesses
atheisms1346913atheisms
atheists1138703atheists
athetoses1244973athetoses
athletes1157883athletes
atlases72410643atlases
attests7278813attests
auxesis1445443auxesis
avenses1049643avenses
avgases11106313avgases
avulses1035433avulses
awless939263awles_s
axises134413993a_xises
baptises1238923baptises
bathoses13310453bathoses
behests1235953behests
beses75830723__beses
camphenes1846463camphenes
capiases1239253capiases
capless114312763caples_s
cathexes2036273cathexes
chases115128233_chases
cheeses123613103cheeses
chess105016923_ches_s
chesses124112633_chesses
chests114916263_chests
choses115825123_choses
coheres122917693coheres
creeses93914623creeses
cyeses11510123_cyeses
cypreses1535143cypreses
daphnes13327683daph_nes
diaphyses1844123diaphyses
diatheses1345893diatheses
dieses75218693_dieses
emeses86114963_emeses
emphases1568353emphases
epees75219833ep_e_es
ephebe1336063ephebe_
ephebos1444113ephebos
ephebus1443283ephebus
eposes84418783ep_oses
eses45336103___eses
estheses1137783estheses
ethenes103313873ethenes
ethoses10311753ethoses
gapless10349993gaples_s
geneses82613523geneses
ghees95215553_ghe_es
graphemes1743633graphemes
hapless123311333haples_s
haploses1338853haploses
haptenes133810823haptenes
hebes105521673__hebes
hemes105031083__hemes
heres86245903__heres
hests85829933__hests
hexes155123043__hexes
hoses85443173__hoses
imphees1436693imphe_es
impreses1238093impreses
inheres10315173inheres
joneses1438963joneses
kineses113111253kineses
kyphoses2045283kyphoses
lapises93513463lap_ises
lapses85217693lap__ses
leses54930813__leses
machetes1539633machetes
mimeses1139073mimeses
napless93110283naples_s
nemeses948663nemeses
ophites12310103ophites
opposes1149243opposes
opuses84012243op_uses
papooses1248053papooses
paresis93315093paresis
parises94827183parises
parses85534703_parses
pases75346503_p_ases
passes86030473_passes
pathoses13412763pathoses
pauses84621473_pauses
pavises125315493pavises
payees114812903paye_es
peases85229473_peases
pedes85327283_p_edes
pees65257373_p_e_es
peeves113814873_peeves
peises84125043_peises
pekes114623563_p_ekes
peles75738083_p_eles
penes75839223_p_enes
peres76246643_p_eres
perses85428063_perses
pesos77221623_p_esos
pests75933273_p_ests
phages125213513_phages
phase104617213_phase_
phased124011973_phased
phasis114614923_phasis
phereses1348093_phereses
phizes20389133_phizes
phoebes1435813_phoebes
phones114121213_phones
phrases12711463_phrases
phyleses1645183_phyleses
physed15386793_physed
physeds16344033_physeds
physis14359663_physis
pieces104217273_pieces
pisses84525083_pisses
pleases94515483_pleases
plebes104313623_plebes
plexes155313533_plexes
pluses83618073_pluses
poesies93217403_poesies
poises84226543_poises
poses74642763_p_oses
posses85128803_posses
prases84429023_prases
prees75937173_pre_es
prese75228383_prese_
preset84430983_preset
presets94216423_presets
press75425953_pres_s
presses93523153_presses
prests84021263_prests
prexes154915943_prexes
prezes173614693_prezes
prises84133173_prises
proses84733473_proses
ptoses83514673_ptoses
pulses83818663_pulses
purses84826373_purses
puses75532203_p_uses
pusses84322843_pusses
pyoses114314303_pyoses
rachises131412413rachises
raphes115117453raph__es
raphides14188393raphides
rappees113611453rappe_es
rhemes115913183_rhemes
rhesus936203_rhesus
rhuses94911793_rhuses
sapheads1466083sapheads
saphenas1345713saphenas
sapless93313443saples_s
schemes1489663schemes
spahees1238263spahe_es
speises93813933speises
spenses92913573spenses
sphene113412403sphene_
sphere113313653sphere_
sphered133512313sphered
spouses92912813spouses
sprees85620643spre_es
tapholes1339623tapholes
taphouses1446553taphouses
tapises92914013tap_ises
teleses7313123teleses
thebes115914493_thebes
themes115319253_themes
theres96525473_theres
these86519013_these_
thesis94913733_thesis
thesps11448263_thesps
tmeses85712243_tmeses
trapeses1039153trap_eses
typhuses1643763typhuses
upases84112903up_ases
upheaps1494233upheaps
upheaves1643913upheaves
uphroes1236303uphroes
uprises92012733uprises
wheres125917433_wheres
yeses85119323__yeses

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340273178.34616058.8
3Display Results3173170.1102881.8
 (SQL Overall)1786913178.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.