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

175 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
aphesis1261051(None) 
apheses12610701apheses
alphosis1347272alphosis
anthesis11312502anthesis
aphasia122510872aphasia
aphasias132710432aphasias
aphasic142810062aphasic
aphasics15257232aphasics
aphelia1249422aphelia
apheresis1475332apheresis
aphetic142912852aphetic
aphis105917132aph__is
apsis75718292ap__sis
ascesis938372ascesis
askesis1136122askesis
auxesis1445442auxesis
paresis93315092paresis
phasis114614922_phasis
physis14359662_physis
thesis94913732_thesis
abbess10509773abbes_s
abiosis939373abiosis
access1037683acces_s
achenes12313493achenes
aches106132293ache__s
adheres11310163adheres
adhesion1244433adhesion
adhesions1343793adhesions
adhesive1543803adhesive
adhesives1643093adhesives
aegis6316783a__egis
agenesis938043agenesis
ahis76135383a_h__is
amnesia938293amnesia
amnesias1047833amnesias
amnesic1137183amnesic
amnesics1255283amnesics
antheses11311473antheses
anuresis846963anuresis
aperies9423203ap_eries
apers76629133ap_e_rs
apes66047433ap_e__s
apexes1539133ap_exes
aphaeresis1562743aphaeresis
aphagia13247663aphagia
aphagias14237343aphagias
aphasiac15286593aphasiac
aphasiacs16254223aphasiacs
aphelian1376963aphelian
aphelion1375623aphelion
aphelions1474813aphelions
aphereses1466423aphereses
aphid115515393aph__id
aphides134711203aphides
aphids125110843aph_ids
aphonia122711883aphonia
aphonias132611143aphonias
aphonic142713393aphonic
aphonics15259523aphonics
aphorise1339983aphorise
aphorism1548643aphorism
aphorist13412503aphorist
aphotic142913123aphotic
aplasia92510803aplasia
aplasias10279233aplasias
apneas83211383apne_as
apneic1078623apne_ic
apoapsis1244093apoapsis
apodosis1146583apodosis
apophasis1646993apophasis
apophysis1956013apophysis
apotheosis1553653apotheosis
appeals11378673appeals
appears11308953appears
appeases1238663appeases
appels104312793appe_ls
appends1236393appends
apposes11511473apposes
apres75426403apre__s
apses76823913ap__ses
apteria9312913apteria
aptest82917513aptes_t
aptness9268573aptnes_s
arrests73312683arrests
arsis55722423a__rsis
asceses938623asceses
asepsis985903asepsis
ashes86230613ashe__s
ashless10318453ashles_s
askeses1136463askeses
aspheric1547983aspheric
assess65710463asses_s
atheism1248523atheism
atheisms1346923atheisms
atheist10314063atheist
atheists1138713atheists
athetosis1244643athetosis
atresia7310223atresia
atresias839473atresias
atresic9310003atresic
attests7278813attests
auxeses1435623auxeses
awless939263awles_s
behests1235953behests
capless114312763caples_s
cathexis2045753cathexis
chess105016923_ches_s
chests114916263_chests
cyesis1148573_cyesis
diaphysis1844063diaphysis
diathesis1345533diathesis
diesis74013493_diesis
ecesis84611203_ecesis
emesis84712623_emesis
emphasis15117673emphasis
ephebes1436153ephebes
ephebi1345083ephebi_
ephebic1646513ephebic
ephebos1444113ephebos
ephebus1443283ephebus
esthesis1148463esthesis
gapless10349993gaples_s
gaposis1038423gap_osis
genesis82510823genesis
hapless123311333haples_s
haplosis1347093haplosis
hests85829933__hests
kinesis11259593kinesis
kyphosis2045173kyphosis
mimesis1137323mimesis
napless93110283naples_s
nemesis937373nemesis
noesis6311443_noesis
pachisis15268823pachisis
parchesis16318213parchesis
pareses94718883pareses
penis75129323_p_enis
peris75537073_p_eris
pesos77221623_p_esos
pests75933273_p_ests
phases114618403_phases
phasic133612053_phasic
phenix1837133_phenix
pheresis1377633_pheresis
phis95724903_ph__is
phylesis1645313_phylesis
physes14399783_physes
physic16288473_physic
physics17265963_physics
poesies93217403_poesies
precis103416703_precis
press75425953_pres_s
prests84021263_prests
psis68120343_p__sis
ptosis83611823_ptosis
pyosis114012123_pyosis
raphes115117453raphe__s
raphis114014323raph__is
rhesus936203_rhesus
sapheads1466083sapheads
saphenas1345713saphenas
sapless93313443saples_s
speiss84311643sp_eiss
sphenes123013163sphenes
sphenic1449093sphenic
spheres123114353spheres
spheric14510073spheric
spherics1537073spherics
synesis1039163synesis
telesis7310793telesis
theses96517973_theses
thesps11448263_thesps
tmesis8529793_tmesis
upheaps1494233upheaps
whosis1237173_whosis

Search took 7 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.546327272.9
2DLD Change Limit1340271755.90622693.4
3Display Results1751750.0632777.8
 (SQL Overall)1786911756.51527427.6
 
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.